I am defining one varaible parameter date in job
parameters.I want use this variable date in where clause in
source query.
Answers were Sorted based on User's Feedback
Answer / ram
As Kiran said you call in sorce query..
Define pDate as jobparameter..
In Query ..
Ex:
Select loc,div from xxx where dim_t = '#pDate'
Is This Answer Correct ? | 9 Yes | 1 No |
Answer / kiran
yes u can define date parameter as variable and call in
source query.
Is This Answer Correct ? | 5 Yes | 1 No |
Can you highlight the main features of ibm infosphere information server?
How to find value from a column in a dataset?
What is datastage?
You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?
How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition
If you want to use the same piece of code in different jobs, how will you achieve it?
30 jobs are running in unix.i want to find out my job.how to do this?Give me command?
it is possible to load two tables data into one sequential file?if possible how?plz share with me?
SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS
what are the types of nodes
If the job aborted in a sequencer, how can we start that from the previews successful job.
i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me