• January 31, 2006 31 Jan'06

    iSeries upgrades embrace Windows

    As part of a major revamp of the iSeries -- which includes a name change to the System i5 -- IBM is making it easier to integrate the iSeries platform with Windows. A smart move by Big Blue, say analysts, suggesting that anything that brings the ...  Continue Reading

  • January 30, 2006 30 Jan'06

    IBM names new iSeries marketing VP

    IBM taps its SMB chief Elaine Lennox to replace Peter Bingaman. The leadership change comes at crucial juncture, but execs voice confidence.  Continue Reading

  • January 30, 2006 30 Jan'06

    Preparing for an iSeries upgrade

    This guide describes how to prepare for an iSeries upgrade. Whether you're upgrading from V4R2 to V4R5 or to V5R4, the information in this guide may be useful to help you avoid some common upgrade-related issues.  Continue Reading

  • January 30, 2006 30 Jan'06

    Open-list API provides crucial information on activation groups -- part 2

    One of the many Open List APIs gives programs the ability to determine which activation groups are active in the job and allows the program to retrieve the activation groups' attributes. It can also provide the same information on activation...  Continue Reading

  • January 27, 2006 27 Jan'06

    Profile without ALLOBJ authority to view joblog

    One Search400.com member asks, "We have the need to allow a support profile that does not have *ALLOBJ authority to view a production user profile's joblog. We have found the way to address this via Skyview/Ops Navigator/Host Applications/Customize...  Continue Reading

  • January 27, 2006 27 Jan'06

    Answer and delete in the QSYSOPR message queue

    One Search400.com member writes, "What controls a user's ability to be allowed to answer and (especially) delete messages in the QSYSOPR message queue? How can we restrict them?" Security expert Carol Woodbury explains.  Continue Reading

  • January 27, 2006 27 Jan'06

    Retrieve SQL (RTVSQL) source statement

    Search400.com member Jean-Paul Lamontre discusses the SQL Visual Explain tool, which comes with iSeries Navigator. Jean-Paul finds this tool very handy to improve the performance of SQL statements. In this tip he shares why he feels it would be ...  Continue Reading

  • January 25, 2006 25 Jan'06

    iSeries marketing exec resigns

    Peter Bingaman, marketing vice president for the iSeries, resigned from his position last week. Hailed as a marketing hero, Bingaman had been instrumental in the iSeries' marketing makeover.  Continue Reading

  • January 25, 2006 25 Jan'06

    Working with ODBC and dates

    One Search400.com member writes, "I use Business Objects and Viewpoint to access DB2/400 via ODBC. Since the new year some PTF's were applied (I don't know which ones) and now any SQL that converts strings to dates fails. The iSeries is managed ...  Continue Reading

  • January 25, 2006 25 Jan'06

    Run command on a PC

    One Search400.com member writes, "I want to start a .Wav file from my iSeries. It works with the STRPCCMD but the length of the parameter is limited to 123, which is too small. Are there any alternatives?" PC/Windows connectivity expert Shahar Mor ...  Continue Reading