Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Posts
    35

    Unanswered: How to call Stored procedure from command prompt

    HI,

    What is the Syntax for calling db2 stored procedure in db2 command prompt.


    Thanks for the help in advance,

    From,
    vasu
    vasu

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    vasu,
    CALL MySP(inparm1,inparm2,inoutparm1,inoutparm2,?,?)

    where the ? are for out parameters.

    HTH

    Andy

  3. #3
    Join Date
    Aug 2002
    Posts
    35
    Thanks for the help,

    From,
    vasu

    Originally posted by ARWinner
    vasu,
    CALL MySP(inparm1,inparm2,inoutparm1,inoutparm2,?,?)

    where the ? are for out parameters.

    HTH

    Andy
    vasu

Posting Permissions

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