添加链接
link管理
链接快照平台
  • 输入网页链接,自动生成快照
  • 标签化管理网页链接
Post by muli
I encount a SQL0519N error when I execute a simple query sql(select xxx
from xxx)
AIX 5.2
DB2 8.1.5
Java program
You don't give any information what you are actually doing in your code, so
the only help I could give is a pointer to the error message and its
explanation:

$ db2 "? sql0519"


SQL0519N The PREPARE statement identifies the SELECT or VALUES
statement of the open cursor "<name>".

Explanation:

The application program attempted to prepare the SELECT or VALUES
statement for the specified cursor when that cursor is already
open.

The statement cannot be prepared. The cursor was not
affected.

User Response:

Correct the application program so it does not attempt to prepare
the SELECT or VALUES statement for a cursor that is open.

sqlcode : -519

sqlstate : 24506
--
Knut Stolze
DB2 Information Integration Development
IBM Germany