• October 31, 2005 31 Oct'05

    SQL Encrypt scalar function

    One Search400.com member writes, " I just read "Column Encryption in IBM DB2 UDB for iSeries. What is the encryption algorithm used?" DB2 UDB expert Kent Milligan explains.  Continue Reading

  • October 31, 2005 31 Oct'05

    Securing the iSeries Helpdesk

    This Search400.com member is trying to secure his iSeries Helpdesk. He understands that he has a few options, but he's not sure which method would be the best. Systems management expert Scott Ingvaldson shares his thoughts.  Continue Reading

  • October 31, 2005 31 Oct'05

    Trimming blanks

    One Search400.com member writes, " How can I remove blanks when doing an FTP? If the field is "Jack," I would like to end up with "Jack" and not "Jack ". I have looked at your response for the CPYTOIMPF and do not see the option you are ...  Continue Reading

  • October 31, 2005 31 Oct'05

    Changing QCRTAUT from *CHANGE to *USE

    One user writes, "I have been asked by an auditor to change the QCRTAUT value from *Change to *Use. If I change the libraries to *USE rather than the SYSVAL, will I accomplish the same thing without having to perform an in-depth study of Appendix D...  Continue Reading

  • October 31, 2005 31 Oct'05

    Using 15,000 line RPG programs

    Ine Search400.com user writes, "I have a strange problem with a 15000 line RPG program in which all of the 99 indicators are used. I need at least one more indicator to use in the display file the program uses. I need to use that one in the display ...  Continue Reading

  • October 31, 2005 31 Oct'05

    iSeries pros respond to revenue growth

    Recently, Search400.com asked readers if they thought IBM could sustain the iSeries growth that happened over the last three quarters. While many were happy to see sales bounce back, others said Big Blue could do more. Here is a sampling of the ...  Continue Reading

  • October 30, 2005 30 Oct'05

    Quiz: Tech or treat!

    Tech or treat! Do you speak Geek? Technology is scary to a lot of people -- and no wonder, when you consider the harrowing terms and concepts involved. Here's our traditionally gruesome collection of Halloween horror for technophiles and ...  Continue Reading

  • October 26, 2005 26 Oct'05

    iSeries communication conflict

    One Search400.com member writes, "We are running V5R2 and have a PC running Microsoft DOS that controls equipment through a C program and produces an export file that we need to access. Moving to Windows is problematic. " Thankfully, iSeries ...  Continue Reading

  • October 26, 2005 26 Oct'05

    IBM finally pulls off an iSeries rebirth

    Although experts say a perfect storm of sorts has led to a rise in iSeries revenues, it's really IBM exec Mark Shearer and his team that have finally convinced data center managers to reconsider the iSeries.  Continue Reading

  • October 26, 2005 26 Oct'05

    Cleaning up unused or temporary IFS files – Part II

    In a previous tip, "Cleaning up unused or temporary IFS files -- Part 1" Ron Turull introduced you to the code for the DELIFSFILE utility. In part II, Ron discusses the code in detail, including customizing the command, things to watch out for and ...  Continue Reading