Solved

How do I resollve a [IBM][CLI Driver] CLI0125E  Function sequence error. SQLSTATE=HY010.

Posted on 2007-11-13
3
7,602 Views
Last Modified: 2008-02-01
I have a simple SQL that I want to explain using UDB Control Center command editor explain feature. Regardless of what environment that I tried (system test or product or UAT), I get error
"[IBM][CLI Driver] CLI0125E  Function sequence error. SQLSTATE=HY010" This error occur only when I tried to generate a visual explain of the access path. If run the SQL without asking for the e3xplain plan, the sql execute successfully. I am running DB2 UDBv8.2 fixpak 14.
How can I go about resolving this problem with control center explain functionality.
 
0
Comment
Question by:Enuda
  • 2
3 Comments
 
LVL 5

Expert Comment

by:ocgstyles
ID: 20277453
Hi Enuda,

Try rebinding the following system package:

db2 ~/sqllib/bnd/db2schema.bnd blocking all grant public sqlerror continue

Keith
0
 
LVL 5

Accepted Solution

by:
ocgstyles earned 125 total points
ID: 20294709
Sorry, that should be:

db2 bind ~/sqllib/bnd/db2schema.bnd blocking all grant public sqlerror continue

Keith
0
 

Author Comment

by:Enuda
ID: 20296421
ocqstyles,
Thank you for your response. Your suggestion did solve my problem.

Again, thanks
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
As400 Db2 to MS Sql server (data/schema) only 6 337
Problem to script 14 186
DB2 Integer to Decimal 1 131
formatting db2 dates in a sql statement where clause 9 323
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question