CurrentTimestamp(),CurrentDate() and CurrentTime() functions are most useful functions in DataStage when we are dealing with the jobs to get the ‘current’ date and time stamp.
Generally we use these functions while we are loading data into different applications why because these different applications expect date into the database tables as an audit column.
I think almost all the projects follow these type of audit columns and based on this column we can identify the original record load time into the table.
You may have the audit column name as RecordLoadDate Or JobRundate and we capture record loaded details with CurrentTimestamp(),CurrentDate() and CurrentTime() functions and these are inbuilt functions to DataStage.
You can access these functions through Transformer Stage derivation or from sequence job derivations.
One more important thing is these functions returns the default datatype such as CurrentDate() will give output in YYYY-MM-DD format. As we know YYYY-MM-DD is the default date format in DataStage.
CurrentTimestamp()
Output: timestamp
CurrentDate()
Output: time
,CurrentDate() and CurrentTime() Functions in DataStage){kind=link}