komal
New User
Joined: 09 May 2005 Posts: 17
|
|
|
|
Hi all
In a DB2 table, different columns r there like
a char(5),
b char(3),
c char(3),
d dec(19,8) - nullable,
e char(100) - nullable,
f char(100) - nullable,
g char(100),
h char(5)
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.
KiranChand |
|