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

without logical file we cannot access the data in physical file.but we specify physical file in the program(ie:- Ffile IF E k disk).how can it be accessed?

HSBC, TCS,

3 9872

while i am using the dspmsg command on comman line in Mocha am getting error like Not authorized to message queue message my messagequeue Name? can anybody help me how to change my message queue Am anable to see my messages in message queue

1 3337

I have a jcl which is using 2 data sets i want to override those data sets. how can i override the files within the JCL. Give me the syntax. Make sure that it is not calling any Proc.

1 3741

how to know total no of records in pf with out using sql??????

3 13071

Can we able insert data into a PS file Using IEBUPDTE utility??? If Yes can anyone describe it please..

1 5802

proc1,proc2,up to proc5 is there if i want to call proc1 and proc5how can u write the code

2 6450

Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?

3 7546

Errors in Sql query will be in which state?

1 5395

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 6252

what is lrec=f,what is difference between f,fb,v,vb?what is default value?how do we came to know that records are in f,fb,v,vb?

IBM, Wipro,

2 21850

I had 100 steps in jcl i want to execute first 10 steps only?

IBM,

6 12484

what is the use of ENTRY in IMS?

CGI,

3 13455

I had 100 records and i want to execute last three records by using cobol programming?what will be coding?

IBM,

4 11979

How do get the result of your program directly on your pc?

UST,

2342

What is diff between vsam and db2?what is advantage of db2 over vsam?which is best suited one?

Fidelity,

1 9425

Un-Answered Questions { MainFrame }

Explain the difference between the xctl and link commands?

1114

What is the Difference between command attention key and command function key ?

1377

Can we give +2 instead of +1 while creating a new gdg file?

964

Explain how will you differentiate between an internal and an external sort, the pros and cons, internal sort syntax etc

1251

What is sqlca?

1074

List down the data types in the db2 database.

1123

Explain the difference between external subroutine and subprogram?

1225

Explain what are the various isolation levels possible?

1044

WHAT IS FERERENTIAL INTRIGRITY ?

1631

Define temporary storage?

1062

Is their any set of rules for dd? Explain.

1193

What is a record lock error?

1763

What are the advantages and disadvantages of a hierarchical database?

1143

What is a system catalog table in db2?

1186

What methodology can be adapted to transfer data to a program that is coded using the exec statement?

1218

For More Un-Answered { MainFrame } Questions Click Here