Problem while running job through shell script
Posted: Mon Apr 24, 2006 6:52 am
Hi,
I am using Datastage 7.5.1.A edition. I am facing one problem. I am trying to run a job through shell script using the following comand in the DSHOME directory:
dsjob -run FINLANDPRJ test_contact_load
where FINLANDPRJ is the project name
and test_contact_load is the job name.
It's showing job aborted after 50 errors. But while running the same job manually through the client it's running perfectly ok without any error.
I have drilled down the matter and found out that the command is working fine if we are populating upto 60 columns. The moment I add 61st column it's showing error using the above command, but even after adding the 61st column it works perfectly ok while running it through client.
In another job although the number of columns is less than 60 but it was showing the same problem. It was due to the date field and after modification of the code it worked perfectly fine.
Please help me in solving this problem.
Thanks and Regards
Amit
I am using Datastage 7.5.1.A edition. I am facing one problem. I am trying to run a job through shell script using the following comand in the DSHOME directory:
dsjob -run FINLANDPRJ test_contact_load
where FINLANDPRJ is the project name
and test_contact_load is the job name.
It's showing job aborted after 50 errors. But while running the same job manually through the client it's running perfectly ok without any error.
I have drilled down the matter and found out that the command is working fine if we are populating upto 60 columns. The moment I add 61st column it's showing error using the above command, but even after adding the 61st column it works perfectly ok while running it through client.
In another job although the number of columns is less than 60 but it was showing the same problem. It was due to the date field and after modification of the code it worked perfectly fine.
Please help me in solving this problem.
Thanks and Regards
Amit