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 7692

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 4238

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,

1713

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...

1887

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 3858

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

IBM,

1 7293

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 3435

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

1 2804

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,

2324

How to fetch the uncommited data from table ?

JPMorgan Chase,

1 3651

Difference between Find and Read operation in ADABAS file.

Cognizant,

1 5491

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 2525

Un-Answered Questions { MainFrame }

name a few common vsam status codes?

1060

What guidelines should be followed to write a structured cobol prgm?

1148

Define base cluster?

1005

what will happen if there is no secondary allocation made for datasets?

1110

what is the compile process of cobol program expalin with code

2579

how can I automatically refresh a web page?

1062

what are members?

1057

What is the function of the steplib dd statement?

1196

define the purpose of the iter operation?

1845

how will you search an array?

1086

Define static linking and dynamic linking.

1190

what does the opcode free do?

1950

Which are the db2 tools to protect integrity of the database?

1120

is there any way to execute more than one proc in the same exec statement at the same time..?

2632

Can you explain multitasking and multithreading?

1134

For More Un-Answered { MainFrame } Questions Click Here