View previous topic :: View next topic
|
Author |
Message |
bibek24
New User
Joined: 14 Aug 2007 Posts: 35 Location: Hyderabad
|
|
|
|
Hello,
How to load Current Date into one of the feilds of a table by using Load Utility?
Table feild - LOAD_DATE DATE EXTERNAL (10)
Currenty other feilds have input data to be loaded and LOAD_DATE has to be loaded with Current Date.
Thank You |
|
Back to top |
|
|
bibek24
New User
Joined: 14 Aug 2007 Posts: 35 Location: Hyderabad
|
|
|
|
My Load Syntax is as follws:
LOAD DATA RESUME YES INDDN SYSREC00
INTO TABLE TABLENAME
(ACC_NUM_ID POSITION (1) CHAR(8) ,
ALT_BILL_ACC_NUMB POSITION (9) CHAR (8) ,
RELATIONSHIP_CODE POSITION (17) CHAR (3),
---------
---------
----------
LOAD_DATE POSITION (108) DATE EXTERNAL (10))
Except LOAD_DATE feild, I am accepting all other feild values from a dataset.
I want the Current Date to be loaded at the Position 108 which is not in the dataset.
So please help me with the syntax. |
|
Back to top |
|
|
mkk157
Active User
Joined: 17 May 2006 Posts: 310
|
|
|
|
Try this loadcard and let us know the results.
LOAD DATA RESUME YES INDDN SYSREC00
INTO TABLE TABLENAME
(ACC_NUM_ID POSITION (1) CHAR(8) ,
ALT_BILL_ACC_NUMB POSITION (9) CHAR (8) ,
RELATIONSHIP_CODE POSITION (17) CHAR (3),
---------
---------
----------
LOAD_DATE POSITION (108) DATE EXTERNAL (10)
DEFAULTIF (108:117) = ' '
VALUE(CURRENT_DATE)) |
|
Back to top |
|
|
mkk157
Active User
Joined: 17 May 2006 Posts: 310
|
|
|
|
DEFAULTIF (108:117) = ' '
In the above line give 10 spaces as the date length is of 10 bytes. |
|
Back to top |
|
|
bibek24
New User
Joined: 14 Aug 2007 Posts: 35 Location: Hyderabad
|
|
|
|
No that didd't work.
Its showing - Invalid Keyword Value |
|
Back to top |
|
|
abhishekmdwivedi
New User
Joined: 22 Aug 2006 Posts: 95 Location: india
|
|
|
|
Try changing ,
Quote: |
LOAD_DATE POSITION (108) DATE EXTERNAL (10)
DEFAULTIF (108:117) = ' '
VALUE(CURRENT_DATE))
|
this to
Code: |
LOAD_DATE POSITION (108) DATE EXTERNAL (10)
DEFAULTIF (108:117) = ' '
VALUE(CURRENT DATE))
|
|
|
Back to top |
|
|
bibek24
New User
Joined: 14 Aug 2007 Posts: 35 Location: Hyderabad
|
|
|
|
Thanks for your replies.
I altered the table with LOAD_DATE set to Current Date. |
|
Back to top |
|
|
zero
New User
Joined: 01 Dec 2007 Posts: 21 Location: Hyderabad
|
|
|
|
Hi,
i tried to load this field with
Code: |
LOAD_DATE POSITION (108) DATE EXTERNAL (10)
DEFAULTIF (108:117) = ' '
VALUE(CURRENT DATE)) |
but, it gives error saying that "INVALID KEYWORD - VALUE".
Here, i guess, we cannot use VALUE clause.
The correct approach can be :
Code: |
LOAD_DATE POSITION (108) DATE EXTERNAL (10)
DEFAULTIF (LOAD_DATE = ' ') |
what DEFAULTIF does is, it checks the positions 108 to 117 in the input file. it they contain spaces, it loads the LOAD_DATA column with Default value (Generally, the dafault value for a Date field is Current date).
This will work only DEFAULT constraint is defined for the field LOAD_DATE, i guess.
Please correct if i am wrong.
thanks |
|
Back to top |
|
|
|