View previous topic :: View next topic
|
Author |
Message |
ksk
Active User
Joined: 08 Jun 2006 Posts: 355 Location: New York
|
|
|
|
Hi All,
We have an input file with record length 100 and it's having data upto 73 colomns. We want to LOAD this file into DB2 table with CURRENT DATE from 73 to 82 clomns.
Can we use CURRENT DATE function in LOAD CARD. I am asking this b'cz I can't test this from my side. This would be done from our support people. We want to make sure before sending request to support people.
If CURRENT DATE won't work, please let me know if ther is any system defined function to extarct CURRENT DATE.
KSk |
|
Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
|
|
What load utility you are using?
I am not sure, but try with this...
...Locate SYSIN of load
...Try like this
Code: |
date_field POSITION(73:82) DATE CURRENT_DATE |
Please refer how to give default values or new values while loading into table on your LOAD utility manual. |
|
Back to top |
|
|
ksk
Active User
Joined: 08 Jun 2006 Posts: 355 Location: New York
|
|
|
|
Hi Gnanas,
Thanks for the solution. I did it using DFSORT's DATE(-1) function in JCL rather doing it in LOADCARD and worked fine.
Regards,
KSK |
|
Back to top |
|
|
|