Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2007
    Posts
    4

    Unanswered: XSR Registration with Stored Procedures

    I am trying to register an XML Schema using ODBC interface. I am calling the Stored Procedure in the following way:

    CALL SYSPROC.XSR_REGISTER ('USER', 'Address', 'C:\\Address.xsd',?, NULL)

    I get the following error message:

    42886(-469)[IBM][CLI Driver][DB2/NT] SQL0469N The parameter mode (IN, OUT, or INOUT) is not valid for a parameter in procedure "XSR_REGISTER" with specific name "XSR_REGISTER" (parameter number "0", name "RSCHEMA"). SQLSTATE=42886

    I have also tried this with using the SQLBindParameters method which seems to work but at execution time I get the same message.

    I am really out of clues what is going on here and my guess that it is now either a bug or an issue with how to call CLI methods.

    I have of course in the SQLBindParameters method played around with the IN , OUT, INOUT modes, but this made no difference.

    Any help here would be appreciated.

    Regards,
    Mohan

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    How'bout replacing NULL with CAST(NULL AS BLOB(5M))?
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Apr 2007
    Posts
    4

    No difference

    I tried this but found no difference. The only hint that I have received is that this could be a DB2 bug fixed in the FixPack 2.

    Internally I am using the ODBC methods, but i think its a problem of the database because other apps that use ODBC are returning to me the same message.

    If you know anything about the issue would be much appreciated.

    Thanks,
    Mohan

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    The 2nd parameter of the procedure is an INOUT parameter (http://publib.boulder.ibm.com/infoce.../c0022710.htm). So have you tried to use SQLBindCol() to provide some storage for the output value?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  5. #5
    Join Date
    Apr 2007
    Posts
    4
    Thanks... this was the trick!

Posting Permissions

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