DSXchange

Based on your design it seems that you are doing only insert, in that case go for Oracle Load option, instead of DataStage.

How the job was killed using command prompt? Using unix Kill command?

As there is no oracle session and datastage process are running, do clear status file. In Datastage Director --> Job --> Clear status file.

Can you tell me what is your requirement and what you are trying to do?

Check for the space in /tmp directory

century year month date, but is this related to PX?

Is the column has been marked as null

Hi Tom, Since you have mentioned that the source is file and you are using logic to find the file size to kick off the job, my suggestion will be instead of creating one job to capture unique records to file and then checking the file size at the sequence level, try the below one: in sequencer execu...

Also assign initial value for svPrev as null (or as you like) and update svUni as below

svUni --> if svPrev is null then '0' else (If svPrev <> svCurr Then '1' Else '0' )

Modify the stage variable as below:

Stage variables-

svCurr --> run_date
svUni -->If svPrev <> svCurr Then '1' Else '0'
svPrev --> svCurr

Are you passing the same parameters to the job when calling from the sequence?

You have to add a user-defined environment variable as PWD with value .(dot) in datastage administrator

Dear gurus, When we are trying to install plug-in stages but it is giving us a blank option screen. We tried in two ways.. Ours is HP-Ux 1. We tried running install.sh again, it displayed install/maintainence screen, then choose add plugin option, then located the plugin directory where *.dsp files ...

Check for the lookup failure condition in the Lookup stage properties.. It must be Failed... Based on your requirement choose a option from it....

Hi Andrew, Many thanks for your reply. I believe we will not be able to execute '-LogNewest' command before executing job execution command 'dsjob -run'. I tried with this option but it is firing an error saying it cann't find 'Erro:Newest ID'. Could you please suggest me an way to achieve job start...