thilakvs Warnings : 1 New User
Joined: 07 Aug 2007 Posts: 27 Location: chennai
|
|
|
|
Please guide me in this issue.. I am getting this error while trying to invoke the mainframe StoreProcedure from Command editor.
Error:
SQL0804N The application program parameters for the current request are not valid. Reason code "". If a host variable or SQLVAR in the SQLDA is invalid then: host variable/SQLVAR number = "", SQLTYPE = "", SQLLEN = "", host variable/SQLVAR type = "". SQLSTATE=07002
SQL0804N The application program parameters for the current request are not valid. Reason code " ". If a host variable or SQLVAR in the SQLDA is invalid then: host variable/SQLVAR number = "1208", SQLTYPE = "P571RL ", SQLLEN = "DB81MVS", host variable/SQLVAR type = "QDB2".
Explanation:
An error occurred while processing the current request.
o The call parameter list, which is created by the precompiler,
may not be correct if the application programmer has modified
the output of the precompiler or over-written the call
parameter list in another way.
o The SQLDA or host variable(s) in the SQL statement are
invalid.
o The request being made is not supported or is out of
context.
Reason codes are interpreted as follows:
100 The request being made is not supported or is out of
context.
101 SQLDA.SQLN is less than SQLDA.SQLD
102 SQLVAR.SQLTYPE is invalid.
Federated system users: A data type that you specified is not
supported by either the federated server or the data source that
you want to access.
103 The length specified in SQLVAR.SQLLEN or SQLVAR2.SQLLONGLEN
is incorrect for the SQL type given in SQLVAR.SQLTYPE.
104 Doubling of the SQLVARs is expected, but the SQLDOUBLED
field of SQLDA.SQLDAID is not set to '2'. This may be required
because of a large object type or a structured type.
105 A double-byte character Large Object has an odd value
indicated by the SQLVAR2.SQLDATALEN pointer, which is always in
terms of bytes, even for DBCLOBs.
106 The SQLDATA pointer is invalid or points to insufficient
storage.
107 The SQLIND pointer is invalid or points to insufficient
storage.
108 The SQLDATALEN pointer is invalid or points to insufficient
storage.
109 A specific number of host variables/SQLVARS is expected for
the current SQL statement.
110 The LOB locator is not associated with a LOB of a compatible
type.
111 A LOB is indicated by the SQLTYPE of the SQLVAR, but the
second SQLVAR is null.
112 The SQLDATATYPE NAME field is not valid. It does not conform
to the format for identifying an existing user-defined type in
the database. The format for identifying an existing
user-defined type is as follows: 8 bytes, followed by a period,
followed by 18 bytes.
113 The SQLFLAG4 field is not valid. If a structured type is
specified the value must be X'12'. If a reference type is
specified the value must be X'01'. Otherwise the value must be
X'00'.
114 The DB2_TRUSTED_BINDIN registry variable is enabled, and an
unsupported host variable data type is being used during bindin.
Either unset the DB2_TRUSTED_BINDIN registry variable or change
the data type of the input host variable.
In SQL statements with host variables, use the host variable
number to count in from the beginning of the statement (or
substatement, in the case of compound SQL) to locate the invalid
host variable. For statements using an SQLDA, the SQLVAR number
is used to locate the invalid SQLVAR. For an input SQLDA, count
only input host variables or SQLVARs; similarly for output. Note
that this number is based at 1.
The statement cannot be processed.
User Response:
Examine the application program for any errors noted. Note that
the programmer should not attempt to modify the precompiler
output.
Federated system users: If you received reason code 102, specify
a supported data type and resubmit the program.
sqlcode : -804
sqlstate : 07002 |
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
What do you call the "Command editor"?
Please do not post entire reference text - whether from the IBM manuals or some other source.
Suggest you use the "IBM Manuals" link at the top of the page to learn where the IBM DB2 Messages and Codes may be found.
If you look at the IBM manual, you will see that IBM provides a different list of reason codes. |
|