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 7698

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,

1766

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 3806

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

IBM,

1717

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 3860

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 2810

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 3659

Difference between Find and Read operation in ADABAS file.

Cognizant,

1 5497

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 2531

Un-Answered Questions { MainFrame }

what difference exists between control area and control interval?

1044

how will you find a string using pdm?

1151

how can we apply for HSBC exam(Mainframe) in India??? i went to their site and was told to submit my CV ,. etc..( totally confusing...)

2400

Can you name a few software running under the mainframe?

953

What are the two types of logging in the db2 database? Explain them.

1078

Explain 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 cics regions that share the same db2 subsystem?

1034

What is the purpose of record level identifier?

1126

What is the max length of sqlca?

1216

what is uni-rexx?

990

Explain the job statement in jcl?

1162

Please tell me how to read the records from a file with load an array of size with error conditions(The logic answer for this question is ARR is array of 99 elements Z-ADD 0 IDX *LOVAL SETLL FILE READ FILE 99 *IN99 DOWEQ *OFF IDX ANDLT 99 ADD 1 IDX MOVE FIELD ARR,IDX READ FILE 99 ENDDO).So,Please give me the complete of this code.

2521

how does the rpg element work?

1231

Explain control variable in online screens?

1004

What is bmp mode?

3541

What is dbrm in db2 database?

1118

For More Un-Answered { MainFrame } Questions Click Here