Home > Software > Data-Warehouse > DataStage
Interview Questions   Tutorials   Discussions   Programs   Discussion   

DataStage - I want to send SYSDATE as parameter , so What command I should use to call sysdate?




1218
views
asked mar September 20, 2014 06:33 AM  

I want to send SYSDATE as parameter , so What command I should use to call sysdate?


           

1 Answers



 
answered By vishnoiprem   0  
Please see the below ways can be used:

  • By using the SYSDATE in the select query of your Oracle Source.
  • By using the DsMacro, the function "DsJobstartDate " in the transformer.
  • By using Date & Time function - "CurrentDate()" in the transformer.
  • 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")
flag   
   add comment

Your answer

Join with account you already have

FF

Preview

 Write A Tutorials
Online-Classroom Classes
www.writeabc.com


  1 person following this question

  1 person following this tag

  Question tags

datastage × 4

Asked 2 years and 3 months ago ago
Number of Views -1218
Number of Answers -1
Last updated
3 years and 2 months ago ago

Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert