• 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

  • January 23, 2006 23 Jan'06

    Keeping programmers honest -- part 1

    If you are like most iSeries security officers, you probably cut your teeth in the IT field by doing some programming. It might even be that you still get involved in programming and your role as security officer is a part-time role. So, you have ...  Continue Reading