MainFrame Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

IBM MainFrame (5234)
IBM AS400 (1355)
IBM PL/1 (31)

MainFrame Interview Questions

Questions Answers Views Company eMail

How to get only unique records from a file which contains duplicate data using CPYF command ? Example : FILEA has duplicate records and FILEB is a UNIQUE defined.... and I want to get the data from FILEA to FILEB by eliminating all the duplicate records...

2 7694

How do you proceed in case your active AS400 session has got disconnected suddenly, how can you get back to your session ? Is it possible??

1 4240

What is a record lock error?

Wipro,

1763

In case if I want to know whether a record exists in a file, which one do you prefer CHAIN or a SETLL and why ?

1 3804

any one have give AS400 study material? pls pass it to gopalsai789@gmail.com

IBM,

1714

How to create a login screen using a command instead of display file.... intention is to get a password field on a command..... how do you achieve this...

1893

I have a file .In that file i have 3 fields. Those fields are eno, ename, esal.Keyfield is eno. In that file i have data like this for eno 1,2,3,4,5. Now i need to display 2nd record. That means i need to set the pointer on 2nd record... Then, write the complete rpg program using setll.

1 3859

What is SQL Code -904 and -903 in DB2 And how to handle it?

IBM,

1 7295

Why we should use cursor ?

3 4245

I know my query will return more than one row but I don't want cursor what should I do?

1 3441

How can you get the number of rows impacted by the last executed query?

1 2809

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

JPMorgan Chase,

2331

How to fetch the uncommited data from table ?

JPMorgan Chase,

1 3657

Difference between Find and Read operation in ADABAS file.

Cognizant,

1 5495

I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.

Cap Gemini,

1 2530

Un-Answered Questions { MainFrame }

how is the future of tandem mainframe?

3380

which cics service transaction is used to gain accessibility to cics control tables? Mention the one that has the highest priority.?

1184

Explain how do you access the records randomly in tsq?

1107

what do you mean by define model parameter?

1151

What are the types of data structure in as400?

1037

what is the maximum number of files allowed in rpg?

1640

What is the use of runstats in db2?

1110

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3157

How joinkeys helps in sort?

992

Program A (Normal COBBAT) calling a B Program (DB2COBOL, COBBATDB which is using a VSAM file. its a dynamic call. How we will handle VSAM file decleration in our from JCL from where we are running A PGM. And should we have PLAN for A pGM also. if possible can some one post a sample JCL. Thanks for help in advance.

5748

What are the different commands used in idcams for vsam?

1064

Explain the three location modes?

900

maximum number of subfiles that can defined in a rpg program for one display file is?

1992

What is the need of running runstats in the test environment?

1076

What is the difference between db2 and oracle?

1133

For More Un-Answered { MainFrame } Questions Click Here