Solved

Invalid parameter number. SQLSTATE=S1093

Posted on 2007-11-15
5
5,953 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
OPENQUERY syntax errors (not recognizing CROSS APPLY) 17 582
db2 - u 3 229
Tricky SQL question 13 388
Authentication failing when using Powershell to connect to DB2 database 6 87
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 (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…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

937 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

1 Experts available now in Live!

Get 1:1 Help Now