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

    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 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 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

-ADS BY GOOGLE

SearchDataCenter

Close