• 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

    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 22, 2006 22 Jan'06

    How to compare spooled files

    Search400.com member Phillip Smith provides his methond to compare spooled files  Continue Reading

  • January 20, 2006 20 Jan'06

    Working with the SAVSYS command

    We have an old model F35 AS/400. I have been advised to do a SAVSYS. Do I need to shut down the sub-systems prior to doing save system?  Continue Reading

  • January 20, 2006 20 Jan'06

    What is a Decimal Data Error?

    One Search400.com member writes, "Can you please tell me what a Decimal Data error is, and what is the scenario in which it is received?" Search400.com's application development expert John Blenkinsop explains.  Continue Reading

  • January 19, 2006 19 Jan'06

    Problems with print screen function on iSeries CA since upgrade

    One Search400.com user writes, "I am having an issue using the print screen function on iSeries Client Access since we upgraded it to 5.7." iSeries printing/output expert Chip Milosch offers some advice.  Continue Reading

  • January 19, 2006 19 Jan'06

    Finding users with passwords the same as the profile

    One Search400.com member writes, "We have eight iSeries systems, with the same user ID's on them, plus our clients user ID's. We need to check to see if user profiles are EQ to user passwords. Would IBM API's QSYRUPWD and qsycupwd be used for this...  Continue Reading

  • January 19, 2006 19 Jan'06

    Print a PDF file from the iSeries

    One user writes, "I'm having trouble with embedded spaces with the STRPCCMD command. The following works when I type it into the Windows start, run box: "C:Program FilesAdobeAcrobat 6.0acrobat.exe /p M:Blueprintssample.pdf" Thanksfully, Shahar Mor...  Continue Reading

  • January 19, 2006 19 Jan'06

    Command to manage longer addresses

    One user wirtes, "I am working with an iSeries application that uses the commands: strpccmd/strpco to redirect the user to a Web page on a local server. I would like the application to redirect to a different Web page but the address is too long ...  Continue Reading

  • January 19, 2006 19 Jan'06

    CPF3291 error on a rstlib command

    On a rstlib command (from a sav lib created tape) I get a CPF3291 error when the restore is to a second library (development restore of production data). All of the data and logical files are contained in the same directory, though the logicals ...  Continue Reading

  • January 12, 2006 12 Jan'06

    Convert iSeries output into a PDF

    One Search400.com member writes, "Please recommend the best way to convert iSeries output into a PDF and then e-mail it to recipients. The programs generating the output are written in COBOL. We are licensed for Infoprint Server." Printing/output ...  Continue Reading

  • January 09, 2006 09 Jan'06

    New Years resolutions -- January 2006

    Now entering 2006, what are you going to do to be LAZY for another year! Well --first off -- let's go over resolutions for the New Year! Now don't worry – you can keep eating those doughnuts – (well I can't but that's another story!)  Continue Reading

  • January 07, 2006 07 Jan'06

    The Programmer's Guide to iSeries Navigator -- Chapter 4

    Enjoy a complimentary copy of Chapter 4 of "The Programmer's Guide to iSeries Navigator" written by Paul Touhy and published by MC Press.  Continue Reading

  • January 04, 2006 04 Jan'06

    New products and updates for the iSeries

    New iSeries software: I/O Concepts adds iSeries support for management tools; NetManage tweaks iSeries SOA product; and Outbound calling assistance from iMessaging Systems.  Continue Reading

  • January 03, 2006 03 Jan'06

    A second look at sending messages from your iSeries via SMTP

    I've recently seen a lot of tips on "Sending messages from your iSeries via SMTP." While all of these tips are valid, to me they contain one vital flaw. They all require your iSeries to be running the SMTP server daemon. While this might be OK for...  Continue Reading