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
how to abort the job its matain duplicates?
Explain ibm infosphere information server and highlight its main features?
Explain datastage architecture?
Can we use target hash file as a lookup ?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What can we do with datastage director?
I have a few records just I want to store data in to targets cycling way how?
table actions available in oracle connector?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What is use Array size in datastage
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What is a datastage job?
CHANGE CAPTURE
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4