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 many types of sorting methods are available in datastage?
What is the importance of the exception activity in datastage?
Define data aggregation?
What are the types of jobs we have in datastage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
How to reverse the string using unix?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What is the use of hoursfromtime() function in transformer stage in datastage?
Can we use target hash file as a lookup ?
What are iconv and oconv?
How to read multiple files using a single datastage job if files have the same metadata?
How to Remove Duplicate using SQL?
Differentiate between datastage and datastage tx?