Ask the Experts

Ask the Experts

  • Accessing reorg time

    One member writes, "We have sales order file that is about 27 GB in size and contains 27 million records. The file has approximately 12 million deleted records. Is it possible to reorg that file dynamically? How can I assess the time ...  Continue Reading

  • Connecting an HP LaserJet to the iSeries

    One user writes, "I'm using a HP LaserJet 3030. I would like to use the printer to my iSeries. What's the best method to follow?" Printing and output expert Chip Milosch responds.  Continue Reading

  • Import a text file

    One user writes, " I need to 'import' a text file located in the user computer to a DB2 table in the database. What's the best way to do this?" DB2 expert Kent Milligan offers some advice.  Continue Reading

  • Setting the*CMD parameter

    I want to set the*CMD parameter in the CHGUSRAUD command for the users who have user class in *SECOFR.


    How can I write the CL?  Continue Reading

  • Variable-length fields in RPG IV

    One user writes, "Is there a way to utilize variable-length fields in RPG IV? We do not use free form yet." Application development expert John Blenkinsop responds.  Continue Reading

  • Verifying a backup is complete

     Continue Reading

  • SQL Encrypt scalar function

    One 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

  • Securing the iSeries Helpdesk

    This 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

  • Trimming blanks

    One 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

  • 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

  • Using 15,000 line RPG programs

    Ine 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

  • iSeries communication conflict

    One 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

  • Determining the speed of an Ethernet card

    One user writes, "How can I determine the speed of an Ethernet card on the iSeries?" Systems management expert Rich Belles shares his method.  Continue Reading

  • Using the Print user profile command

    This iSeries user wonders if there Is a way to generate a report/file to display users, password expiration levels and date password expires. Security expert Carol Woodbury responds.  Continue Reading

  • Saving escape characters

    One user writes, "How can I send escape characters to a network printer to change the font, orientation, etc? We currently do this with a printer interface module using "passthrough". When we try to send escape characters (hex 1B) directly to the ...  Continue Reading