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?
joinsaigonAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
ocgstylesConnect With a Mentor Commented:
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:
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:
Note: You need to be connected to the database for those statements to work.
0
 
joinsaigonAuthor Commented:
thank you
0
All Courses

From novice to tech pro — start learning today.