SQL Error -302 while inserting into database table

[former_member186608]

Dear community,

not sure if my concern is located correctly here, however I would like to have your comments on the following issue I am encountering on a SAP system.

The system is running on a DB6 database.

I have a database table and I want to insert a new tuple there. The work area used in the open SQL insert statement is typed as the database table. Hence from a data type perspective, the runtime environment should take care that all values in the work area correspond accordingly to the schema of the database table.

However, I am receiving a short dump stating the following:

sql error -302   performing INS on table DATABASE_TABLE_NAME               [dbtrtab#3770]

SQL0302N  The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use.  SQLSTATE=22003 row=1 [dbtrtab#3770]

I have investigated in the debugger whether this is a corrupt value or something similar, but was not able to find any suspicious field.

I have no clue how to proceed. Is there any possibility to examine which component of the work area causes the issue?

Thanks in advance and looking forward to a discussion with you all,

Marco

[Former Member]

Hi Marco,

Could you check the solution in link

http://publib.boulder.ibm.com/infocenter/cmx/v8r3m0/index.jsp?

topic=%2Fcom.ibm.sysadmin.hlp%2Ftrs20002.htm

Hope this helps.

Regards,

Deepak Kori