SAS Batch job issue

[Manny3]

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

[nhvdwalt]

See if this might help....

https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-0000142811...

https://www.experts-exchange.com/questions/21118726/db2-odbc-link-in-Access-returns-A-buffer-passed-...