Solved

Invalid parameter number. SQLSTATE=S1093

Posted on 2007-11-15
5
5,908 Views
Last Modified: 2012-08-13
I'm getting error "Invalid parameter number. SQLSTATE=S1093" when I
attempt to ADD or modify rows within the Control Center (open table
option). However, using the command editor within Control Center to
run SQL statements works perfectly. Since I'm in the same user
context for both operations, that eliminates security issues. Is
there a bug in the Control Center Open table UI?
0
Comment
Question by:joinsaigon
  • 3
  • 2
5 Comments
 
LVL 5

Expert Comment

by:ocgstyles
Comment Utility
Hi,

You can try rebinding the system packages.  From the sqllib/bnd directory, run these:

db2 bind @db2ubind.lst blocking all grant public
db2 bind @db2cli.lst blocking all grant public
db2 bind db2schema.bnd blocking all grant public sqlerror continue
0
 

Author Comment

by:joinsaigon
Comment Utility
i don't understand,you can explain again,step by step!! thank you very much
0
 
LVL 5

Accepted Solution

by:
ocgstyles earned 500 total points
Comment Utility
Hi,

Sure.  A package is *basically* the access plan(s) for one or more SQL statements.  When the SQL is bound to the database, it can be parsed and optimized once (when bound), rather than on each execution.  You can read a bit more on packages here:
http://www.datadirect.com/developer/odbc/using_db2_packages/index.ssp
http://www.db2mag.com/qanda/050118.shtml

Anyway, the packages I listed above are the common "system" ones you'll encounter.  They are  automatically bound during install or migration.  I just wanted you to re-run them in case there's were some problems...

These bind files are located in the sqllib/bnd directory.  I don't work on Windows too often, but for Unix/Linux they are in:

<instance_owner>/sqllib/bnd

Just cd into that directory and run these 3 commands at the command prompt:

db2 bind @db2ubind.lst blocking all grant public
db2 bind @db2cli.lst blocking all grant public
db2 bind db2schema.bnd blocking all grant public sqlerror continue

Hope that helps,

Keith
0
 
LVL 5

Expert Comment

by:ocgstyles
Comment Utility
Note: You need to be connected to the database for those statements to work.
0
 

Author Closing Comment

by:joinsaigon
Comment Utility
thank you
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Last 4 fiscal years for a given date 8 207
Problem to script 14 173
Access Pass Through Query rounding off ending zeros 9 85
DB2 V9.7 restore 5 27
November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
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…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

762 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now