I met a problem to import the data from a text file if the data value starting with space


Content of the data file for import - abc.txt
Line1: ABC~ 123456789~123 <== Contains space at FLD_B
Line2: DEF~0123456789~456

Syntax for the import
db2 IMPORT FROM abc.txt OF DEL MODIFIED BY CHARDEL^ COLDEL~ METHOD P "(1, 2, 3)" MESSAGES abc.msg
"INSERT_UPDATE INTO myschema.tbl1 (FLD_A, FLD_B, FLD_C)"

Result after importing abc.txt into myschema.tbl1
FLD_A FLD_B FLD_C
ABC 123456789 123 <== Space at FLD_B has gone
DEF 0123456789 456

Please help!

Surprise, surprise!

IMPORT ... MODIFIED BY KEEPBLANKS ...

You can use the "keepblanks" file type modifier

http://publib.boulder.ibm.com/infoce...e/r0011045.htm

example :
db2 "import from x.txt of del modified by keepblanks insert into timp"


Cheers
Sathyaram

Oh! It works! Thanks you all!