Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005
    Posts
    8

    Unanswered: DIFFERENCE BETWEEN FUNCTION & PROCEDURE

    wHAT IS THE EXACT DIFFERENCE BETWEEN FUNCTION & PROCEDURE.

    1.the same code can be shared by many applications.
    2.both can return more than 1 value

  2. #2
    Join Date
    Feb 2005
    Posts
    43
    If I remember this correctly, they behave the same for backwards compatibility. I'm not sure when FUNCTIONS were added to Informix, but, if memory serves me correctly, PROCEDURES pre-date FUNCTIONS.

    Read the IBM Informix Guide to SQL: Syntax manual for the official position on the differences between FUNCTIONS and PROCEDURES. There are sections in the IDS v9.4 and IDS v10 manuals that describe "Relationships Between Routines, Functions, and Procedures" and "Using CREATE PROCEDURE Versus CREATE FUNCTION". You may find the same information in earlier manuals; I haven't looked to be able to say that these sections are in earlier versions of the documentation.

    You may access the manuals online at
    http://www.ibm.com/software/data/informix/pubs/library/

Posting Permissions

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