DSXchange

Thanks Ken !!

I actually did find a solution to the problem !! Within the Aggregator stage there is an option to All Null Output. This by default is set to NULL. When set to True works like a charm !!

Hello All: I have a quick question on using the Aggregator stage (Enterprise Edition). I have an AMT column which is a nullable column and it passes through the Aggregator to determine the sum, based on a set of grouped key columns. When the AMT column is null at the source the data after aggregatio...

Hello All: I have to find the difference in month between 2 dates. I know we could do it in SQL, but unfortunately these dates are derived from other columns and hence would need to be done within DataStage. Any help would greatly be appreciated!! For example: Date1=2001-01-01 Date2=2004-01-01 Resul...

Check the Description column on the right of transformer. Check if the column names for the missing column is the same as the other ones..

Ken: The DataStage job is calling the .bat file but it looks like the job is running for ever. It doesn't stop. I tried running the .exe file directly from the server. It runs sucessfully in the server. Is there something that i am missing before calling the .exe file thru DataStage. Kindly advise!!...

Yep, the path was pointing to the server and not to my Local folders

The entire path for the .bat file was already given.. I editied out the log in my previous message..

-Raj

Hello All: Could somebody help us call a .exe file through DataStage Server on Windows. The .exe file was created through VB and i need to run the .exe first and then kick-off the DataStage server job. I tried to call them using the Execute Command stage through Sequencer - but could not do so. I al...

kcbland wrote:How about a job parameter? Such as

Code: Select all

table.datecol >= '#YourDateParameter#'

...

For a Server job running on windows OS - How do i pass the #dateparemeter# to the SQL stmt ?? Kindly advise..

Could somebody please let me know how to pass a value to a SQL in a passive stage. Consider i have a ODBC stage and am connecting to a SQL server database. The scenario here is to use a between clause (or) a < > in a sql statement. This value that i would be passing would be dynamic.. Any suggestion...

ArndW wrote:Use a call to UNIX shell script and use rsh.

If you do not mind Can you please explain in detail ??

try the following:
DSGetLogSummary
DSGetlogEntry

From DataStage (which is on one server), how do you run a unix script from Oracle (which is on another server)?

If you are using sequencer -- enable the option to include job status on the job activity stage.. This will give u the log which should also indicate the time it took for it to run !!