Ask the Experts

Ask the Experts

  • SOX regulations concerning applications

    One user writes, "Are there special requirements in the SOX laws that are related to the need of technical documentation on the applications?" Security expert Carol Woodbury responds.  Continue Reading

  • Open ports for ODBC

    One user writes, "We had a power failure in the morning when there was no one was on site. The iSeries shut down and then IPL'd when the power was restored. When the offices opened for business, the users were unable to do any ODBC functions. The ...  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

  • 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

  • Accessing reorg time

    One Search400.com 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

  • Verifying a backup is complete

     Continue Reading

  • 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

  • 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

  • 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

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

  • 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

  • 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

  • Determining the speed of an Ethernet card

    One Search400.com 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

  • 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

-ADS BY GOOGLE

SearchDataCenter

Close