Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Unanswered: help with store procedure

    Hi,
    I'm newbie in this informix stuff,
    K, the question: how's the most basic for create an store procedure, I mean, how can I do that, an how it can returns a value,

    thanks !!!!

  2. #2
    Join Date
    Nov 2003
    Location
    Mumbai, India
    Posts
    92
    Hi,

    Here is a short example:

    CREATE PROCEDURE my_square (i INT DEFAULT 0) RETURNING INT; {Notifies return of INT value}
    DEFINE j INT;
    LET j = i * i;
    RETURN j; {Returns value of j to calling module}
    END PROCEDURE;

    You may look at the link below, which points to an official documentation on informix spl in pdf format. The title of the e-book is Informix Guide to SQL and the 8th chapter deals with creating and Using Stored Procedures.

    http://www-3.ibm.com/software/data/i.../4366-pdf.html

    Regards,
    Shriyan

  3. #3
    Join Date
    Mar 2004
    Posts
    2

    Thumbs up thanks !!!!

    Thanks a lot,
    i'll check the link, your help was very usefull
    thanks again...

Posting Permissions

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