-804 error in subprogram

Baskaran · New User Joined: 24 Oct 2006 Posts: 32 Location: India

Hi All,

I have an issue which is -804 this DB2 error message happens after the first queary of my sub program executes (Open cursor).This was a production code which is active and running daily with out any abend,

i get this error for a particular record in our test region.Can any one of you give a solution how to resolve it.

Thanks
Baskaran

nuthan · Posted: Tue Oct 16, 2007 3:02 pm

The reason for -804 is:

An error occurred while processing the current request.

-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.
-The SQLDA or host variable(s) in the SQL statement are invalid.
-The request being made is not supported or is out of context.

nuthan · Posted: Tue Oct 16, 2007 3:17 pm

Also check the the values u have passed for the host variables of the cursor..

guptae · Posted: Tue Oct 16, 2007 3:17 pm

Hi Baskaran,

Please provide the reason code as well or paste the spool message.

Baskaran · New User Joined: 24 Oct 2006 Posts: 32 Location: India

The reason code i got was reson code = 06 ,i have a checked with host variable too,Since it is production code there is no changes in host variable.

nuthan · Posted: Tue Oct 16, 2007 5:19 pm

Check the data in host variables, whether it is a valid value or not.