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 |
Can we MOVE X(9) to 9(9) OR 9(9) to X(9)? If yes what are the ways for doing this?
12 Answers T systems, Tech Mahindra,
What is Static and Dynamic linking ?
Can the OCCURS clause be at the 01 level?
I have a table with 3 dimensions like this : 01 ws-table 04 ws-page occurs 3 08 ws-column occurs 2. 12 ws-record occurs 20 pic x(40). How to code with PERFORM varying with 3 dimension...I forgot..
TYPES OF SORTINGS. which is more prefarable.
I have a sequential file of 100 records. How do I load the records into a two dimensional array ?
01rec1. 05 a pic 999v99 value 123.12 05 b pic 99v9 value 45.9 02 rec2. 05 x pic 999v99 05 y pic 99v99 05 z pic x(3) value 'abc' if rec1 is moved to rec2 then what is the value of rec2?
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
How you can characterize tables in cobol?
What is COMP SYNC?
What is Comm?
2 Answers IBM, Kemper Corporation,
Why we should use cursor ?