• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • 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

    …

    Read more
  • 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

    …

    Read more
  • 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

    …

    Read more

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • Public Preview For Watson Code Assistant for i Available Soon
  • COMMON Youth Movement Continues at POWERUp 2025
  • IBM Preserves Memory Investments Across Power10 And Power11
  • Eradani Uses AI For New EDI And API Service
  • Picking Apart IBM’s $150 Billion In US Manufacturing And R&D
  • FAX/400 And CICS For i Are Dead. What Will IBM Kill Next?
  • Fresche Overhauls X-Analysis With Web UI, AI Smarts
  • Is It Time To Add The Rust Programming Language To IBM i?
  • Is IBM Going To Raise Prices On Power10 Expert Care?
  • IBM i PTF Guide, Volume 27, Number 20

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2025 IT Jungle