MainFrame Interview Questions
Questions Answers Views Company eMail

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

TCS,

1 2435

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

TCS,

1 2411

how to create physical file

1 1683

I have 60 steps in the JCL and want to Execute Only First from PROC by overriding in JCL ?

1319

How to override loadlib?

Fiserv,

1385

When it is desirable to describe files Internally?

1158

I have File 1 occurs 5 times with Employee-ID,Employee-Name,Employee-Dept (EEE and MECH). I have File 2 occurs 10 times with Employee-ID,Employee-Name,Employee-Dept (EEE,CIVIL,CHEMICAL and MECH). In FIle 1 and FIle 2 , for matching Employee-DEPT (Only MECH) , we need to move entire records from file1 to file 2. We should not use 2D array. Your help is needed here.

Steria,

1082

How Chain operation copies the record's data to the input buffer for the program?

IBM,

1054

Hi Guys, I have faced one interview question if I have requirement to add 5 new columns to existing table what are prerequisite do i need to take.

1 2084

Difference between file status codes 02 and 22.... since both are for duplicate key detection.

1 2308

what is the use of keep and pass in disp

1 2068

How to create delta file using JCL

CTC,

1 2612

How can you find out which query is taking lot of time to execute in cobol-db2 program ?

Danske,

1 2867

Which command can you use to check for the number of records in a physical file?

980

How we will get issues on AS/400 technology ? I mean which issue/Defect Tracking tool is using in all companies when any issue comes? Can anybody explain about the work flow of AS/400 project ? plzzz

1133


Un-Answered Questions { MainFrame }

Mention the various locks that are available in db2.

592


Define cobol coding sheet?

548


How do get the result of your program directly on your pc?

1848


Explain the difference between pseudo-conversational and conversational?

537


What is the primary aspect of CICS?

636






How do you submit a job for execution?

611


How connect db2 database to datastage?

739


If I want to execute Sftp commands(LS & GET) stored in Physical file from CL program automatically...Can u Plz tell me how can I do this?...How the script will look?? THANX FOR NY HELP...

2155


In sms datasets, what is the function of the dd mgmtclas keyword?

834


Is condition checking possible in jcl?

691


What is the utilization of copybook in cobol?

632


Db2 what is the difference between a package and a plan. How does one bind 2 versions of a cics transaction with the same module name in two different cicsregions that share the same db2 subsystem?

612


Why adabas is used?

517


specify the requirements for automatic task initiation. (Mention the control table, it is entries and the corresponding procedure division cics command).?

666


Define an asra abend?

577