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

What is the roundrobin collector?

877


sed,awk,head

1237


Can you filter data in hashed file?

3582


How do you register plug-ins?

781


Define Job control?

864


What is aggtorec restructure operator?

1125


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?

2023


Define orabulk and bcp stages?

919


AGGREGATOR default datatype

1174


What are system variables and sequencers in datastage

870


Can you explain kafka connector?

1064


What is the difference between datastage and datastage tx?

836


Have you have ever worked in unix environment and why it is useful in datastage?

932


Define Routines and their types?

870


EXPLAIN SCD

1179