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 7704

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 4247

What is a record lock error?

Wipro,

1777

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 3811

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

1896

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 3863

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

IBM,

1 7299

Why we should use cursor ?

3 4258

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

1 3444

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

1 2811

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,

2334

How to fetch the uncommited data from table ?

JPMorgan Chase,

1 3662

Difference between Find and Read operation in ADABAS file.

Cognizant,

1 5504

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 2533

Un-Answered Questions { MainFrame }

Give the format of using and giving in sort statement. What are the restrictions with it?

1038

what are different types of substems?

2269

can a join logical file be updated?

1028

please..could u give an example about USAGE IS POINTER ..and explain why and when we use it ?

2479

What is afoper?

875

what optimum values can we find for freespace, ci etc?

1022

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2222

what is service program?

1045

a dd statement has 2 types of parameters. Name them?

1139

Name all the file-open modes

1086

When you are obtaining next within a set and get a end of set return code, on what record are you now current?

1421

What are the rules employed while naming the steps in a job?

1146

How many minimum number of line codes does PL/1 DB2 program requires?

2988

Is it possible to port existing applications from the mainframe or os/2? Are there major changes required to do this?

911

What is the pic clause for the hhmmss type of data fields?

953

For More Un-Answered { MainFrame } Questions Click Here