Results 1 to 4 of 4

Thread: String ?

  1. #1
    Join Date
    Feb 2004
    Posts
    5

    Unanswered: String ?

    I have a table INFO with three columns in db2.

    Table Name Field Type
    Name char
    Loc char
    Profession char.

    Column Name has the following fields
    A
    B
    C
    D
    E
    F
    G

    When I execute this query I get nothing back.

    Select * from INFO where Name > 'B';

    Thanks for your help in advance.

  2. #2
    Join Date
    Dec 2002
    Posts
    134

    Re: String ?

    What tool do you use to execute query?
    If it's command line/shell please add double quotes around SQL (> might be working as stream redirection)

    db2 "with info(name) as (values 'A', 'B', 'C', 'D', 'E') Select * from INFO
    where Name > 'B'"

    NAME
    ----
    C
    D
    E

  3. #3
    Join Date
    Feb 2004
    Posts
    5

    Re: String ?

    I am using QMF. It still wont work.

  4. #4
    Join Date
    Feb 2004
    Posts
    21
    it's works.
    db2 "with info(name) as (values 'A', 'B', 'C', 'D', 'E') Select * from INFO where Name > 'B'"

Posting Permissions

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