I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I
SHOULD USE TO CALL SYSDATE?
- 4 Answers
- 24210 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 |
pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?
how many stages are there in Datastage... Please clarify mee??
i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 14000 1001 is dublicata how can i remove duplicate?
In a table 100 records are there after 50records job is aborted how can u insert all records in target table.
SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS
How did you reconcile source with target?
Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?
Define orabulk and bcp stages?
how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction
how do you pass parameters in a script?
How do you start developing a datastage project?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Teradata 
