More V5R3 SQL Enhancements
July 14, 2004 Michael Sansoterra
My last article briefly covered the new Binary and Varbinary data types, some new scalar functions, and the sequence object that is new to the iSeries implementation of DB2. The good news is there are more SQL enhancements to cover!
DISCLAIMER
Once again, since I don’t yet have access to a machine with V5R3, this information was gleaned from the new V5R3 manuals and may be subject to revision! I’d love to hear from someone who has a beta of V5R3 who can offer more insight on these features.
NAMED COLUMN JOIN
A new shorthand join syntax called a “named