Joined: 14 Oct 2005 Posts: 1187 Location: Bangalore,India
Description of the Error:The call parameter list or the SQLDA is invalid. One of the following conditions exist: * The call parameter list, which is created by the precompiler, may be invalid if the application programmer has modified the output of the precompiler, used a variable name beginning with 'SQL' in the application program, or overwritten the call parameter list in some other way. * The SQLDA, which is created by the application program, has an invalid length or may contain an invalid data type or data length.* The value of SQLDABC is not consistent with the value of SQLD.
User response:Examine the application program for any of the errors noted under the explanation above. Note that, in general, the application programmer should not attempt to modify the output of the precompiler.
Joined: 20 Oct 2006 Posts: 6970 Location: porcelain throne
you have either modified the pre-compiler generated CALLs to DSNLI or have used an definition of the sqlca that does not match your db2 version. Reseting SQLCA fields is useless because they are not used by db2 as input - they are output fields to db2.