|
|
|
|
|
|
| Author |
Message |
Fan Ruo Xin
*nix forums beginner
Joined: 13 Apr 2005
Posts: 42
|
 Posted: Wed Feb 09, 2005 2:31 am Post subject:
Re: ODBC Issues - SQL0443 SQLSTATE=38553
|
|
|
SQL0101N The statement is too long or too complex. SQLSTATE=54001
When you're getting this error code, you do need to increase stmtheap size.
but I don't know why db2schema bind need a bigger stmt heap size (>512).
"Jason Gyetko" <jgyetko@epower-inc.com> wrote in message
news:tY6Od.2694$ng6.2389@newssvr17.news.prodigy.com...
| Quote: | FYI: Once I changed the STMTHEAP size back to its original value of 512,
the ODBC error returned, so I made it 1024 and now it appears to be
working
again. Not sure if it was the bind or the STMTHEAP increase that resolved
the ODBC error.
"Jason Gyetko" <jgyetko@epower-inc.com> wrote in message
news:Mx5Od.2667$ng6.2074@newssvr17.news.prodigy.com...
I'm running DB2 v8.1 FP5 and am trying to link tables via ODBC from
Access
2002 to my DB2 database. Access lets me connect to the database and
returns
a list of all tables I can select from, but when I select one and choose
OK
(to link or import) I immediately get the following message:
ODBC--call failed.
[IBM][CLI Driver][DB2/NT] SQL0443N Routine "SYSIBM.SQLCOLUMNS"
(specific
name "COLUMNS") has returned an error SQLSTATE with diagnostic text
"SYSIBM:CLI:-727". SQLSTATE=38553 (#-443)
I ran the db2ubind & db2cli binds successfully and attempted to run the
db2schema bind, but received the following errors:
LINE MESSAGES FOR db2schema.bnd
------ -------------------------------------------------------------
SQL0061W The binder is in progress.
2775 SQL0101N The statement is too long or too complex.
SQLSTATE=54001
3838 SQL0101N The statement is too long or too complex.
SQLSTATE=54001
4026 SQL0101N The statement is too long or too complex.
SQLSTATE=54001
4219 SQL0101N The statement is too long or too complex.
SQLSTATE=54001
4364 SQL0101N The statement is too long or too complex.
SQLSTATE=54001
4381 SQL0101N The statement is too long or too complex.
SQLSTATE=54001
SQL0082C An error has occurred which has terminated
processing.
SQL0092N No package was created because of previous errors.
SQL0091N Binding was ended with "8" errors and "0" warnings.
Can anybody tell me what I'm missing or what I'm doing wrong? Any
thoughts
would be greatly appreciated. Thanks.
|
|
|
| Back to top |
|
 |
Jason Gyetko
*nix forums beginner
Joined: 08 Feb 2005
Posts: 11
|
| Posted: Tue Feb 08, 2005 4:49 pm Post subject:
Re: ODBC Issues - SQL0443 SQLSTATE=38553
|
|
|
FYI: Once I changed the STMTHEAP size back to its original value of 512,
the ODBC error returned, so I made it 1024 and now it appears to be working
again. Not sure if it was the bind or the STMTHEAP increase that resolved
the ODBC error.
"Jason Gyetko" <jgyetko@epower-inc.com> wrote in message
news:Mx5Od.2667$ng6.2074@newssvr17.news.prodigy.com...
| Quote: | I'm running DB2 v8.1 FP5 and am trying to link tables via ODBC from Access
2002 to my DB2 database. Access lets me connect to the database and
returns
a list of all tables I can select from, but when I select one and choose
OK
(to link or import) I immediately get the following message:
ODBC--call failed.
[IBM][CLI Driver][DB2/NT] SQL0443N Routine "SYSIBM.SQLCOLUMNS" (specific
name "COLUMNS") has returned an error SQLSTATE with diagnostic text
"SYSIBM:CLI:-727". SQLSTATE=38553 (#-443)
I ran the db2ubind & db2cli binds successfully and attempted to run the
db2schema bind, but received the following errors:
LINE MESSAGES FOR db2schema.bnd
------ -------------------------------------------------------------
SQL0061W The binder is in progress.
2775 SQL0101N The statement is too long or too complex.
SQLSTATE=54001
3838 SQL0101N The statement is too long or too complex.
SQLSTATE=54001
4026 SQL0101N The statement is too long or too complex.
SQLSTATE=54001
4219 SQL0101N The statement is too long or too complex.
SQLSTATE=54001
4364 SQL0101N The statement is too long or too complex.
SQLSTATE=54001
4381 SQL0101N The statement is too long or too complex.
SQLSTATE=54001
SQL0082C An error has occurred which has terminated
processing.
SQL0092N No package was created because of previous errors.
SQL0091N Binding was ended with "8" errors and "0" warnings.
Can anybody tell me what I'm missing or what I'm doing wrong? Any
thoughts
would be greatly appreciated. Thanks.
|
|
|
| Back to top |
|
|
Jason Gyetko
*nix forums beginner
Joined: 08 Feb 2005
Posts: 11
|
| Posted: Tue Feb 08, 2005 4:27 pm Post subject:
Re: ODBC Issues - SQL0443 SQLSTATE=38553
|
|
|
To get the db2schema bind to work, I had to increase the STMTHEAP to 60000.
Once the bind was successful, the ODBC error was resolved.
"Jason Gyetko" <jgyetko@epower-inc.com> wrote in message
news:Mx5Od.2667$ng6.2074@newssvr17.news.prodigy.com...
| Quote: | I'm running DB2 v8.1 FP5 and am trying to link tables via ODBC from Access
2002 to my DB2 database. Access lets me connect to the database and
returns
a list of all tables I can select from, but when I select one and choose
OK
(to link or import) I immediately get the following message:
ODBC--call failed.
[IBM][CLI Driver][DB2/NT] SQL0443N Routine "SYSIBM.SQLCOLUMNS" (specific
name "COLUMNS") has returned an error SQLSTATE with diagnostic text
"SYSIBM:CLI:-727". SQLSTATE=38553 (#-443)
I ran the db2ubind & db2cli binds successfully and attempted to run the
db2schema bind, but received the following errors:
LINE MESSAGES FOR db2schema.bnd
------ -------------------------------------------------------------
SQL0061W The binder is in progress.
2775 SQL0101N The statement is too long or too complex.
SQLSTATE=54001
3838 SQL0101N The statement is too long or too complex.
SQLSTATE=54001
4026 SQL0101N The statement is too long or too complex.
SQLSTATE=54001
4219 SQL0101N The statement is too long or too complex.
SQLSTATE=54001
4364 SQL0101N The statement is too long or too complex.
SQLSTATE=54001
4381 SQL0101N The statement is too long or too complex.
SQLSTATE=54001
SQL0082C An error has occurred which has terminated
processing.
SQL0092N No package was created because of previous errors.
SQL0091N Binding was ended with "8" errors and "0" warnings.
Can anybody tell me what I'm missing or what I'm doing wrong? Any
thoughts
would be greatly appreciated. Thanks.
|
|
|
| Back to top |
|
|
Jason Gyetko
*nix forums beginner
Joined: 08 Feb 2005
Posts: 11
|
| Posted: Tue Feb 08, 2005 3:12 pm Post subject:
ODBC Issues - SQL0443 SQLSTATE=38553
|
|
|
I'm running DB2 v8.1 FP5 and am trying to link tables via ODBC from Access
2002 to my DB2 database. Access lets me connect to the database and returns
a list of all tables I can select from, but when I select one and choose OK
(to link or import) I immediately get the following message:
ODBC--call failed.
[IBM][CLI Driver][DB2/NT] SQL0443N Routine "SYSIBM.SQLCOLUMNS" (specific
name "COLUMNS") has returned an error SQLSTATE with diagnostic text
"SYSIBM:CLI:-727". SQLSTATE=38553 (#-443)
I ran the db2ubind & db2cli binds successfully and attempted to run the
db2schema bind, but received the following errors:
LINE MESSAGES FOR db2schema.bnd
------ -------------------------------------------------------------
SQL0061W The binder is in progress.
2775 SQL0101N The statement is too long or too complex.
SQLSTATE=54001
3838 SQL0101N The statement is too long or too complex.
SQLSTATE=54001
4026 SQL0101N The statement is too long or too complex.
SQLSTATE=54001
4219 SQL0101N The statement is too long or too complex.
SQLSTATE=54001
4364 SQL0101N The statement is too long or too complex.
SQLSTATE=54001
4381 SQL0101N The statement is too long or too complex.
SQLSTATE=54001
SQL0082C An error has occurred which has terminated
processing.
SQL0092N No package was created because of previous errors.
SQL0091N Binding was ended with "8" errors and "0" warnings.
Can anybody tell me what I'm missing or what I'm doing wrong? Any thoughts
would be greatly appreciated. Thanks. |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Thu Jan 08, 2009 2:56 am | All times are GMT
|
|
Lingerie | Free phpBB forum | Debt Consolidation | Mobile Phone | Credit Cards
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
IBM DB2
