<div>
Hello Thanks for the quick response, after debugging found that columns being selected dont exist in the TEST environment.
</div>


Hello Thanks for the quick response, after debugging found that columns being selected dont exist in the TEST environment.

<div>
<div class="content wysiwyg-content">
[IBM][CLI Driver][DB2] SQL0514N The cursor &quot;SQLCUR4&quot; is not in a prepared state. SQLSTATE=26501<br />
<br />
I get the following error when trying to retrieve data what is the solution<br />
<br />
Thanks.
</div>
</div>


[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.

DB2 Error

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.