I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I
SHOULD USE TO CALL SYSDATE?

Answers were Sorted based on User's Feedback



I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?..

Answer / ramesh

In DsMacro the function "DsJobstartDate " is there, by
using this we can recall sysdate

Is This Answer Correct ?    7 Yes 1 No

I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?..

Answer / 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

I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?..

Answer / kpk

if i were you i would use a function in the transformer stage.

Is This Answer Correct ?    2 Yes 1 No

I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?..

Answer / palgun

CurrentDate()

U can find many more functions in the transformer stage....

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More Data Stage Interview Questions

What is the default padding character?

3 Answers   IBM,


What are the types of hashed files in data stage

0 Answers  


what is the use of materialized view?

0 Answers   CTS,


Explain ibm infosphere information server and highlight its main features?

0 Answers  


WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD

8 Answers   L&T,






WHAT ARE THE COMMON ERRORS IN DATA STAGE?

6 Answers   IBM, ME,


what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none

1 Answers   Wipro,


what are the different type of errors in datastage?

2 Answers   Wipro,


Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/

4 Answers   TCS,


What are transforms and what is the differenece between routines and transforms?

0 Answers  


What is Fastly Changing Dimension?

6 Answers   TCS,


How do you run datastage job from the command line?

0 Answers  


Categories