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
What is the roundrobin collector?
sed,awk,head
Can you filter data in hashed file?
How do you register plug-ins?
Define Job control?
What is aggtorec restructure operator?
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?
Define orabulk and bcp stages?
AGGREGATOR default datatype
What are system variables and sequencers in datastage
Can you explain kafka connector?
What is the difference between datastage and datastage tx?
Have you have ever worked in unix environment and why it is useful in datastage?
Define Routines and their types?
EXPLAIN SCD