DSXchange

Please mark this as resolved.

It seems that , you have enterered some wrong user and password in DB connection. Please check this.

Plese check in source any null value is there for salary field.

Might be job information got removed or corrupted from direcory RT_LOG3024 in your project area. Please try to copy the file and re-compile and rerun the same.

Sorry James. I have requested to you since it is urgent. I will do some research in this problem otherwise i will do post the same in this forum.

Thanks.

Ok. I send command for Unix.. Might be Number of fields are less comparing with your file.

Please check your sequencial file in unix using below command
awk -F ',' '{print $34}' infile | sort -n | uniq -c
It might be your data contains some wrong value.

Is it fixed length file or delimiter file?

Will appreciate your help in this. Thanks.

Hi, Jobs are getting compiled properly but when we run the job it showing aborted status. But there is no issue in ds creation and table loading in this. Issue is only job status show aborted in directory after restart server. log: SFile_0,0: Import complete; 2221 records imported successfully, 0 re...

Thank you.I will try.

Please use aggregator stage.

I am not able to read negative value using schema file from sequencial file. I can read below value and process 00000000000098750 But not able to read below value and getting error message 0000000000000-112 CImpBySchFile,0: Field "i_amt" has import error and no default value; data: {20 0 0...

Hi ,

Did you get any error message while reading ? If so, Please provide the same to check.

It is not related to DataStage error. Error with out data.

command to find error message :

oerr ora 01722

01722, 00000, "invalid number"