DSXchange

Thanks A lot thomson. You probably are right, I might have to chnge my approach. As far as the warnings are concerned, they are not because of data. Warning like sequential file can not preserve partition (I tied everything for this, doesn't seem to go. Another one is upsert will reduce array size t...

I have sequential file landed using datstage. And I am using this file in another job. For testing purpose I had to edit this file once created for one record. I am just changing one letter. I am doing this using vi. Once I save this file and try to read this in datstage job i get import error. Howe...

DataStage sort uses the built-in DataStage sorter, you
do not require any additional software to use this option.

UNIX sort specifies that the UNIX sort command is used to
perform the sort.

Right but return code is 2 when there are warning even if it is 10 or 15. and when I run job I have to run with -war 10.
This makes actual job abort.


I do I distinguise between these two.

$? from dsjob run list...

Thank much chulet.
I am probably not writting communication clear.

The return code is always set to 2 by dsjob command even though the job is aborted (if it is dues to excceded limit of warnings).

I will definitly check the manually, thanks agin for pointing exact chapter on it...

Thanks chulett . Problem I am facing is when job finishes with finhed (See log). As far as number of warnings are within limit specified in job run script I want final return code to be set up good. So in above case there are 15 warning generated and permissible limit for me is 10 then I want bad co...

I am running my job via the dsjob -run command and for status put a command like RETURN_VALUE=$? Now wahaterver is number provided in parametre the -warn 20. Return code = 2. What I am looking for here is: If job has warning but wihin limits its okay for me i would like to set final return code to 0...

Thanks for all responces, scripting in before helped.

I have a file with below construct.. set schema abc select field1, field2 from table xyz; field1 field2 ------ ------ 100 abcd 101 abcd 111 mnop 3 record(s) selected <EOF> I have managed to use this file with removing first 3 and few bottom rows and just putting data in file manually. Is there a way...