Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Posts
    1

    Unanswered: Error creating a procedure with isql

    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.

  2. #2
    Join Date
    Mar 2003
    Location
    Bangalore
    Posts
    12
    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.

  3. #3
    Join Date
    Nov 2002
    Posts
    11
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •