Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    manila
    Posts
    21

    Exclamation Unanswered: does CASE stmt allow using HOST VAR

    In a COBOL program, does CASE statement allows the use of host variable? Please help anyone?


    select case(A)
    when :hostvar then value
    when value1 then value2
    end case as B
    from table1

  2. #2
    Join Date
    Jan 2003
    Posts
    1,629
    Provided Answers: 1
    Hi,

    Please read Must read before posting thread for more tips on how to write effective post.

    What is the version and OS of DB2 database?

    Hope this helps,
    Grofaty

  3. #3
    Join Date
    Nov 2003
    Location
    Germany
    Posts
    62
    For DB2 on the mainframe, the syntax looks a little bit different:

    select case A
    when :hostvar then value
    when value1 then value2
    end as B
    from table1

    HTH

Posting Permissions

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