how to add current sysdate in my target table..???
Thanks in advance
current system date
Moderators: chulett, rschirm, roy
What database? Most support their own methodology, like Oracle does with the keyword SYSDATE that you mentioned. Simply use Custom SQL, include all other fields in your data stream and insert 'SYSDATE' into your date/time field.
If you want to do it in DataStage, look up @DATE and @TIME for starters. You can get the current System time or the Job (really Transform) start time using functions or System Variables like these. Check your online help.
If you want to do it in DataStage, look up @DATE and @TIME for starters. You can get the current System time or the Job (really Transform) start time using functions or System Variables like these. Check your online help.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers