Was there any type of dump on the job? If so, then you can check
code with the -804. That will give you the exact reason for this
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
suspicion. You might check the lengths of the input data or the
pointer. This can also cause the problem.
Just some thoughts.
--- "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.