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
- 25305 Views
- ME, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ramesh
In DsMacro the function "DsJobstartDate " is there, by
using this we can recall sysdate
| Is This Answer Correct ? | 7 Yes | 1 No |
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 |
Answer / kpk
if i were you i would use a function in the transformer stage.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / palgun
CurrentDate()
U can find many more functions in the transformer stage....
| Is This Answer Correct ? | 2 Yes | 1 No |
What is the precedence of stage variables,derivations, and constraints?
How do you design PX Routines ?
How a server job can be converted to a parallel job?
source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235
What is the roundrobin collector?
i have the source from Uk,north america how can i pass the data two tables based on the locations
what is the main differences between Lookup, Join and Merge stages?
how to sort two columns in single job in datastage.
How to create user defined environment varibale(parameter)?
how many stages are there in Datastage... Please clarify mee??
eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000
What is the purpose of pivot stage?
Teradata 
