Dynamic SQL error

Robert A. (Cameron of Pittsburgh at Alcoa) Knight

Dynamic SQL error
I have a user receiving a -804 sqlstate 07002

Job has been running until this am. Anybody
ever run into this before or have any ideas
where to look?

Bob Knight



Syed (TATA) Fazal

Re: Dynamic SQL error
(in response to Robert A. (Cameron of Pittsburgh at Alcoa) Knight)
Bob,

You can check for the error in Messages and Code Manual of DB2. You must
have got a reason code for it.
Link for you - http://publib.boulder.ibm.com/epubs/pdf/DSNMC0G3.pdf

Regards,
Syed

-----Original Message-----
From: Knight, Robert A. (Cameron of Pittsburgh at Alcoa)
[mailto:[login to unmask email]
Sent: Friday, December 13, 2002 11:13 AM
To: [login to unmask email]
Subject: Dynamic SQL error


I have a user receiving a -804 sqlstate 07002

Job has been running until this am. Anybody
ever run into this before or have any ideas
where to look?

Bob Knight








Myron Miller

Re: Dynamic SQL error
(in response to Syed (TATA) Fazal)
Was there any type of dump on the job? If so, then you can check the reason
code with the -804. That will give you the exact reason for this error.

Suspect that the job got some data that it didn't expect and exceeded the limit
of a table that caused the program to overlay SQLDA. But that's just a
suspicion. You might check the lengths of the input data or the input data
pointer. This can also cause the problem.

Just some thoughts.

Myron
--- "Knight, Robert A. (Cameron of Pittsburgh at Alcoa)"
<[login to unmask email]> wrote:
> I have a user receiving a -804 sqlstate 07002
>
> Job has been running until this am. Anybody
> ever run into this before or have any ideas
> where to look?
>
> Bob Knight
>
>
>
>
>


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com



David S Waugh

Re: Dynamic SQL error
(in response to Myron Miller)
Robert:

Was there a Reason Code associated with the -804? (Should have been in the range of 01 thru 15)...

David Waugh, NCW
DSW Consulting & Services
Former DB2 Sysprog, now clueless DB2 UDB Win/NT DBA


---------- "Knight, Robert A. (Cameron of Pittsburgh at Alcoa)" <[login to unmask email]> writes:

From: "Knight, Robert A. (Cameron of Pittsburgh at Alcoa)" <[login to unmask email]>
To: [login to unmask email]
Subject: Dynamic SQL error
Date: Fri, 13 Dec 2002 11:13:01 -0500

I have a user receiving a -804 sqlstate 07002

Job has been running until this am. Anybody
ever run into this before or have any ideas
where to look?

Bob Knight