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 ?
1956i 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 5199Im 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.
4 9863How 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 10155If i initialize the 01 level variable in array, will it initialize all the array elements (occurs)?
CTS,
8 23389In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
CTS,
5 18125What happens if i move +1 (instead of -1) to field+L in CICS? Will it show compile time error?
CTS,
6 8717can any one give the list of some important sql abend codes which r frequently asked in interviews?
2 7891If 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?
3 9804
Are there any set of rules for the names of the steps used in a job? What are they?
Explain the maximum number of fields allowed per segment and what is the maximum number of fields per database?
Specify the requirements for automatic task initiation?
What is the use of predicate?
How many bytes S(8) comp field occupy and its maximum value?
What is bind package and plan in db2?
What is idms-restart ?
EXPLAIN MAIN FRAME TESTING PROCESS...HOW TO FIX THE MAINFRAME BUGS?
What is cursor with hold option in db2?
What is auto status in idms?
How do I delete a table in db2?
What will happen if some program tries to process a queue on which an ENQ command has been issued by some other program?
If we say that bms length of field = 0, then what does that mean?
Explain the difference between the into and the set option in the exec cics receive map command?
What is the difference between Call and a Link?