DB2 SQL error code-302

The main variable value of sql0302n in the execute or open statement is used accordingly.

Too large.

Note:

It is found that the value of the input primary variable is too large for use in select, values, or pre-compiled statements.

. One of the following situations has occurred:

* The corresponding primary variables or parameter tags used in SQL statements are defined as strings, but the input primary variable package

The contained string is too long.

* The corresponding primary variables or parameter tags used in SQL statements are defined as numbers, but the input primary variables include

The value is out of the range.

* The ending character NUL is lost in the main variable of the string terminated with NUL in C language.

* Federated system users: In the transfer session, the restrictions specific to the data source may be violated.

Because incorrect primary variables or incorrect

Sqllen value, so this error occurs.

The statement cannot be processed.

User response:

Make sure that the type and length of the input main variable value are correct. If you enter a primary variable to provide a value to the parameter tag

Match these values with the implicit data type and length of the parameter tag.

Federated system users: for transferring sessions, determine which data source causes the error (see Fault Diagnosis

Guide to learn how to identify a failed data source ). Check the SQL dialect of the data source

Determine the specific violation and adjust the failed statement as needed.

Sqlcode:-302

Sqlstate: 22001,220 03