Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Posts
    2

    Unanswered: DB2 Connect stored proc. Please help

    I have a DB2 stored proc defined as:
    GETJSKRDETAILSBYID
    ( IN ID DECIMAL(10),
    OUT OTITLE CHAR(6), ....)

    How do I specified the output param from ODBC driver SQL command. eg.
    cmd.Execute("{call GETJSKRDETAILSBYID(1111,????,...);}")

    Many thanks in advance...

    Cheers
    Lee Tran

  2. #2
    Join Date
    Aug 2002
    Posts
    35

    Thumbs up


    You just need to set the parameters before you call the stored procedure
    call. Afetre that you just mention spname(?,?).

    You don't need to speficy in the call. You should do before your call.
    vasu

  3. #3
    Join Date
    Sep 2002
    Posts
    2
    Many thanks

    It works.

    Cheers
    Lee Tran

Posting Permissions

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