• 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

  • IBM Tweaks Some Power Systems Prices Down, Others Up
  • Disaster Recovery: From OS/400 V5R3 To IBM i 7.4 In 36 Hours
  • The Disconnect In Modernization Planning And Execution
  • Superior Support: One Of The Reasons You Pay The Power Systems Premium
  • IBM i PTF Guide, Volume 25, Number 13
  • IBM i Has a Future ‘If Kept Up To Date,’ IDC Says
  • When You Need Us, We Are Ready To Do Grunt Work
  • Generative AI: Coming to an ERP Near You
  • Four Hundred Monitor, March 22
  • IBM i PTF Guide, Volume 25, Number 12

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 © 2023 IT Jungle