Data Replication 2
Results 1 to 2 of 2

Thread: Null value to stored procedure

  1. #1
    cronin_john@yahoo.com is offline Junior Member
    Join Date
    Jul 2009
    Posts
    2
    Rep Power
    0

    Null value to stored procedure

    Platform: OpenVMS V7.3
    Cobol

    Trying to pass a null value to a stored procedure in MS Sql Service.

    Data described as:

    01 Field1 Pic X Value X"00".

    It fails on the prepare by saying the prepare doesn't have a right parenthesis. It seems like Field1 knocks of the rest of the prepare statement, even though in the symbolic debugger it looks fine when examined. The syntax error is retrieved by a call to sqlerror.

    Thanks in advance,
    John Cronin

  2. #2
    cronin_john@yahoo.com is offline Junior Member
    Join Date
    Jul 2009
    Posts
    2
    Rep Power
    0

    Answer:

    Pass it as the word Null without any quotes.

Posting Permissions

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