Ask the Experts

Ask the Experts

• Disable SQL query optimizer tool that removes trailing blanks

  When working with the length function used in a WHERE or ORDER BY clause, disable the DB2 SQL query optimizer from removing trailing blanks by changing the variable length optimization settings.  Continue Reading

• Remove character limits from domain or users on RMTUSER

  Use the STRPCCMD command or install advanced rexec daemon to allow more characters for a domain/user on a PC network.  Continue Reading

• Generically send a text file from the IFS via FTP

  When using mget or get on iSeries, it should work. However, one user received an error message when trying to do this.  Continue Reading

• Automate Client Access to find files on Windows scheduler

  Use the RTOPCB command to transfer files from the AS/400 to the PC when automating file transfers.  Continue Reading

• Saving multiple sessions on IBM iSeries Client Access when using Vista

  When working with Vista on a PC, install service pack si27741 to solve emulation issues.  Continue Reading

• Setting ILE and C+++ compilers to runtime

  Specify the SYSIFCOPT(*NOIFSIO) or SYSIFCOPT(*IFSIO) parameters on the corresponding compile commands when using ILE c and c++ compilers.  Continue Reading

• Configuring Exchange server to allow mail forwarding from AS/400

  To forward mail from AS/400, configure the Exchange server to allow mail forwarding requests.  Continue Reading

• Remove a media with a *PERM expiration date from the inventory

  Use BRMS Media to expire and remove a *PERM backup tape from the inventory.  Continue Reading

• Enrolling a user profile in the i5/OS system distribution directory

  Use the WRKDIRE command to access the system distribution directory and enroll a user profile.  Continue Reading

• How to resolve a CPI93B8 error message: LIC problem data has been logged for #MSTRTNS

  Use WRKPRB command to determine meaning of CPI93B8 error message  Continue Reading

• Booting iSeries from internal or external sources

  A NORMAL IPL of iSeries uses the IPL Load Source disk. An alternative is to boot from a backup tape by initiating a D type IPL.  Continue Reading

• Messages and spool hanging up SAVLIB jobs when OUTPUT(*PRINT) is specified

  Override QPSAVOBJ to eliminate messages hanging up SAVLIB jobs when utilizing the OUTPUT(*PRINT) command.  Continue Reading

• Change from a Julian date to a "true" date for a search criteria index

  Use an SQL index statement or view to write a query, or change your physical file definition to convert the Julian date column into a real date column.  Continue Reading

• How to summarize an alias reference outside of SQL views and MQTs

  Apply a user-defined table function to summarize an alias reference and reference the UDTF on a SELECT statement.  Continue Reading

• Using CHGPF to change file attributes of core application files

  Manually recompiling RPG programs and AS/400 queries is necessary when using the CHGPF command to alter attributes of database files.  Continue Reading