DSXchange

Hi Everyone,

Any idea on this issue Please...

Hi, Thanks Chulet for you reply .. May be dont need a proc for this .. But i need to find out why it is behaving like this in datastage job with just only STP stage. When i execute the same stored procedure in the database say 1st time iam geting the result as ( 0,1,1,0) ; 2nd time iam getting the r...

Hi to add some more information.

I have a column in the table and in that 0 values need to change to 1 and the 1 value should change to 0.

Please someone could suggest ..

Hi, I have a job, which executes a stp stage. The stp stage is a storeproc that takes no parameters . The store proc in sql server, it updates certain values ina table. Now I am checking these values in the tabele, BEFORE and then AFTER I execute the sp, the problem is, the sp seems to execute only ...

Thanks Ray for you answers. I will be writing the routine and i will let you know if i have any questions.

Hi Parag,

Can you help me how to write or give an idea for after job subroutine to solve this issue.. Because iam new for the routines .I need to write parallel routine right?





Thanks in Advance

Hi,

Can i use the terminator activity stage in the job sequence and the trigger option would be DSJ.JOBSTATUS = DSJS.RUNWARN.?

Can i use this option ..Please let me know

Thanks for your answers. I will try to use to those conditions and let you know.

yes Chulett.. I need to abort the job when ever it has got warnings. Can you please tell me how to do this in job level or sequencer level.

Thanks

yes the sequence job is in aborted/restartable status.Is it possible to set a condition the job should restart if it has warining/abort?

Hi Everyone, I have a job that releases several jobs to run concurrently . In those 2 jobs failed one with an abort and other has warning messages. But in my sequence i do not proceed to next step .Next step is on OK,the alternate link is "otherwise". On re-start of the job , excecution st...

Once again My Apology ... Ray Thanks for suggesting..

Oh my god.. I apologize for the mistake i have done.. i dont know how it happened actually i was trying to edit the post and something messed up.. sorry for that i will never do this again..

Thanks

Hi For Text fiel as the Data Source, we have the following configuration in our odbc.ini file [Text] Driver=/apps/applmgr/Ascential/DataStage/branded_odbc/lib/VMtxt20.so Description=DataDirect 5.00 TextFile(*.*) AllowUpdateAndDelete=0 ApplicationUsingThreads=1 CacheSize=4 CenturyBoundary=20 Database...

Hi, I have a unix FTP script to get the file from remote server to DS server. And the script will send an email whether the transfer is successful or failure. Now i also need to log audit data. For example the file name , file size . record count in the file etc.. what are the options to capture the...