• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6675
  • Last Modified:

Invalid parameter number. SQLSTATE=S1093

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
joinsaigon
Asked:
joinsaigon
  • 3
  • 2
1 Solution
 
ocgstylesCommented:
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
 
joinsaigonAuthor Commented:
i don't understand,you can explain again,step by step!! thank you very much
0
 
ocgstylesCommented:
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
 
ocgstylesCommented:
Note: You need to be connected to the database for those statements to work.
0
 
joinsaigonAuthor Commented:
thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now