Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1307
  • Last Modified:

DB2 Error

[IBM][CLI Driver][DB2] SQL0514N The cursor "SQLCUR4" is not in a prepared state. SQLSTATE=26501

I get the following error when trying to retrieve data what is the solution

Thanks.
0
raheis
Asked:
raheis
1 Solution
 
AnilKumarSharmaCommented:
Your SQLSTATE code tells the problem.
 
It starts with 26 that is it belongs to class code 26, and Class Code 26 belongs to Invalid SQL Statement Identifier.
So  Class Code 26: Invalid SQL Statement Identifier SQLSTATE Value       
The 501 one is specific error meaning - The statement identified does not exist.

To get more information, please check
http://support.microsoft.com/kb/321002

If above doesn't help then to get more insight, Please provide your DB2 version, platform, and the exact command you are running. Are you exporting between different OS filesystem?

0
 
momi_sabagCommented:
CAN you post your code here?
0
 
raheisAuthor Commented:
Hello Thanks for the quick response, after debugging found that columns being selected dont exist in the TEST environment.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now