Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

db2 SQL (Null) 1

Status
Not open for further replies.

PatelRam

Programmer
Aug 20, 2003
87
US
Hi


How do i write following Oracle SQL in db2 ?

Oracle:
select * from emp where ename is null

db2 :

?

Thanks,
 
it will be the same but it may need to be upper case

SELECT * FROM emp WHERE ename IS NULL

reference for your conversions
DB2 SQL Reference

___________________________________________________________________

The answer to your ??'s may be closer then you think.
Check out Tek-Tips knowledge bank by clicking the FAQ link at the top of the page
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top