what are the utilities for load and unload the DB2 tables
Answer / anupam das
There are many utilities available but most commonly used
are IKJEFT01, IKJEFT1A and IKJEFT1B. Also need to use
DSNTIAUL program.
You can generate Unload/Load utility from DB2 Admin tool.
| Is This Answer Correct ? | 14 Yes | 0 No |
I have a sequential file. How do I access a record in this sequential file randomly in my program ?
how to check whether the open command of a sequential file is successful? or not?
) How do u handle errors in BMS macro?
Consider the below example call a-test1. -- -- -- a-test1. if a=b perform a-test through a-exit next sentence else if b=c perform c-test through c-exit. if a=d perform d-test through d-exit. a-test. -- -- a-exit. exit. can u tell me what will happen if a=b after looping into a-exit will the control go back to a- test1. will the condition a=d be checked???
9(2).99 how many bytes take? Why . consider as a byte?
i WANT ALL ERROR codes IN CICS and DB2
How do u debug a S0C7 abend? (aswered till we get the field which caused that) After knowing the field which caused that how do u know the record which caused that if it is in production env? (dumb) Ok let us assume that we got to know that 100th record caused that and I wanted to skip only 100th record from the file and process from 101th. How to do that in JCL using SORT? (tried with STOPAFT but ended up dumb when he said smthing else is ther)
How to remove the spaces at the end of each record in the output file of variable length, via cobol program?
RENAME clause takes new SPACE in memory.TRUE or FALSE? a)TRUE 2)FALSE
How to display string in the reverse order using occurs clause?
How to concatenation one or more string?
What is the default value of DISP parameter?