Mar 8, 2004 #1 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,
Hi How do i write following Oracle SQL in db2 ? Oracle: select * from emp where ename is null db2 : ? Thanks,
Mar 8, 2004 1 #2 onpnt Programmer Dec 11, 2001 7,778 US 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 ___________________________________________________________________ http://www.onpnt.comThe 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 Upvote 0 Downvote
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 ___________________________________________________________________ http://www.onpnt.comThe 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
Mar 10, 2004 #3 juliane26 Technical User Mar 10, 2004 207 GB exactly the same, that's sql standard for you ... Upvote 0 Downvote