SAS Batch job issue

Manny3 — Mon, 30 Oct 2017 15:24:34 GMT

Hi,

I am trying to make a batch job to download data from DB2.I execute a loop in the job which download the

If using the batch user credential I try to download data in a SAS E.G session, it gives the desired output but with a warning message as below:

During read: [IBM][System i Access ODBC Driver]Column 11: CWB0111 - A buffer passed to a system call is too small to hold
return data : [IBM][System i Access ODBC Driver]Column 11: CWB0111 - A buffer passed to a system call is too small to hold
return data : [IBM][System i Access ODBC Driver]String data right truncation. : [IBM][System i Access ODBC Driver]Column
11: CWB0111 - A buffer passed to a system call is too small to hold return data : [IBM][System i Access ODBC Driver]Column

If I schedule it through MC and then check the flow Manager , it exit with reason code 127 and without any error, but inside the loop it execute only once and then it create a sas data set with .lck extension.. nothing else

Please help if anyone has faced this issue earlier.

Regards,

Manny

topic Re: SAS Batch job issue in Administration and Deployment

SAS Batch job issue

Re: SAS Batch job issue