View previous topic :: View next topic
|
Author |
Message |
esther_ebe
New User
Joined: 21 Jan 2010 Posts: 2 Location: India
|
|
|
|
Hi,
I am using a SELECT query in EZT. While running the job in Test region, the job runs fine and generates output. But on running the job in regions other than the test, the job abends with -514.
Please see the abend details below.
SQLCODE -514
Cursor 'C07' has never been prepared or was invalidated by a COMMIT or
ROLLBACK (or the equivalent).
Corrective action:
Ensure that you prepare the statement that is named in the DECLARE
CURSOR statement before opening the cursor. Do not issue COMMIT or
ROLLBACK until after you are finished using the cursor, or prepare the
statement again after the COMMIT or ROLLBACK.
But I am using only a SELECT query.
please find the query used in the EZT.
SELECT DATE
FROM TABLE
WHERE DATE IS NOT NULL
ORDER BY DATE DESC
FETCH FIRST ROW ONLY
Please advise |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello and welcome to the forum,
Suggest you speak with your database support.
From what has been posted, it sounds like there is an improper setup for the new environment. |
|
Back to top |
|
|
|