Hi
 
I'm connecting Squirrel-SQL to an Informix DB; actually on a Cisco UCCX contact centre server.
 
I don't get a list of procedures back from the system in the DB browser.
 
A google turned up this as being the query used to retrieve the list:
 
SELECT T1.procid, T2.data, T2.seqno
FROM informix.sysprocedures AS T1, informix.sysprocbody AS T2
WHERE procname = ?
AND T2.procid = T1.procid
AND datakey = 'T'
ORDER BY T1.procid, T2.seqno
 
If I execute this, it fails, and I get:
 
Error: Too many or too few host variables given.
SQLState:  07001
ErrorCode: -254
 
A little experimentation seems to point to the 'where procname = ?' clause as being the problem; if I remove that I get a list back.
 
So...
 
1) Any idea what that error means? My Informix is still pretty rudimentary.
2) I guess that line is filtering out rows with blank procname fields? Would it be possible to edit the query used by Squirrel-SQL to use something like '!= ''' instead of '= ?'? 
 
Thanks for any input!
 
 
 
 
Aaron Harrison

This email communication does not create or vary any contractual relationship between Logicalis and you. Internet communications are not secure and accordingly Logicalis does not accept any legal liability for the contents of this message. The contents of this email are confidential to the intended recipient at the email address to which it has been addressed. It may not be disclosed to or used by anyone other than this addressee, nor may it be copied in any way. If received in error, please contact Logicalis on the above switchboard number quoting the name of the sender and the addressee and then delete it from your system. Please note that neither Logicalis nor the sender accepts any responsibility for viruses and it is your responsibility to scan the email and attachments (if any).
Logicalis UK Ltd, Registered in England and Wales No: 3732397, Registered Office: 110 Buckingham Avenue, Slough. Berkshire, SL1 4PF

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________