MVSFORUMS.com

syam · Posted: Sun Sep 10, 2006 11:46 am Post subject: Meaining of <> in DB2 queries

Hi,

What does <> stands for in db2 queries ex:

EXEC SQL

SELECT USER_NAME
, USER_ID

FROM MY_TABLE
WHERE SSN_NO <> '1'

END-EXEC
_________________
S Y A M
ONE CAN SMILE AND SMILE AND BE A VILLIAN

kolusu · Posted: Sun Sep 10, 2006 12:19 pm Post subject:

syam,

Check this link which explains in detail about the basic predicates

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNSQH11/2.21.1?SHELF=&DT=20010718164132&CASE=

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

syam · Posted: Mon Sep 11, 2006 12:45 am Post subject:

Thank You
_________________
S Y A M
ONE CAN SMILE AND SMILE AND BE A VILLIAN