Help on CLI
Posted in 1999
Bashar Chalabi — — source: Informix-list mailing list archive (1991-1998)
I am using CLI2.8 against IDS 7.3 TC7, on NT. I am trying to send a Create
Procedure statement through CLI.
While it works in most case, there are some cases where CLI returns:
General Error. Syntax Error (-11060).
Please note this is a CLI error, not a server one.
The syntax is correct as the same statement works from SQL Editor.
For example:
-----------------------------------------------
Create DBA Procedure Proc1()Define i integer;
Select Col1 into i from Table1;
Select Col1 into i from Table1;
End procedure;
------------------------------------------
returns a CLI syntax error. However, just by removing one of the select
statements, it works.
Any ideas, anyone?
Thanks
Bashar Chalabi
CTL, London.