Ask the Experts

Ask the Experts

• How to FTP an IFS file on AS/400

  ISeries PC/Windows connectivity expert Shahar Mor discusses how to FTP an IFS file to another system.  Continue Reading

• Monitoring logins over TCP/IP using FTP

  ISeries PC/Windows connectivity expert explains how to set FTP exit programs to monitor user activity.  Continue Reading

• An FTP script to get a file from a PC to AS/400

  ISeries PC/Windows connectivity expert Shahar Mor gives an example of an FTP script that will move a file from a PC to AS/400.  Continue Reading

• Using a Windows FTP server to pull data from an IFS directory

  ISeries PC/Windows connectivity expert Shahar Mor explains how to use a naming format to pull data from an IFS directory.  Continue Reading

• Viewing the job log of an *ALLOBJ user

  ISeries security expert Carol Woodbury explains how a non-*ALLOBJ user can view the job log of a user with *ALLOBJ access.  Continue Reading

• BRMS backup jobs: Clearing expired save files

  ISeries backup and recovery expert Ken Graap explains how a user can clear expired save files during BRMS backup jobs.  Continue Reading

• Shrinking the BRMS backup window

  ISeries backup and recovery expert Ken Graap discusses how to cut the time it takes to complete a BRMS backup.  Continue Reading

• Completing an unattended Option 21 save to tape

  ISeries backup and recovery expert Ken Graap explains how to do an unattended Option 21 save to tape.  Continue Reading

• Executing a CL command on AS/400

  ISeries backup and recovery expert Ken Graap explains how to use FTP, the QUOTE command and the RCMD command to execute a CL command on AS/400.  Continue Reading

• Removing *ALLOBJ access and raising system security levels

  ISeries security expert Carol Woodbury explains how to smoothly transition to a higher system security level.  Continue Reading

• SQL Server Database and Java

  DB2/400 and DB2 UDB expert Kent Milligan explains how to access SQL Server Database with Java.  Continue Reading

• Identifying large Integrated File System files

  ISeries backup and recovery expert Ken Graap discusses how to find large files in the integrated file system (IFS).  Continue Reading

• Dynamic SQL statement in an RPG program

  DB2/400 and DB2 UDB expert Kent Milligan discusses how to substring a character field on an SQL join statement.  Continue Reading

• Risk associated with *ALLOBJ access in iSeries

  ISeries security expert Carol Woodbury discusses the risks associated with granting users *ALLOBJ access.  Continue Reading

• Group and object authority with level 20 security

  ISeries security expert Carol Woodbury discusses group and object authority on security level 20.  Continue Reading