DSXchange

Please explain little in detail...As i am new to DS, I can not quite catch what you are saying...

Hi I am using 3 different sequences and few jobs to perform a task. If a job fails in one of the sequence i would expect to see the same in the parent sequence, but i am getting success. Eg: Seq1 -->Seq2 -->seq3 -->Server job1,job2 if job2 fails my seq1 should get the status of failed, but i am gett...

Hi I have a sequence in which multiple jobs will be executed. At one point i have to execute 2 jobs based on the success of other job and if both get finished then move forward with new job execution, if any one fails, sequence has to stop. Sequence 1: Job1 -->Cmd-->job2-->Job3--------- /job7 | | --...

Hi I am new to datastage, so please bare with me for any dumb questions. I have a server job running and it is taking almost 8-10 hrs and for some reasons we had to stop the job at 7Am in the morning and once the other tasks are completed, i wanted to restart the job where it left off. 1) Is it poss...

Please forget about the syntax problems here...this is display/copy paste issue. Otherwise it should have been thowing different syntax related issue.
The problem here is trying to kick off the job, but due to not able to create the .wrn or .log file it fails.

Any help would be great

Ok, This might help to figure out the issue. These are the sequence of commadns i am executing. cd /dvl/etl/Ascential/DataStage/DSEngine /dvl/etl/Ascential/DataStage/DSEngine>. ./dsenv /dvl/etl/Ascential/DataStage/DSEngine>cd /dvl/etl/Ascential/DataStage/DSEngine/bin /dvl/etl/Ascential/DataStage/DSE...

I should be able to pass the parameters to a job from batch Job( can call this as batch job with out naming it as Batch::?) but when i try the same from sequencer to job i am not getting the parameters.

Any clue?

I am not creating any files. Looks like by default batch file execution causes the creation of the files at root and since my user id doesn't have access permission it is failing.

In execution wise how Batch:: is different from regular job execution?

batch job calls -->Individual job No, the batch job is not working from director too. The individual job runs fine in designer and from director. But when i try from batch job to invoke individual job it fails with the message described in my first post. Another thing i learnt was, If the batch file...

I was inserting the records first in parent table and collecting rejected records in to hashed file. while i am inserting the child table records i am looking up in to hashed fiel for rejected records and corresponding child records will be eliminated from the insertion. More over both parent and ch...

Hi I am trying to run the job from command prompt and i am getting this. Parameter file below is given correct path. Job has been kicked off but getting below error. From command prompt ./dsjob -server SERVERNAME-user userid -password pwd -run -param ParameterFile="SrcDir/ETLParamFile.dat"...

Thanks for the responses.

Please ignore my post. I have implemented easy possible solutions.

Job Activity stage. Before job activity stage i have execute commadn stage and i am seeing the passed file name coming in for this command. But when i execute the job from job activity stage it is not getting passed to job. I can see in the job logs that it is looking for default file and fails.(sin...

Ok, Now i should be able to pass the parameter to Sequencer, but this is not getting passed to my job from sequencer. ./dsjob -server Server -user userid -password password -run -param SrcFile=PCC.txt -warn 5000 Project SequencerName My sequencer suppose to pass the paramteres to my job.(All paramet...