Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006

    Unanswered: Keywords in DB2!!!

    Hi to All
    Suppose i have query like this
    "User" is keyword in DB2 same as in SQL server.
    But my problem is that in SQL server my problem is solved byt writing following query

    Select * from [user] where [user]="" && Here i want to check blank user in user table.. Where as in DB2

    this bracket wont work because in DB2 to manage keywords there you have to write those words in quotes for e.g. "user". so in DB2 my above query would be...

    Select * from "user" where "user"="" && Here i want to check blank user in
    now problem with DB2 query is that i am checking blank user in query so the double quotes wont work..and single quotes also wont work for e.g.

    Select * from 'user' where 'user="" && Here i think single quotes wont work

    Can anybody give me solution....


  2. #2
    Join Date
    Sep 2004
    What about
    Select * from "user" where "user"=''
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting

Posting Permissions

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