I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I
SHOULD USE TO CALL SYSDATE?
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 |
How many input links can you give to a Transformer stage?
can explain wt is the pool for file.
source file contains 100 records, i want 10 records in target file how it possible in datastage
HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE CONTAINS VALUE AS 'VIJAY'?
what is diff b/w datastage 8.1,8.5,8.7?
i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?
Difference in the implementation of lookup and join stages,in joining two tables?
How can we achive parallelism
In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..
How to manage date conversion in Datastage?
how to retrive the max(sal),deptno,empno in datastage?
cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle