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,605
    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
  •