what are the utilities for load and unload the DB2 tables
Answer Posted / 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 |
Post New Answer View All Answers
Our issue is there seems to be a disconnect, or no link, between our SELECT statement and our SD. We had SELECT SORT-FILE and SELECT SORT-FILE ASSIGN TO SORTWRK. ASSIGN TO SORTWRK1 SORTWRK2 SORTWRK3 SORTWRK4. with SD SORT_FILE RECORD CONTAINS 7833 CHARACTERS. In either case, at run time, the system ignored our SORTWRK# DD statements and allocated 16 sort works with the SORTWK## naming convention. Any ideas why the system does not recognize the connection? We do not even need the SORTWRK DD statements. Thanks
I have a File that has duplicate records. I need only those records that occur more than thrice.?
How do you reference the following file formats from cobol programs?
What is the difference between perform … with test after and perform … with test before?
) what is the difference between AID and HANDLE AID?
What are the different rules to perform a Search?
Are you comfortable in cobol or jcl?
example for sub strings ? and refernce modifications whit output pls
How to print 10 to 1 if the input have only 10 digit number?
i made it to stage 3 of an interview process wednessday they will quiz my knowledge again face to face for an analyst role recruiter said it will be based on Business requirements system is cobol and good ideas what they might ask etc
how do you reference the variable block file formats from cobol programs
Differentiate cobol and cobol-ii. (Most of our programs are written in cobolii, so, it is good to know, how, this is different from cobol)?
What is the default value(s) for an initialize? What keyword will allow for an override of the default?
How many bytes S(8) comp field occupy and its maximum value?
HOw can I get the negative sign while deduct high value from low value