1) IF THE UTILITY IS TO LOAD THE INPUT DATA INTO AN EMPTY TABLE
THEN WE SAY LOAD INTO TABLE TABLE_NAME.
2)IF THE UTILITY HAS ROWS IN IT CODE LOAD RESUME YES IF YOU WANT THE NEW ROWS ADDED TO THE END OF THE table.
3) IF YOU WANT TO REPLACE THE CURRENT DATA WITH THE NEW INPUT DATA CODE REPLACE AS LOAD REPLACE INTO TABLE TABLE_NAME.
WHEN THE UTILITY IS RUNNING U CAN PROVIDE VARIOUS ACCESS MODES
TO THE TABLE SPACE
ACCESS = RO -READ ONLY OPTION
ACCESS = RW -READ/WRITE OPTION .THIS IS THE DEFAULT ACCESS MODE
ACCESS = UT -PERMITS ACCESS TO UTILITIES ONLY.
ACCESS = FORCE - WILL START THE DATABASE WITHE ACCESS = R/W
DURING THE LOADING PROCESS THERE IS AN OPTION TO SET TE LOG FLAG TO YES OR NO. THE LOG PARAMETER BASICALLY KEEPS TRACKS OF WHETHER THE LOG RECORDS ARE WRITTEN DURING THE EXECUTION OF THE UTILITY.
IF LOG = YES LOG RECORDS ARE WRITTEN.
IF LOG = NO LOG RECORDS ARE NOT WRITTEN.DB2 WILL AUTOMATICALLY SET THE COPY PENDING FLAG TO YES.THIS IS DONE SO THAT NO MATTER WHAT DB2 HAS AN IMAGE COPY OF THE TABLE SPACE BEFORE THE UTILITY RUNS .
IF YOU HAVE LOG = NO AND WANT TO AVOID THE COPY STEP THEN U CAN USE ACCESS= FORCE WHICH WILL CHANGE THE STATUS OF THE TABLESPACE TO R/W
I found a lot useful expln in ur reply and i'm attaching one more query which falls in the same.
In a DB2 table, different columns r there like
d dec(19,8) - nullable,
e char(100) - nullable,
f char(100) - nullable,
when i extracted the table into a flat file, i got the LOAD form as
LOAD DATA RESUME YES INTO TABLE "KOMAL"."KIRAN"
(A POSITION (7) CHAR (5) ,
B POSITION (12) CHAR (3) ,
C POSITION (15) CHAR (3) ,
D_NUM POSITION (18:27) DEC
NULLIF (1:2)=X'FFFF' ,
E POSITION (28) CHAR (100)
NULLIF (3:4)=X'FFFF' ,
F POSITION (128) CHAR (100)
NULLIF (5:6)=X'FFFF' ,
G POSITION (228) CHAR (100) ,
H POSITION (328) CHAR (5) )
In the flat file i found that the values in 'D' r displayed as special symbols.
The text file which I FTPied from flat file contain the same.
I have 2 doubts here
1. If I am not wrong, the size of that D is 10 bytes so, it is displaying some special symbols for some value like 12345678901.12345678. But how to get the actual value into the flat file instead of special symbols?
2. My source system is sending us a textfille which i have to load into the DB2 table mentioned above. How i can move the actual decimal value from the text file to the column D of the table?
PLZ reply me as soon as possible bcoz i am fighting with this from last 2 days.
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
In TSO, open your text file in Browse. Then set HEX ON.
You will see what the "special" symbols are - packed decimal numbers often show as "special" symbols - they sometimes contain hex values that are "printable". Copy a few of these expanded lines (showing the text line and the 2 hex lines) as "code" to a reply here (to make it readable on the forum). It sounds like the text file has what you need to load, but looking at a few records in the text file will surely verify that.
It will also help you to get the copybook or other file definition from the program that created the text file. Please post the text file layout when you find it.
I'll check back later tonight to see if you've posted anything.