IBM MainFrame Interview Questions
Questions Answers Views Company eMail

What is the difference between sb37,se37,sd37 each?

TCS,

9 34600

input 1 input2 ouput1 output2 output 3 1 re 300 1 re 200 1 re 300 3 rc 500 1 re 200 2 rr 400 1 re 300 2 rr 400 1 rc 400 3 rc 500 1 rc 400 2 rr 700 2 rr 700 5 tt 900 5 tt 900 2 inputs r in flat file and output 1 is matched records,ouptput2 is unmatched of input1,output3 is unmatched of input2! how vl u get the output files using sequential order and to check with each and every records! let me know the procedure division ?

1876

i have three programs... I used Dfhcommarea in for first program for third program i used TSQ .....what i have to use for second program???

2 5068

Im creating map, when i press tab key cursor must skip second position and it move to the third field directly. how can i code plz send the answer.

Cap Gemini,

4 9604

What is DYNAMBR in jcl?

CTS,

2 13867

How do u initialize an array?

CTS,

2 13375

How do u sort the table for Search ALL? Is it only using ASCENDING KEY IS statement in occurs clause? If the data is input in non ascending order, will the ASC KEY IS automatically sort the data? or will it throw compile time error?

CTS,

1 9967

If i initialize the 01 level variable in array, will it initialize all the array elements (occurs)?

CTS,

8 23014

What is an RBA in rrds? What does it do? What is it used for?

CTS,

5 9804

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

CTS,

5 17765

What happens if i move +1 (instead of -1) to field+L in CICS? Will it show compile time error?

CTS,

6 8460

How do you fetch current date in normal cobol pgm and in cobol-db2 pgm?

Cap Gemini, CTS,

3 19658

Please explain with syntax and an example, the Inrec fields and Outrec build in sort.

CTS, TCS,

4 38764

can any one give the list of some important sql abend codes which r frequently asked in interviews?

2 7713

If the number of parameter is more than the expected then NAT0919 error is displayed. How many parameter are allowed in a CALL and CALLNAT statement?

JPMorgan Chase,

3 9554


Un-Answered Questions { IBM MainFrame }

Define a page in idms?

467


How can we read records for specific member in CL? AND rpg?

234


can all users have the privilage to use the sql statement select * (dml)?

643


What is a junction record?

952


How to override a dsn that is contained in a proc called by another proc? I need to do the override in the calling jcl?

718






How to code these statements in JCL: CLEANUP INITIAL(NO) RESTART(NO) DYNALLOC(NO) job definition..?

1802


What is dl/i?

590


What is ibm db2 client?

523


Explain sorting techniques in cobol program? Provide the sort file definition, the sort statement, its syntax and meaning

686


What is runstats and reorg in db2?

800


What is the maximum size of varchar data type in db2?

645


What are the pertinent COBOL

2045


Must tape dataset definitions include vol=ser specifications?

983


List the different jcl statements that are not permitted in the procedures?

641


What is the function of //jcllib statement?

810