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 ?
2294i 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 5968Im 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 11146How 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 10852If i initialize the 01 level variable in array, will it initialize all the array elements (occurs)?
CTS,
8 25669In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
CTS,
5 20165What happens if i move +1 (instead of -1) to field+L in CICS? Will it show compile time error?
CTS,
6 10518can any one give the list of some important sql abend codes which r frequently asked in interviews?
2 8646If 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 10960
What is a segment in ims?
What is linkage section?
Give the name of some fields form sqlca.
Why do we need reorg in db2?
what is the probability of a complete system distortion under high end low performing multiprocessor job?
What is buffer pool and list some of them?
what happens in conversion stage in job processing?
Which statement is used to identify the private libraries in job?
Before you give the explain statement, what are the prerogatives?
What does db2 blu stand for?
What are Naming Conventions in QMF?
Is there a application program coding difference between local and central version mode in idms?
How do u write test cases?
Hello, I have 3 years of exp as a mainframes tester in a leading IT company, now am looking to change my company. Could you please let me know, what are the interview questions/topics i should prepare. Your suggestions are truly valuable for me :) Thanks !!
What is a page in idms?