Results 1 to 3 of 3

Thread: DB2 queries

  1. #1
    Join Date
    Feb 2004
    Posts
    4

    Unanswered: DB2 queries

    Hi just a quick question, how do you query tables in DB2. Ive been uysing mysql so know most of the commands, but if i want to search a table for things like "select * from person where birthdate>'1982'" it doesnt let me. Can i use sql commands? for example like, >, <, %text%, and if so how? Thanks!

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: DB2 queries

    You may want to look at the SQL reference:

    http://www-3.ibm.com/cgi-bin/db2www/...bs.d2w/en_main

    There are some differences between SQL dialects; in your case it is the way db2 handles date-time literals, I assume.

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: DB2 queries

    You may also want to have a look at the SQL cookbook ...

    Link available in www.db2click.com

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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