View previous topic :: View next topic
|
Author |
Message |
Samantha Chelikani
New User
Joined: 11 Apr 2007 Posts: 10 Location: India
|
|
|
|
Hi,
We have a job which uses the DBUTIL utility to load an input file to a table
The load parm is as below
Code: |
LOAD DATA LOG NO RESUME YES INDDN SYSREC00 INTO TABLE
MUS.T7756_AD_ACCT_PROD
(CDS_MTH_NBR POSITION (1) SMALLINT ,
CDS_TRAN_ID POSITION (3) CHAR (11) ,
CDS_YR_NBR POSITION (14) SMALLINT ,
CDS_ACCT_ID POSITION (16) CHAR (11) ,
ACCT_NBR_DSPL POSITION (27) CHAR (20) ,
ACCT_OPEN_DATE POSITION (47) DATE EXTERNAL (10) ,
CDS_QUAL_GRP_IND POSITION (57) CHAR (1) ,
DIR_ACCT_IND POSITION (58) CHAR (1) ) |
Now for the last two fileds, CDS_QUAL_GRP_IND and DIR_ACCT_IND i want to insert spaces into them and not the values from the input file.
Please let me know the syntax for the same. |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
Samantha Chelikani wrote: |
Hi,
We have a job which uses the DBUTIL utility to load an input file to a table
The load parm is as below
Code: |
LOAD DATA LOG NO RESUME YES INDDN SYSREC00 INTO TABLE
MUS.T7756_AD_ACCT_PROD
(CDS_MTH_NBR POSITION (1) SMALLINT ,
CDS_TRAN_ID POSITION (3) CHAR (11) ,
CDS_YR_NBR POSITION (14) SMALLINT ,
CDS_ACCT_ID POSITION (16) CHAR (11) ,
ACCT_NBR_DSPL POSITION (27) CHAR (20) ,
ACCT_OPEN_DATE POSITION (47) DATE EXTERNAL (10) ,
CDS_QUAL_GRP_IND POSITION (57) CHAR (1) ,
DIR_ACCT_IND POSITION (58) CHAR (1) ) |
Now for the last two fileds, CDS_QUAL_GRP_IND and DIR_ACCT_IND i want to insert spaces into them and not the values from the input file.
Please let me know the syntax for the same. |
If those 2 fields are defined as "NOT NULL WITH DEFAULT" then all you need to do is change the comma on the ACCT_OPEN_DATE line to a ) and delete the last 2 lines. |
|
Back to top |
|
|
Samantha Chelikani
New User
Joined: 11 Apr 2007 Posts: 10 Location: India
|
|
|
|
Thanks a lot Craq. Have tested the same and found that its working.. |
|
Back to top |
|
|
mkk157
Active User
Joined: 17 May 2006 Posts: 310
|
|
|
|
Craq Giegerich,
If those 2 fields are not defined with "NOT NULL WITH DEFAULT' then
What is the alternate solution to insert spaces into them. |
|
Back to top |
|
|
|