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 2452

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 2436

how to create physical file

1 1694

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

1331

How to override loadlib?

Fiserv,

1406

When it is desirable to describe files Internally?

1166

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,

1098

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

IBM,

1063

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 2105

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

1 2350

what is the use of keep and pass in disp

1 2089

How to create delta file using JCL

CTC,

1 2638

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

Danske,

1 2890

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

989

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

1144


Un-Answered Questions { MainFrame }

What is the need of base registers in IBM 360/370?

2265


How is the record format of an output dataset specified?

726


Explain the device independent method to indicate where a record is stored?

464


How to send a sms to a mobile through mainframe vm’s?

545


Explain the system transid cemt?

576






explain about maximum displacement and how to cross this limit?

684


what is the difference between call and ++call?

1393


When output dataset space is required, what quantity categories are used?

806


Explain the difference between exec cics handle condtion and an exec cics ignore command?

569


What is the function of finish in idms?

475


What are the cics transactions?

558


In a CICS program, how will you read a VSAM file?

640


Explain the difference between various read and find statement and which one should be used when for better adabas performance?

569


Explain the hierarchy levels in jcl?

1103


What is the syntax for creating a table in the db2 database?

614