Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003

    Unanswered: Store procedure on INFORMIX SE

    *-- ONLY INFORMIX SE 7.1
    Is there any possibility to control on a store procedure if a parametr is passed and if not to have a default value ?
    I didn't find anything in documentation !

    Thanks a lot
    Tabacaru Teodor

  2. #2
    Join Date
    Dec 2002
    Portland, OR, USA

    According to my manuals, you can specify DEFAULT values for input arguments into your stored procedure when you declare them, although my initial attempts to do that were unsuccessful. However, you can also check: 'IF (my_input_arg IS NULL) THEN ... LET my_input_arg = my_default_value; ...' that kind of thing works quite reliably.

    I am using SE 7.25 on Red Hat Linux 7.3, but this should work across a wide variety of releases and combinations. You probably solved this problem long ago, and didn't update the posting, but if not, I hope this helps.

Posting Permissions

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