DB2 9 for z/OS: Packages Revisited

Readers' comments

Readers' comments (2) 

lockedThis discussion is now locked


Posted by Chiali Tsai on 2 September 2010 at 9:26


Page 55 of DB2 9 for z/OS: Packages Revisited

Example 4-7
SELECT DISTINCT DBRM1.PLNAME,DBRM1.NAME
FROM SYSIBM.SYSDBRM A,SYSIBM.SYSDBRM B
WHERE (DBRM1.NAME = DBRM2.NAME
AND DBRM1.PLNAME <>DBRM2.PLNAME)

syntax on second line
FROM SYSIBM.SYSDBRM A,SYSIBM.SYSDBRM B
A should be DBRM1
B should be DBRM2

Posted by Mr. Paolo Bruni on 2 August 2012 at 16:54

Thanks, correction applied as of today. Paolo


Profile

Publish Date
02 March 2009

Last Update
03 August 2012


Rating:
(based on 7 reviews)


Author(s)

ISBN-10
0738432369

IBM Form Number
SG24-7688-00