|
Hi, I'm a newbie to the AS400 platform with much database, SQL, and DB2 experience on other platforms. I am trying to cut and paste SQL from RPG programs into Navigator in the Run SQL Scripts to do a Visual Explain. On other platforms, explains allow you to replace host variables in the code with "?". When I try that here I get a message which I can not seem to find in any manuals, online help, etc. Does anyone know how to do this? Here is a generasized version of the program SQL and the message I receive when I try the Explain. SQL: select max(colx) from schema.tab1 where cola = ? and colb = ? and colc = ? ; Mystery Error messsage: The number of parameter values set or registered does not match the number of parameters. Connie K.
This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.