Home > IT Answers > AS/400 > DB2 table load JCL with current timestamp
Manju2
5 pts.
 DB2 table load JCL with current timestamp
AS/400 flat file, DB2, DB2 Table, JCL
Hi I need load the data from the flat file to db2 table by dsnuproc (mainframe ) utility my file dont have the timestamp value but the cloum in the table col2 declared as timestamp not nulll caould you please help how do load current timestamp.Thanks in advance Regards Manju

Software/Hardware used:
mainframe
ASKED: December 6, 2010  5:56 AM
UPDATED: January 13, 2011  9:13 PM
RELATED QUESTIONS
Answer Wiki:
If the table is defined with that column to use the default timestamp then it would default to current. You would skip mentioning that column in the load utility. I think you could also specify in the load to load current timestamp. (I did not look this up). You can and should research this in the DB2 utility manual, and do some experimenting.
Last Wiki Answer Submitted:  January 13, 2011  9:13 pm  by  Meandyou   5,205 pts.
All Answer Wiki Contributors:  Meandyou   5,205 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _