Operating System/400, 5769-SS1 477
Operating System/400, 5769-SS1
directly into an Excel spreadsheet. Specified records or fields of records can also be selected
and transferred. Wizards are provided so users can create, modify, and run transfer requests,
then save them for later use. Batch transfers are also supported (via the RTOPCB and
RFROMPCB commands). The following options are available only in the Express client:
• Users no longer need to set up a system connection through a Client Access
connection program because the system name or TCP/IP address can be entered
directly into the Data Transfer GUI.
• The Data Transfer GUI supports an “auto-run” option. This enables a user to create a
transfer request, and perhaps put an icon on the desktop for this request, then simply
double-click the icon, and the transfer is “auto-run” without additional user
intervention. This transfer can also be placed in a startup session.
• For PC file upload requests, a wizard (on the toolbar icon and on the Data Transfer
Tools menu) can be used to: Interrogate the PC file layout, Present the user with a
recommended AS/400 file layout (that the user can modify), and Create the new
AS/400 database file definition to receive the uploaded file. Previously, users had to
determine and create the AS/400 database file definitions on the AS/400 system
before using Data Transfer.
• Database information can be inserted directly into a section of an existing HTML file.
This enables a user who has a Web page of text containing a section with database
data to “update” the data while leaving the rest of the Web page text intact. Previously,
the entire HTML file was replaced with a table containing the database data.
• Lotus 123.WK4 file formats are supported.
• Row sizes up to 32K are supported. Previously the limit was 4K.
• The ability to control truncation of trailing spaces when transferring ASCII text files is
provided. Previously, Data Transfer truncated automatically trailing spaces
• Support for new AS/400 DATALINK commands for linking to HTML tables is available.
• New transfer profile types (.DTF and .DTT) have been created that are .INI-file based
and easier to use and service. The previous file types (.TTO, .TFR, .DT, and .RTO) are
also supported.
• Other usability enhancements (such as ability to sort field details, adding various
check boxes to Data Transfer GUI) and performance improvements (most noticeably
when transferring CSV or BIFF5 files) are also provided.
Central Administration of PC Users
Client Access Express was designed with administration in mind. AS/400 administrators want
to make PC installation easier, control which functions users may install, control which
functions users may run, and be able to pre-configure Client Access connections so unskilled