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
- 25146 Views
- ME, I also Faced
- E-Mail Answers
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
In Datastage, how you can fix the truncated data error?
How to find value from a column in a dataset?
How to read multiple files using a single datastage job if files have the same metadata?
What is apt_config in datastage?
Describe stream connector?
What all the types of jobs you developed?
What is difference between join, merge and lookup stage?
how to write server Routine coding?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
root tree will find which is server job and which is parallel job?
Triggers,VIEW,Procedures
Explain ibm infosphere information server and highlight its main features?
What are some different alternative commands associated with "dsjob"?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What is a folder? Difference types of stages?
