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
- 24936 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
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What are some different alternative commands associated with "dsjob"?
Explain connectivity between datastage with datasources?
whom do you report?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What are the types of hashed files in data stage
What are the types of jobs we have in datastage?
Explain entity, attribute and relationship in datastage?
Whats difference betweeen operational data stage (ods) and data warehouse?
What is the difference between account and directory options ?
What are data elements?
How to reverse the string using SQL?
What are the different kinds of views available in a datastage director?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
