Loading Data to DB2 table using delimited data

mfstudent1 · New User Joined: 03 Mar 2006 Posts: 18

Hello,

I am trying to load data into a DB2 table using DSNUTILB-LOAD utilility. The data is delimited by ';'. There are lot of DECIMAL(COMP-3) fields in the data. I am receiving 'conversion error' on these fields.

Can't I load delimited decimal data using LOAD utility? Is there a work around(except specifying positions)? I have about 100 fields to be loaded into the table.

Thank You.

Phrzby Phil · Posted: Tue Nov 06, 2007 6:39 am

I think comma-delimited LOAD began with version 8. What are you on?

mfstudent1 · New User Joined: 03 Mar 2006 Posts: 18

I am on DB2 Version 8

Phrzby Phil · Posted: Tue Nov 06, 2007 6:51 pm

I think the default delimiter is comma, but there is a parm that let's you redefine it as, in your case, semi-colon.

Have you done that?

mfstudent1 · New User Joined: 03 Mar 2006 Posts: 18

Phrzby Phil,
Yes..I have redefined the coldel to ';'