By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,851 Members | 1,746 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,851 IT Pros & Developers. It's quick & easy.

problem with ibm db2 8.1 fixpak11

P: n/a
I upgrade my db2 8.1 from fixpak 7 to fixpak 11, it cause a serious
problem:

in db2 8.1 with fixkpak 7, i use microsoft oledb for odbc + ibm db2
runtime client to access the database. so in my delphi program, i can
use the following code:
(we declare query1 is TADOQuery):

query1.Insert;
query1.FieldByName('user_name').AsString = 'xxxx';
query1.Post;

=================
the above code can be executed successfully.

but when i upgrade to fixpak 11, the above code be executed failed, the
error is :

[IBM][CLI Driver] CLI0125E function sequence error. SQLSTATE=S1010

Feb 23 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Please try following:
db2 CONNECT TO <dbname>
db2 BIND $DB2DIR\BND\@db2ubind.lst GRANT PUBLIC ACTION ADD
db2 BIND $DB2DIR\BND\db2schema.bnd BLOCKING ALL GRANT PUBLIC sqlerror
continue
db2 terminate

Feb 23 '06 #2

P: n/a
In article <11**********************@g14g2000cwa.googlegroups .com>,
ro*****@gmail.com (ro*****@gmail.com) says...
I upgrade my db2 8.1 from fixpak 7 to fixpak 11, it cause a serious
problem:

in db2 8.1 with fixkpak 7, i use microsoft oledb for odbc + ibm db2
runtime client to access the database. so in my delphi program, i can
use the following code:
(we declare query1 is TADOQuery):

query1.Insert;
query1.FieldByName('user_name').AsString = 'xxxx';
query1.Post;

=================
the above code can be executed successfully.

but when i upgrade to fixpak 11, the above code be executed failed, the
error is :

[IBM][CLI Driver] CLI0125E function sequence error. SQLSTATE=S1010


Did you rebind the system packages and ran db2updv8 after installing
the PTF?
Feb 23 '06 #3

P: n/a
thank you very much! pe*********@atlas.cz .

By your detail help, now i can execute the above source code
successfully.

Feb 24 '06 #4

P: n/a
ok. thanks! Gert van der Kooij .
I rebind the db2schema.bnd.
but no run db2updv8.
and my program can run normally.

Feb 24 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.