I get a message error when trying to create a procedure from the isql window. Sintax Error (201), It happens with any procedure.

Informix version 7.20

Thanks in advance.

Hi,

You are in the wrong DBforum, isql is for Sybase.
Anyway syntax error 201 implies the following,
==============================================
Procedure %.*s expects parameter %.*s, which was not supplied.

Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects, variable names, and/or input data.
==============================================

But if you have mistakenly said isql, from the session where you had started the informix, run finderr 201 and see the explanation. Also from dbaccess you can try running your syntax and if it is wrong it will show you where the syntax is wrong.

Regards,
Kiran.

You are not allowed to create SPs using the ISQL product, use dbaccess instead. Use isql if you wish to work with SQLs (DDL, DML)forms and reports.

HTH

Ghed