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


Please Help Members By Posting Answers For Below Questions

how to abort the job its matain duplicates?

2337


Explain ibm infosphere information server and highlight its main features?

848


Explain datastage architecture?

1080


Can we use target hash file as a lookup ?

3054


what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2520


What can we do with datastage director?

917


I have a few records just I want to store data in to targets cycling way how?

2135


table actions available in oracle connector?

1367


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3441


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?

1999


What is use Array size in datastage

1549


how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2152


What is a datastage job?

798


CHANGE CAPTURE

1096


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

722