Symptom
- SQL0804N The application program parameters for the current request are not valid. Reason code "106". If a host variable or SQLVAR in the SQLDA is invalid then: host variable/SQLVAR number = "18", SQLTYPE = "485", SQLLEN = "3328", host variable/SQLVAR type = "INPUT". SQLSTATE=07002 row=1
- dev_w##.txt
. . .
C Day Mon DD HH:MM:SS YYYY
C *** ERROR in DB6Execute[dbdb6.c, 5277] CON = 0 (BEGIN)
C &+ DbSlModifyDB6( SQLExecute ): [IBM][CLI Driver][DB2/AIX64] SQL0804N The application program parameters for the cur
C &+ rent request are not valid. Reason code "106". If a host variable or SQLVAR in the SQLDA is invalid then: host
C &+ variable/SQLVAR number = "18", SQLTYPE = "485", SQLLEN = "3328", host variable/SQLVAR type = "INPUT". SQLSTATE=07
C &+ 002 row=1
C &+
C &+ INSERT INTO "<Z_TABLE_NAME>" VALUES( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
C &+ ? )
. . .
C &+ 18 CT=DECIMAL T=DECIMAL L=7 P=13 S=0
. . .
C &+ 18 DECIMAL I=7 000000000E5CCC
. . .
C &+ ABAP location info '<SAP Z program name>', ####
C &+
C *** ERROR in DB6Execute[dbdb6.c, 5277] (END)
B ***LOG BY4=> sql error -804 performing INS on table <Z_TABLE_NAME> [dbtrtab 3770]
B ***LOG BY0=> SQL0804N The application program parameters for the current request are not valid. Reason code "106". If a host variable or SQLVAR in the SQLDA is invalid then: host variable/SQLVAR number = "18", SQLTYPE = "485", SQLLEN = "3328", host
. . .
A Day Mon DD HH:MM:SS YYYY
A
A ABAP Program <SAP Z program name> .
A Source <source_name> Line ###.
A Error Code DBIF_RSQL_SQL_ERROR.
Read more...
Environment
DB2 LUW
SAP ERP 6.0
Keywords
SQL0804N application program parameters current request are not valid Reason code 106 SQLDA invalid then number SQLTYPE SQLLEN host variable SQLVAR type INPUT SQLSTATE row dev work trace ERROR DB6Execute dbdb6.c CON BEGIN DbSlModifyDB6 SQLExecute IBM CLI Driver DB2 AIX64 SQL0804N INSERT INTO Z_TABLE_NAME DECIMAL ABAP location info END sql error -804 performing INS on table dbtrtab ABAP Program Source Line Error Code DBIF_RSQL_SQL_ERROR. , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.