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

Using Member Filters in Remote Systems Explorer

July 14, 2004 Hey, Ted

Thanks for publishing my filtering tip in Four Hundred Guru. I hope it helps people who are learning to use the LPEX editor. WebSphere Development Studio client’s Remote Systems view includes yet more filtering capabilities that put PDM to shame.

You can press F17 from one of the WRKxxxPDM screens to get a panel that allows you to subset the list of libraries, objects, or members. You can key a simple name or a generic name, with a leading asterisk, a trailing asterisk, or both, to restrict the list of names. RSE includes a similar option, with

Admin Alert: Decommissioning Group Profiles

July 14, 2004 Joe Hertvik

Group profiles are a great feature in any operating system, especially OS/400. By creating a group profile, you can authorize one user profile to a number of programs or files and then have other users “inherit” those authorizations by assigning them as members of that group profile. Group profiles centralize security by limiting access to the lowest possible number of users (one), while retaining the flexibility to have any number of users access those security settings.

But there are times when a group profile can outlive its usefulness, such as when you want to retain a group profile’s capabilities as