Interested to Buy Any Domain ? << Click Here >> for more details...
I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I
SHOULD USE TO CALL SYSDATE?
- 4 Answers
- 25137 Views
- ME, I also Faced
- E-Mail Answers
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
Can we use target hash file as a lookup ?
What are the types of views in datastage director?
How can you write parallel routines in datastage PX?
What is the difference between datastage and informatica?
What are sequencers?
What are the different common services in datastage?
what is the use of surogate key in datastage
What is the difference between validated and compiled in the datastage?
Can you implement SCD2 using join, transformer and funnel stage?
Where the datastage stored his repository?
Describe stream connector?
Can you define merge?
What are iconv and oconv?
What are the enhancements made in datastage 7.5 compare with 7.0?
How do you run datastage job from the command line?
