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
- 25096 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 |
what is the use of DSattchJob?DetachJob? where can we find it?
Difference in the implementation of lookup and join stages,in joining two tables?
What are orabulk and bcp stages?
How to read the length of word in unix?
WHAT IS FORCE COMPILE?
how to call routines in stages?
What is the project in datastage?
Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S
what is the difference between == and eq in UNIX shell scripting?
How do you load dimension data and fact data? Which is first
Could anyone give brief explanation bout datastage admin
Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?
Teradata 
