joinsaigon
asked on
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?
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?
ASKER
i don't understand,you can explain again,step by step!! thank you very much
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Note: You need to be connected to the database for those statements to work.
ASKER
thank you
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