help with odbc error

[ddiamond]

I'm getting the following odbc error on iSeries:

[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0516 - Prepared statement QZ8BC8B5B7B59B50D6 not found

The strange part is that I'm not working with a prepared statement. I'm simply trying to execute the following sql query:

insert into zecodf00 (
  cemanu,
  cemase,
  cerkrs,
  cesdsq,
  cecvsq,
  ceedno,
  ceprco,
  cekpsq,
  cerecd,
  cesxcd,
  cectcc,
  cectco,
  cedgsq,
  ceitgq,
  cecvng,
  ceascd,
  ceundt,
  certcd,
  cestdt,
  ceendt,
  cecoms,
  ceogcu,
  cecvla,
  ced1oc,
  cexsam,
  ced2oc,
  ceraam,
  cecvac,
  ced2ql,
  cecvpr,
  cecva1,
  ceeaea,
  cecvap,
  cepbam,
  cecvn1,
  cecvt1,
  cecvn2,
  cecvt2,
  cecvug,
  cecvmj,
  cecvpf,
  cecv1l,
  cecv1f,
  cecv2l,
  cecv2f,
  cecv3l,
  cecv3f)
select
  comanu,
  comase,
  corkrs,
  cosdsq,
  cocvsq,
  coedno,
  coprco,
  cokpsq,
  corecd,
  cosxcd,
  coctcc,
  coctco,
  codgsq,
  coitgq,
  cocvng,
  coascd,
  coundt,
  cortcd,
  cocpst,
  cocped,
  cocoms,
  coogcu,
  cocvla,
  cod1oc,
  coxsam,
  cod2oc,
  coraam,
  cod2ql,
  cocvac,
  cocvpr,
  cocva1,
  coeaea,
  cocvap,
  copbam,
  cocvn1,
  cocvt1,
  cocvn2,
  cocvt2,
  cocvug,
  cocvmj,
  cocvpf,
  cocv1l,
  cocv1f,
  cocv2l,
  cocv2f,
  cocv3l,
  cocv3f
from patty.zucoadm

 

[ddiamond]

I ran this query directly on the as400 and got the error message: file zocedf00 not found. That error message was actually useful. The table should have been zucodf00. I'm starting to realize that odbc error messages are not reliable.