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

1 4047

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 3212

What is a record lock error?

Wipro,

1250

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 3048

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

IBM,

1213

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

1296

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 2983

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

IBM,

1 6013

Why we should use cursor ?

3 2945

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

1 2553

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

1 2007

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,

1802

How to fetch the uncommited data from table ?

JPMorgan Chase,

1 2735

Difference between Find and Read operation in ADABAS file.

Cognizant,

1 4222

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 1735


Un-Answered Questions { MainFrame }

what is the purpose of coding notify parameter in job statement?

673


what is the use of outrecord?

1759


What will be the result if on size error phrase is declared?

491


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

653


what is the favicon.ico request that my site receives now and then?

621






I want my job (careerride) to be executed in 1 minute and 2 seconds. How do I do that?

698


How to find out the closest prime number of an input number? I believe it has something to do with SEARCH and COBOL Linear Array.

3703


in order to execute step2 a job after a return code of 8 in step1, what condition you will code in step2?

2040


What is job control language?

601


which utility is used to run a cobol-db2 program?

791


Explain about maximum displacement?

596


What is bind plan?

600


define a output queue?

917


How would display prime numbers using CL program?

5666


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

2678