Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
CURRENT TIMESTAMP as Default

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1544
Location: Andromeda Galaxy

PostPosted: Thu Jun 13, 2013 9:34 pm    Post subject: CURRENT TIMESTAMP as Default
Reply with quote

Hi all,

As a one time activity I need to load a table using a file and I have a situation where the my table contains 5 fields and the file contains 4 and where the field missing is to be stored with CURRENT TIMESTAMP and Is it possible to store the CURRENT TIMESTAMP value to be inserted for every record from the file

My shop doesnt support CONSTANT VALUE

Is there an option to populate CURRENT TIMESTAMP for every record in the input file using LOAD UTILITY?

or Also is there an option to set the table field WITH DEFAULT CURRENT TIMESTAMP or something similar?
Back to top
View user's profile Send private message

Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1783
Location: Bloomington, IL

PostPosted: Thu Jun 13, 2013 10:17 pm    Post subject:
Reply with quote

Can the column be (re-)defined as NOT NULL WITH DEFAULT?
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1544
Location: Andromeda Galaxy

PostPosted: Thu Jun 13, 2013 11:02 pm    Post subject:
Reply with quote

Yes I have control over the tables so it can be done icon_smile.gif
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1544
Location: Andromeda Galaxy

PostPosted: Fri Jun 14, 2013 12:27 pm    Post subject:
Reply with quote

I felt Timstamp not needed so removed it icon_smile.gif

Thanks anyway
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Fetching data from JHS as per the cur... arunsoods All Other Mainframe Topics 4 Wed Nov 22, 2017 1:54 pm
No new posts Comparision with current time arunsoods DFSORT/ICETOOL 5 Thu Nov 09, 2017 10:37 am
This topic is locked: you cannot edit posts or make replies. Comparing current time with the time ... arunsoods SYNCSORT 1 Mon Oct 30, 2017 4:07 pm
This topic is locked: you cannot edit posts or make replies. Incrementing current time field by 30... arunsoods DFSORT/ICETOOL 11 Thu Oct 26, 2017 3:22 pm
No new posts Comparing 2 Files using Current time arunsoods SYNCSORT 9 Fri Sep 22, 2017 6:00 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us