Solved

Invalid parameter number. SQLSTATE=S1093

Posted on 2007-11-15
5
6,122 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 5

Expert Comment

by:ocgstyles
ID: 20294703
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
ID: 20304467
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
ID: 20305691
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
ID: 20305696
Note: You need to be connected to the database for those statements to work.
0
 

Author Closing Comment

by:joinsaigon
ID: 31409316
thank you
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
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…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

752 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