Joined: 26 May 2005 Posts: 178 Location: Copenhagen, Denmark
I am trying to load the DB2 table using DSNUPROC. One column type in the table is TIMESTAMP and part of the primary key. How can I specify to insert the TIMESTAMP.
You have to give the vaule while during the load. Make sure the dates are in the right format otherwise it would through -181 or -180 series error code.If it is defined as NOT NULL WITH DEFAULT and if it is not required for you to put the value then you may ignore that fields in the load control card. DB2 puts the current timestamp for you.
If you want to laod some value then define that in load control card. ex