I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I
SHOULD USE TO CALL SYSDATE?
Answer Posted / subhash
there many ways to get the SYSDATE:
1) By using the SYSDATE in the select query of your Oracle
Source.
2) By using the DsMacro, the function "DsJobstartDate " in
the transformer.
3) By using Date & Time function - "CurrentDate()" in the
transformer.
4) You would use the Date() function, and then some
variation of the OConv() function to change the date from
internal to external format.
For example, say you want to assign the current date to a
variable called StartDate, and format it in yyyy/mm/dd
format, you would use:
StartDate = Oconv(Date(), "D4/YMD")
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Explain Quality stage?
Can you explain kafka connector?
What is the use of datastage director?
How we can covert server job to a parallel job?
what is the difference between == and eq in UNIX shell scripting?
What is job control?
What is the difference between operational data stage (ods) and data warehouse?
Describe link sort?
What a datastage macro?
What are the different options associated with dsjob command?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What is datastage engine?
What is the difference between account and directory options ?
Explain connectivity between datastage with datasources?
What are the various kinds of the hash file?