Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

sqlcode : -804 ; sqlstate : 07002

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
thilakvs
Warnings : 1

New User


Joined: 07 Aug 2007
Posts: 27
Location: chennai

PostPosted: Tue Nov 25, 2008 6:53 pm    Post subject: sqlcode : -804 ; sqlstate : 07002
Reply with quote

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
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Dec 02, 2008 8:47 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2 SQL Error: SQLCODE=-440, SQLSTATE... kishpra DB2 1 Sat Feb 18, 2017 2:31 am
No new posts SQLCODE-000000080N priya91 DB2 1 Mon Feb 01, 2016 4:35 pm
No new posts Need to understand SQLCODE = 12 rohanthengal DB2 3 Thu Nov 05, 2015 11:22 am
No new posts SQLCODE -922 in Batch-Cics program tr... kishpra CICS 2 Thu Sep 10, 2015 12:36 pm
No new posts SQLCODE -450 for stored procedure spoorni DB2 3 Fri Jan 16, 2015 2:45 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us