PREPARE or EXECUTE IMMEDIATE statement is blank or empty

karry450 · Post by **karry450** » Wed Feb 02, 2011 6:41 am

Hi Friends,

I am trying to load one file from as400using a db2 stage with some presql and post sql in it,But my jobs fails with the following error

Fatal: [IBM][CLI Driver][AS] SQL0198N The statement string of the PREPARE or EXECUTE IMMEDIATE statement is blank or empty. SQLSTATE=42617
DSTAGE-DB2CLI-0027`:`SQLExecDirect: Error executing statement '
'. See following DB2 message for details. [dscapiop.C:2153]

can any one help me on this

chulett · Post by **chulett** » Wed Feb 02, 2011 9:23 am

Not unless you explain what you are doing pre/post sql and post the "following DB2 message".

karry450 · Post by **karry450** » Wed Feb 02, 2011 11:43 pm

chulett wrote:Not unless you explain what you are doing pre/post sql and post the "following DB2 message".

I am creating some alias for some tables in pre sql and in after sql I am dropping the the alias of some other tables

ppgoml · Post by **ppgoml** » Thu Feb 03, 2011 1:07 am

I tried this using an ODBC connector while I extracted data from as400 multi-member tables. it works file to me.

I suggest you bind ddcs400.lst on your db2 if you have not done it.