473,324 Members | 2,257 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

problem with ibm db2 8.1 fixpak11

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
4 1563
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
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
thank you very much! pe*********@atlas.cz .

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

Feb 24 '06 #4
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

117
by: Peter Olcott | last post by:
www.halting-problem.com
2
by: Demetris | last post by:
Hello people! I have a strange problem with some stored procedures here is a sample of a stored procedure that has a problm with the dates. CREATE PROCEDURE TEST_DATE (OUT G_LAST_DATE DATE) ...
28
by: Jon Davis | last post by:
If I have a class with a virtual method, and a child class that overrides the virtual method, and then I create an instance of the child class AS A base class... BaseClass bc = new ChildClass();...
6
by: Ammar | last post by:
Dear All, I'm facing a small problem. I have a portal web site, that contains articles, for each article, the end user can send a comment about the article. The problem is: I the comment length...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.