Error 201 Syntax Error when try to create a Stored Procedure using Informix-SQL (ISQL)

Troubleshooting

Problem

When you use ISQL to create a Stored procedure get the following error # ^ # 201: A syntax error has occurred. #

Cause

Product is not designed to do that.

Diagnosing The Problem

According to documentation, Stored Procedures can only be created using dbaccess or ESQL/C API.

"SPL statements can be used only inside the CREATE PROCEDURE, CREATE PROCEDURE FROM, CREATE FUNCTION, and CREATE FUNCTION FROM statements. All these statements are available with SQL APIs such as IBM® Informix® ESQL/C. The CREATE PROCEDURE and CREATE FUNCTION statements are available with DB-Access."

Resolving The Problem

Use dbaccess to create Stored Procedures

*Cross-reference information*
Product	Component	Platform	Version
Informix Tools		AIX; HP-UX; Linux; Solaris; Windows	6.0, 7.2, 7.3, 7.5
Informix Tools		Platform Independent	All Versions

[{"Product":{"code":"SSVT2J","label":"Informix Tools"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Informix SQL (I-SQL)","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"6.0;7.2;7.3;7.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSVT2J","label":"Informix Tools"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Was this topic helpful?

Document Information

More support for:
Informix Tools

Software version:
6.0, 7.2, 7.3, 7.5

Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows

Document number:
518593

Modified date:
16 June 2018

UID

swg21689642

IBM Support

Tips