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 ?
2365i 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 6084Im 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 11331How 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 10961If i initialize the 01 level variable in array, will it initialize all the array elements (occurs)?
CTS,
8 25983In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
CTS,
5 20384What happens if i move +1 (instead of -1) to field+L in CICS? Will it show compile time error?
CTS,
6 10790can any one give the list of some important sql abend codes which r frequently asked in interviews?
2 8752If 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 11141
How to get the ddl of a table in db2?
Explain what is the massinsert option?
What is the kcp in the cics?
What is package in db2 mainframe?
How can the submitting users racf authority be overridden in a job stream?
Why is master catalog used in vsam?
how a data in physical and symbolic map gets treated? Since the physical map is much concerned about the screen alignment and the field positions, how the values entered in the field which has PICIN or PICOUT clause in Physical map gets treated? Does that mean datas recieved or sent to the physical map should be constant? How does the data in Symbolic map gets converted with 5suffix namely F,L,A,I and O. For example EMPNO is treated as EMPNOI, EMPNOO, EMPNOA, EMPNOL and EMPNOF. how does this happen in symbolic map. Please provide your inputs on the above and kindly correct me if I am wrong.
what will happen if there is no secondary allocation made for datasets?
What is recovery parameters in define cluster command?
What is the usage of comp fields in cobol?
Define communication area?
Explain dclgen.
What is a bind in db2?
What is the use of reorg in db2?
How to read the 2nd last record of a VSAM file? (The file size is huge and we don't know the key)