Nlynx ETU400 Uživatelský manuál

iETU400User GuideAS/400 File Transfer Utility

ETU400 User Guide 011603 iii5-1 Transferring Files 36-1 Translating Files 37-1 Working with PC Functions 38-1 Modifying Translation Tables 39-1 Advan

ETU400 User Guide 011603 8-6Table 8-2 Translate Table Source Record FormatPosition inthe RecordFunctions (Record Fields)1-18 FROM HEX (or special fun

ETU400 User Guide 011603 8-7For example, the table above indicates that a translation table cancontain a maximum of 20 “From” entries with a string l

ETU400 User Guide 011603 8-8End-of-File ActionThis is identical to end-of-record action with one exception. Thisfunction also completes translation a

ETU400 User Guide 011603 8-9Sample Translation TableThe following is an example of an ASCII-to-EBCDIC translation table. Fora complete listing, see m

ETU400 User Guide 011603 8-10Compiling the New Translation MemberAfter you create or modify a new translation source file member usingSEU, you must c

ETU400 User Guide 011603 9-1Chapter 9 ADVANCED ETU FEATURESAbout This ChapterMultiple-device TransferTransferring From Multiple Micros Using PWRTO

ETU400 User Guide 011603 9-2About This ChapterMost ETU commands allow you to transfer a file interactively between thehost and a micro. This chapter

ETU400 User Guide 011603 9-3Multiple-device TransferMultiple-device file transfer is a feature supported by all ETU powercommands. Using multiple-dev

ETU400 User Guide 011603 9-4signed on.Each device you transfer from must be powered on,have emulation loaded, and be at the AS/400 sign-on screen.NOT

ETU400 User Guide 011603 9-5Using PWRTO3XBIn order to send files from multiple micros to the same host libraryusing PWRTO3XB with the TOFILE(*MULTI)

ETU400 User Guide 011603 ivRENAMEB Example 7-3Figure 7-1 The RENAMEB prompt screen 7-3Allocate a Micro File: 7-4The ALOCATB Command 7-4ALOCATB Exampl

ETU400 User Guide 011603 9-6Transferring a Host File to Multiple MicrosThe PWRFROM3XB command allows you to transfer a single host file to up toten m

ETU400 User Guide 011603 9-7Micro-to-micro TransfersIn addition to allowing file transfers between a micro and a host, ETUallows you to transfer file

ETU400 User Guide 011603 9-8The parameters used with PCFROMPC multiple-device transfer are describedbelow:Qualified file name The name of the file t

ETU400 User Guide 011603 9-9The PCTOPC CommandTo transfer a single file from one micro to multiple micros, specify thename of the file, the device na

ETU400 User Guide 011603 9-10Transferring Files Between Multiple MacesIf you are transferring files between your Mac and the host, or you aretransfer

ETU400 User Guide 011603 9-11Figure 9-1 Transferring Files With InterAxcess on the Root Level of theHard DriveIf InterAxcess is one or more folders d

ETU400 User Guide 011603 9-12Figure 9-2 Transferring Files With InterAxcess Several Levels DeepRecord and Field SelectionRecord selection and field s

ETU400 User Guide 011603 9-13Field name The name of the field you want to transfer. Youmay transfer up to 25 fields.Key field Specifies whether th

ETU400 User Guide 011603 9-14Field Selection -- Example 1Suppose there is a file on your host computer that contains informationabout the employees i

ETU400 User Guide 011603 9-15Field Selection -- Example 2In this example, you will see how you can use more than one key fieldwhen transferring selec

ETU400 User Guide 011603 vSaving Request Definitions 9-20Re-using Request Definitions 9-20Performing Batch Transfers 9-22Batch Transfer – Example 9-2

ETU400 User Guide 011603 9-16Transferring Selected RecordsETU allows you to transfer selected records from a host file to a file ona micro. You selec

ETU400 User Guide 011603 9-17Record Selection -- Example1Suppose you want to transfer the employee file (described in the previoussection) from the h

ETU400 User Guide 011603 9-18Entry and Exit ProgramsWith the PWRFROM3XB and PWRTO3XB commands, you can run any user-definedprograms before and/or aft

ETU400 User Guide 011603 9-19Deleting Files After TransferThe commands PWRFROM3XB and PWRTO3XB allow users to delete filesafter the files have been t

ETU400 User Guide 011603 9-20Saving Request DefinitionsSome ETU commands allow you to save the definition of the currentrequest. The request definiti

ETU400 User Guide 011603 9-211 Execute Interactively runs the command using the saved definition.2 Submit to batch Prompts for the job descript

ETU400 User Guide 011603 9-22Performing Batch TransfersThe ETU transfer commands featured in this chapter (PWRFROM3XB, PWRTO3XB,PCFROMPC, PCTOPC, ) c

ETU400 User Guide 011603 9-23After you supply the above information and press ENTER, youare prompted with the command name you specified in theSBMCMD

ETU400 User Guide 011603 9-24Time and Date SchedulingThe ETU Time and Date Scheduling utility allows you to submit a job tobatch and specify a time i

ETU400 User Guide 011603 9-25Time and Date Scheduling – ExampleSuppose you want to transfer a file to a PC from the host using thePWRFROM3XB command.

ETU400 User Guide 011603 viTESTB Command 10-47TO3XB Command 10-48VWSAVRQS Command 10-52VWSAVRQS Notes 10-52XLATEFROM Command 10-54XLATETO Command 10-

ETU400 User Guide 011603 9-26Part Three Command Reference“Command Reference” is an alphabetical presentation of al AS/400 nativemode ETU commands and

ETU400 User Guide 011603 10-1Chapter 10 ETU COMMAND REFERENCEALOCATB CommandDELETEB CommandEDITTABLE CommandEDTUDF Command - EDTUDF NotesFROM3XB Comm

ETU400 User Guide 011603 10-2ALOCATB CommandParameter description Parameter name Parameter valuesQualified file name QFNAME micro file nameDisplay st

ETU400 User Guide 011603 10-3DELETEB CommandParameter description Parameter name Parameter valuesQualified file name QFNAME micro file nameNotify Ope

ETU400 User Guide 011603 10-4EDITTABLE CommandParameter description Parameter name Parameter valuesSource member SRCMBR ETOA2 ETOA3 ATOE1 ATOE3 ETOA1

ETU400 User Guide 011603 10-5Mac Users: If you use the TRANSFILE default (TRANSLATE), the membernames will have an M on the end of the name (for exam

ETU400 User Guide 011603 10-6EDTUDF CommandThe EDTUDF command allows you to add user-defined options to the ETU Mainmenu (WSMENUS). Any valid AS/400

ETU400 User Guide 011603 10-7EDTUDF NotesUp to ten user-defined functions can be added to the ETU menu. The firsttime you start the EDTUDF utility (w

ETU400 User Guide 011603 10-8FROM3XB CommandParameter description Parameter name Parameter valuesFile name FRMFILE host file nametranslation table m

ETU400 User Guide 011603 10-9*LAST Transfers the last member arrival sequence in thefile.*ALL Transfers all members from the FRMFILE file intoone m

ETU400 User Guide 011603 viiCreating DDS Specifications C-3APPENDIX D D-1CREATING F&I SPECIFICATIONS D-1About This Appendix D-2Creating F & I

ETU400 User Guide 011603 10-10Library The library containing the source for the translation tables.*LIBL is the default. TRANSMBR The TRANSFILE mem

ETU400 User Guide 011603 10-11DSPSTSMSG Displays program status messages during the execution of thecommand. The default is *YES. To turn the messa

ETU400 User Guide 011603 10-12PCFROMPC CommandParameter description Parameter name Parameter valuesQualified file name QFNAME micro file nameTransfer

ETU400 User Guide 011603 10-13MICLST2 The device name of the target micro. The default, *REQUESTER,transfers multiple files to the micro from which

ETU400 User Guide 011603 10-14PCTOPC CommandParameter description Parameter name Parameter valuesQualified file name QFNAME micro file nameTransfer f

ETU400 User Guide 011603 10-15DSPSTSMSG Displays program status messages during the execution of thecommand. The default is *YES. To turn the messag

ETU400 User Guide 011603 10-16PGMFROM3XB CommandParameter description Parameter name Parameter valuesQualified file name QFNAME micro file nameProgra

ETU400 User Guide 011603 10-17PGMTO3XB CommandParameter description Parameter name Parameter valuesQualified file name QFNAME micro file nameProgram

ETU400 User Guide 011603 10-18PRTFROM3X CommandParameter description Parameter name Parameter valuesOutput Queue OUTQ output queue name Library n

ETU400 User Guide 011603 10-19Figure 10-1 The PRTFROM3X Translate prompt screenTranslate spool file to PC: (TRANSLATE)

ETU400 User Guide 011603 viiiFILEFRPC Procedure G-10FILETOPC Procedure G-13LIBRFRPC Procedure G-15LIBRTOPC Procedure G-18PRNTFRPC Procedure G-21PRNTT

ETU400 User Guide 011603 10-20PRTTO3X CommandParameter description Parameter name Parameter valuesQualified file name QFNAME micro file nameOutput qu

ETU400 User Guide 011603 10-21OVERFLOW The overflow line on the new print job being added to theAS/400 print queue. The default is 63.FORMTYPE The

ETU400 User Guide 011603 10-22PRTXFRMPC CommandParameter description Parameter name Parameter valuesPC data file FILE Host file name Library name

ETU400 User Guide 011603 10-23LPI The number of lines per inch to allocate to the new print jobbeing added to the AS/400 print queue. The default is

ETU400 User Guide 011603 10-24PRTXTOPC CommandParameter description Parameter name Parameter valuesPC data file PCDATA Host file name Library nam

ETU400 User Guide 011603 10-25ACTION Specifies the action the program is to perform.*COPYPRT Use *COPYPRT it the data is resident on the printqueue.

ETU400 User Guide 011603 10-26current task. The specified value must be in the range of 1to 198. The default value is 1 (one).TO The column of the p

ETU400 User Guide 011603 10-27PWRDELETEB CommandParameter description Parameter name Parameter valuesQualified file name QFNAME micro file nameProces

ETU400 User Guide 011603 10-28PWRFROM3XB CommandParameter description Parameter name Parameter valuesFile name FRMFILE host file nametranslation tab

ETU400 User Guide 011603 10-29Comparison value numeric value or‘alphabetic value’Entry program ENTRYPGM program name Library name *LIBLlibrary n

0Part One Getting Started“Getting Started” is intended for all users of ETU. It describes how toinstall and how to use ETU. If you are new to ETU, you

ETU400 User Guide 011603 10-30QFNAME1 The name of the micro file to contain the data from theAS/400. For additional information, see About Microcomp

ETU400 User Guide 011603 10-31SAVRQS Saves the current request definition so it can be reused at alater time. The request definition is this complet

ETU400 User Guide 011603 10-32Length May be from 1 to 9989 bytes long.If an ASCII fixed-record-length translation is to beperformed, specify *FILE t

ETU400 User Guide 011603 10-33all records in the file. The other relationshipsare *AND, *OR, *ANDIF, *ORIF and are used insituations where more than

ETU400 User Guide 011603 10-34PWRRENAMEB CommandParameter description Parameter name Parameter valuesQualified file name QFNAME1 micro file nameNew f

ETU400 User Guide 011603 10-35PWRTO3XB CommandParameter description Parameter name Parameter valuesQualified file name QFNAME1 micro file nameTransfe

ETU400 User Guide 011603 10-36The PWRTO3XB command performs all the functions of the TO3XB command: ittransfers files to the AS/400 from a micro and,

ETU400 User Guide 011603 10-37from which it was transferred.*MULTI Transfers the files into multiple host files.Data Description Specifications (DDS

ETU400 User Guide 011603 10-38currently exists on the micro.ADDRPL For transfers to existing files: indicates whether thetransferred file will repla

ETU400 User Guide 011603 10-39*YES The data is truncated, if necessary.To truncate indicates that once the current host record isfilled, any additio

1-1Chapter 1 INTRODUCTION Welcome to ETUWhat ETU Can Do For YouInventory ChecklistSecurity ConsiderationsHardware and Software RequirementsHardware Re

ETU400 User Guide 011603 10-40same name as the source file.ENTRYPGM The name of any user-specified entry program to be run priorto transferring the

ETU400 User Guide 011603 10-41RENAMEB CommandParameter description Parameter name Parameter valuesQualified file name QFNAME1 micro file nameNew file

ETU400 User Guide 011603 10-42SBMBATXFER CommandParameter description Parameter name Parameter valuesCommand name to submit SBMCMDNAME ETU command na

ETU400 User Guide 011603 10-43SBMSCHJOB CommandParameter description Parameter name Parameter valuesCommand SBMCMD command name?Hour in 24 hour clock

ETU400 User Guide 011603 10-44To Schedule a JobTo schedule a job, first start a job called SCHPGM. This job controls theSBMSCHJOB command. Then enter

ETU400 User Guide 011603 10-45STRSEU CommandParameter description Parameter name Parameter valuesSource file SRCFIlE TRANSSRC*PRVfile name Libra

ETU400 User Guide 011603 10-46TYPE The type of source to be edited or created. Specify anycombination up to 10 characters, or one of the AS/400 type

ETU400 User Guide 011603 10-47TESTB CommandParameter description Parameter name Parameter valuesQualified file name QFNAME micro file nameNotify oper

ETU400 User Guide 011603 10-48TO3XB CommandParameter description Parameter name Parameter valuesFile name TOFILE host file name*MULTI Librar

ETU400 User Guide 011603 10-49name if the file is to be created with the TO3XBcommand.MBR The TOFILE member name. If the member already exists, it w

ETU400 User Guide 011603 1-2Welcome to ETUETU is a host software package that allows you to transfer files betweenan IBM AS/400 host computer and one

ETU400 User Guide 011603 10-50TRANSLATE Determines whether the data is to be translated, and if so,what type of translation is to be performed.*TEXT

ETU400 User Guide 011603 10-51Use the default, *NONE, or its equivalent, *DDS, for existinghost files.FLDDEFMBR The member contained in the FLDDEFFI

ETU400 User Guide 011603 10-52VWSAVRQS CommandThe VWSAVRQS command displays the request definitions saved with theFROM3XB, PWRFROM3XB, PWRTO3XB, PCTO

ETU400 User Guide 011603 10-53

ETU400 User Guide 011603 10-54XLATEFROM CommandParameter description Parameter name Parameter valuesPC data file name PCDATA PC data file on the host

ETU400 User Guide 011603 10-55Library The library containing the PCDATA file. *LIBL is thedefault.PCMBR The PCDATA file member name. The default is

ETU400 User Guide 011603 10-56TRANSFILE The qualified file name of the translate table file to beused. The default is TRANSLATE.Library The library

ETU400 User Guide 011603 10-57*FIRST Transfers the first member (arrival sequence)inthe file.*LAST Transfers the last member (arrival sequence)inth

ETU400 User Guide 011603 10-58The XLATETO command translates an AS/400 physical file member prior totransferring it to a micro. It is intended for us

ETU400 User Guide 011603 10-59*BASICS Converts the file to BASIC Sequential format.*TAB Converts the file to BASIC Sequential format withtab charac

ETU400 User Guide 011603 1-3Inventory Checklist In addition to this manual, the following items are included in your ETUpackage: 9 One of the follow

ETU400 User Guide 011603 10-60FLDDEFMBR The FLDDEFFILE member name. You can enter themember name or one of the following values:*FILE - Transfers th

ETU400 User Guide 011603 10-61Part Four AppendicesThe “Appendices” provide reference and supplemental information. A-1 Inside ETUB-1 ETU Compatibilit

ETU400 User Guide 011603 A-1Appendix A INSIDE ETUAbout This ChapterEditing User-defined Menu OptionsEDTUDF ParametersEDTUDF ExampleConfiguring the Au

ETU400 User Guide 011603 A-2About This ChapterETU includes utilities that allow you to customize the way ETU works onyour AS/400. This chapter descri

ETU400 User Guide 011603 A-3Editing User-defined Menu OptionsWith ETU it's possible to add menu options, called user-definedfunctions, to the ET

ETU400 User Guide 011603 A-4EDTUDF ParametersDescription The description of the user-defined function as it willappear on the ETU Main menu. It may

ETU400 User Guide 011603 A-5EDTUDF ExampleIn this example, you will add the ETU utility EDTUDF to the ETU Mainmenu. Define the menu option so that yo

ETU400 User Guide 011603 A-6Configuring the Audit TrailAn audit trail is produced for the ETU commands FROM3XB, PCFROMPC,PCTOPC, PWRFROM3XB, PWRTO3XB

ETU400 User Guide 011603 A-7The CFGAUDIT ParametersCRTAUDIT Turns the audit trail on or off. The default, *YES, createsan audit trail for all users

ETU400 User Guide 011603 A-8Checking the Audit TrailAll ETU transfer operations performed with the above-named ETU commandscreate entries in the audi

ETU400 User Guide 011603 iiSOFTWARE LICENSE AGREEMENTNOTICE=======YOU SHOULD CAREFULLY READ THE FOLLOWING TERMS AND CONDITIONS BEFOREOPENING THIS PAC

ETU400 User Guide 011603 1-4Hardware and Software RequirementsThe host and microcomputer hardware and software required by ETU aredescribed below. Ha

ETU400 User Guide 011603 A-9Working with ETU SecurityFor the Security Officer: The ETU menuing system takes advantage of thesecurity provided with th

ETU400 User Guide 011603 A-10Revoking Authority From a CommandWhen you revoke authority to a command, the users from whom the commandis revoked will

ETU400 User Guide 011603 A-11Securing Devices on the AS/400For the Security Officer: The ETU power commands allow a properlyauthorized user to transf

ETU400 User Guide 011603 A-12Removing ETU From the AS/400ETU includes a utility that makes it easy to remove the ETU software fromyour host system. (

ETU400 User Guide 011603 B-1Appendix B ETU COMPATIBILITYAbout this AppendixUsing ETU with Autokey Batch FilesModifying an Autokey Batch File – Exampl

ETU400 User Guide 011603 B-2About This AppendixETU 5.01 supports all the command functions of earlier versions of ETU.However, the menus for ETU 5.01

ETU400 User Guide 011603 B-3Using ETU 5.01 and above with Autokey Batch FilesThe menu for ETU 5.01 and above changed from earlier versions. Some menu

ETU400 User Guide 011603 C-1Appendix C CREATING DDS SPECIFICATIONSAbout This AppendixCreating DDS Specifications

ETU400 User Guide 011603 C-2About This AppendixThis appendix explains how to define AS/400 files using Data DescriptionSpecifications (DDS specs). DD

ETU400 User Guide 011603 C-3Creating DDS SpecificationsIn order to transfer field-oriented data, like that found in spreadsheetsor databases, you mus

ETU400 User Guide 011603 1-5Features of Version 5.02This version of ETU has several new features that didn't exist in Version5.01 (or earlier),

ETU400 User Guide 011603 C-4To create a DDS specs for a file, use the PDM (Programming DevelopmentManager) utility on the AS/400. The steps below and

ETU400 User Guide 011603 C-53. The Select Members screen, shown in Figure C-3, appears. Type therequired data in each prompt as explained in the foll

ETU400 User Guide 011603 C-64. The Work With Members screen, shown in Figure C-4, appears. Press F6to create the member.Figure C-4 The Work With Mem

ETU400 User Guide 011603 C-75. The Start Source Entry Utility (SEU) screen, shown in Figure C-5,appears. Type SAMPLE in the Source member prompt, an

ETU400 User Guide 011603 C-86. The Edit screen, shown in Figure C-6, appears. Press F4 for prompts tobegin entering data. Figure C-6 The SEU Edit sc

ETU400 User Guide 011603 C-97. To create the DDS, enter the letter R in the Name Type field andRECORD in the Name prompt as shown in Figure C-7, and

ETU400 User Guide 011603 C-108. The DDS Edit screen, shown in Figure C-8, appears. Position the cursorin column 1 of line 0001.00, then type the let

ETU400 User Guide 011603 C-119. The 0001.00 edit screen, shown in Figure C-9, appears. Type therequired data in each prompt as explained in the foll

ETU400 User Guide 011603 C-1210. The 0002.00 edit screen, shown in Figure C-10, appears. Type therequired data in each prompt as explained in the fol

ETU400 User Guide 011603 C-1311. The 0003.00 edit screen, shown in Figure C-11, appears. Type therequired data in each prompt as explained in the fo

ETU400 User Guide 011603 1-6Features of Version 5.041ETU 400 RISC Version 5.041 represents an incremental maintenance release.We have modified the in

ETU400 User Guide 011603 C-1412. The 0004.00 edit screen, shown in Figure C-12, appears. Type therequired data in each prompt as explained in the fol

ETU400 User Guide 011603 C-1513. The Edit screen, shown in Figure C-13, appears. When you have definedeach field, press F3 to exit the SEU. The DDS f

ETU400 User Guide 011603 C-1614. The Exit screen, shown in Figure C-14, appears. Enter a text comment,if desired, and then press ENTER.A text comment

ETU400 User Guide 011603 C-1715. The PDM screen, shown in Figure C-15, appears. Press F3 to exit to theAS/400 main menu.The demonstration file is now

ETU400 User Guide 011603 D-1Appendix D CREATING F&I SPECIFICATIONSAbout This AppendixCreating DDS Specifications

ETU400 User Guide 011603 D-2About This AppendixOn the AS/400, files can be defined with Data Definition Specifications(DDS) or Format and Input speci

ETU400 User Guide 011603 D-3Creating F & I SpecificationsIn order to transfer tabular data, like that found in spreadsheets ordata bases, you mus

ETU400 User Guide 011603 D-4To create an F&I specification for a file, use the Source Entry Utility(SEU) on the AS/400. The steps below and on th

ETU400 User Guide 011603 D-54. When the SEU Edit screen appears (see Figure D-3), press F4 to displaya data area prompt in which to enter the file s

ETU400 User Guide 011603 D-6Column 15 is the File Type and must contain the letter I, which definesthe file as an input file.Column 16 is the File De

ETU400 User Guide 011603 1-7Features of Version 5.5 Version 5.5 and the changes to it are as follows:This version has been created to remove the need

ETU400 User Guide 011603 D-7

ETU400 User Guide 011603 D-87. Display the next statement number by typing I1 over the first twopositions of the line containing statement 0002.00 a

ETU400 User Guide 011603 D-9Use columns 48 through 51 to enter the ending position of the Name field.This field ends in position 17.Use columns 53 th

ETU400 User Guide 011603 D-109. Display the next statement number by typing I1 over the first twopositions of the line containing statement 0003.00

ETU400 User Guide 011603 D-11Use columns 48 through 51 to enter the ending position of the Job Titlefield. This field ends in position 52.Use columns

ETU400 User Guide 011603 D-1211. Display the next statement number by typing I1 over the first twopositions of the line containing statement 0004.00

ETU400 User Guide 011603 D-13Use columns 48 through 51 to enter the ending position of the Salaryfield. This field ends in position 60.Column 52 spec

ETU400 User Guide 011603 D-14 F12=Cancel F23=Select prompt F24=More keys The Type entr

ETU400 User Guide 011603 D-15If you need to insert a line, enter I1 in the first two positions of theline number that will precede the new line. For

ETU400 User Guide 011603 E-1Appendix E ERROR MESSAGES: NATIVE MODE

ETU400 User Guide 011603 1-8Features of Version 5.6Version 5.6 is the latest release. This release supports changes in Operating System V5R1. The is

ETU400 User Guide 011603 E-2About This AppendixThis appendix lists the ETU error messages that are most likely to occur when you use ETU. Themessages

ETU400 User Guide 011603 E-3USR MESSAGES:If a USR message that you are experiencing is not in this document, please try this procedure, onthe AS/400,

ETU400 User Guide 011603 E-4TRANSFER PROBLEMS:PROBLEM: When we go into the option to transfer a spool file to a pc file and enter the outq, no spool

ETU400 User Guide 011603 E-5USER MESSAGES: PROBLEM:“USR0020 Translation failed. Specified record length differs from existing file.”CAUSE: The transl

ETU400 User Guide 011603 E-6PROBLEM:“USR0032 Error detected while materializing program into AS/400 object file does not containvalid AS/400 object d

ETU400 User Guide 011603 E-7PROBLEM:"USR4001 The PC disk/diskette is full - Transfer ended."CAUSE:The disk or diskette to which you are tra

ETU400 User Guide 011603 E-8PROBLEM"USR5255 Invalid PC file name or no space for a new directory entry" occurs when doing backto back file

ETU400 User Guide 011603 E-9PROBLEM:"USR7900 System Error - INCORRECT SYSTEM SERIAL NUMBER, CALL SYSTEM SUPPORTSTAFF” or on ETU36"USER 790

ETU400 User Guide 011603 E-10The values specified for the FILETYPE and RECL parameters are not compatible with each other.SOLUTION: If the value for

ETU400 User Guide 011603 E-11PROBLEM“USR8258 File &1 not found, RECL must be non-zero to create the file”.CAUSE: The host file you specified coul

ETU400 User Guide 011603 1-9Part One, Getting Started“Getting Started” is intended for all users of ETU. It describes how touse 2-1 Installing ETU3-

ETU400 User Guide 011603 E-12PROBLEM “USR9971 A DIF record found in PC file has record Length greater than allowed maximum of258”.CAUSE: The library

ETU400 User Guide 011603 E-13PROBLEM“USR9986 File transfer was interrupted: ("r" to retry or "c" to cancel)”.CAUSE:Only known cau

ETU400 User Guide 011603 E-14PROBLEM"USR9988 ETU encountered information not identified as part of an ETU process." This is sortof a catcha

ETU400 User Guide 011603 E-15CPF MESSAGES:These are the same as User Failures, except it was call by a program. Call Program Fault. PROBLEMGetting “C

ETU400 User Guide 011603 E-16 DDM File (CHGDDMF) command or use the necessary procedures to make the library exist on the

ETU400 User Guide 011603 E-17PROBLEMCPF5149: I/O error detected in XLATIN. Using 36 commands. Customer has to end theprocedure that creates the file

ETU400 User Guide 011603 E-18 17 -- The format of the data in a date, time, or timestamp field is not valid.

ETU400 User Guide 011603 E-19SYS MESSAGES:These are not ETU messages. These are System Messages. The exact meaning could probably betraced using F1 o

ETU400 User Guide 011603 E-20PROBLEMTrying to install software gets this message: “SYS-2594 ETUXFER Trying to Copy PrivilegedModule PCRCB1 not found”

ETU400 User Guide 011603 E-21OCL PROBLEMS PROBLEM:When I submit my OCL, I get this message: “PCT0002 Invalid or missing parameter.”CAUSE:There are tw

2-1Chapter 2 INSTALLING ETUAbout This ChapterInstalling ETUInstalling the ETU SoftwareRegistering Your Host SystemObtaining Your Host Registration Num

ETU400 User Guide 011603 E-22PROBLEM:I am using ES32 macro commands to do transfers and I get this error message: “USR9988 "ETUencountered infor

ETU400 User Guide 011603 E-23PROBLEM:“CPF0818 Value cannot be converted to type implied by receiver”. CAUSE:The value to be converted and the rec

ETU400 User Guide 011603 E-24PROBLEM“SYS1301 Invalid Procedure Name” when running a System 36 OCL. Commands sent in the scriptwork when sent from a c

ETU400 User Guide 011603 E-25PROBLEM:ETU requires that a session be at the signon screen and not logged on in order to accept batchtransfers to or fr

ETU400 User Guide 011603 F-1Appendix F ASCII-EBCDIC PRINTABLE CHARACTERS

ETU400 User Guide 011603 F-2About This AppendixThis appendix lists the ASCII and EBCDIC characters and their hexadecimalequivalents. Use this table w

ETU400 User Guide 011603 F-3Dec Hex EBCDIC ASCII000101202303404505606707808909100A110B120C130D140E15OF1610171118121913201421152216231724182519261A271

ETU400 User Guide 011603 F-45436 65537 75638 85739 9583A :593B ;603C613D =623E633F ?6440(space)@6541 A6642 â B6743 ä C6844 à D6945 á E7046 F7

ETU400 User Guide 011603 F-51096D_ m1106E> n1116F? o11270ø p11371É q11472ê r11573ë s11674è

ETU400 User Guide 011603 F-6165A5 v166A6 w167A7 x168A8 y169A9 z170AA171AB172AC173AD174AE175AF176B0177B1178B2179B3180B4181B5182B6183B7184B8185B9186BA1

ETU400 User Guide 011603 2-2About This ChapterThis chapter is intended for the system administrator, or otherexperienced host user responsible for in

ETU400 User Guide 011603 F-7221DD222DE223DF224E0225E1226E2 S227E3 T228E4 U229E5 V230E6 W231E7 X232E8 Y233E9 Z234EA235EB236EC237ED238EE239EF240F0241F1

ETU400 User Guide 011603 G-1Appendix G System/36-mode CommandsThis appendix contains the commands used to emulate ETU36.

ETU400 User Guide 011603 G-2About This AppendixSome users of ETU/400 may be more familiar with the operating system ofSystem/36 than with that of the

ETU400 User Guide 011603 G-3Starting ETU in System/36 ModeTo use the Emulator Transfer Utility (ETU) in System/36-mode, followthese steps.1. Start y

ETU400 User Guide 011603 G-4Each menu option executes a ETU36 procedure:1. executes the ALLOCATE procedure.2. executes the RENAME procedure.3. exe

ETU400 User Guide 011603 G-5Running ETU in System/36 ModeOnce you have signed on to the AS/400, you may execute an ETU procedurein the following ways

ETU400 User Guide 011603 G-6ALLOCATE ProcedureETU36 ALLOCATE workstation file nameThe ALLOCATE procedure allocates a new file on the workstation.wor

ETU400 User Guide 011603 G-7COMPILE ProceduresThe translation table functions are not provided in the S/36 mode. Thenative-mode translate tables prov

ETU400 User Guide 011603 G-8DELETE ProcedureETU DELETE workstation file name … notifyNOYESThe DELETE procedure deletes a file on the workstation.work

ETU400 User Guide 011603 G-9EDITABLE ProcedureThe translation table functions are not provided in the S/36 mode. Thenative-mode translate tables prov

ETU400 User Guide 011603 2-3Installing ETUTo install ETU on the AS/400, you will follow these basic steps:• load the ETU software;• register your cop

ETU400 User Guide 011603 G-10FILEFRPC ProcedureETU36 FILEFRPC, workstation file name , AS400 label, record len1 , T, 128reformat xlate file xlate siz

ETU400 User Guide 011603 G-11record len1 (optional) is the record length of the targetAS/400 file (“AS/400 label”). This value defaultsto 128.retain

ETU400 User Guide 011603 G-12record len2 (optional) is the record length of the translation work file. The default value is the record length of the

ETU400 User Guide 011603 G-13FILETOPC ProcedureETU36 FILETOPC, AS/400 label, date , reformat , xlate file , xlate size , record len *TEXT

ETU400 User Guide 011603 G-14When using *SAVE to move executable programs between workstations, all necessary data (including Mac dataand resource fo

ETU400 User Guide 011603 G-15LIBRFRPC ProcedureETU36 LIBRFROMPC, workstation file name , record len , 128 reformat , xlate file , xlate size ,

ETU400 User Guide 011603 G-16reformat (optional) specifies the type of data translation totake place on the AS/400 file. *TEXT (or *YES) the file is

ETU400 User Guide 011603 G-17add ctl (optional) specifies whether or not (YES or NO respectively) to add $MAINT utility control statementsinto the w

ETU400 User Guide 011603 G-18LIBRTOPC ProcedureETU36 LIBRTOPC, member name, partall member type member lib member name PROC clib partial name,

ETU400 User Guide 011603 G-19record len1 (optional) is the record length of the librarymember(s) to be sent to the workstation. This parameterdefaul

ETU400 User Guide 011603 2-41. Sign on to the AS/400 as QSECOFR.2. Ensure that library QTEMP is in your library list.3. Insert ETU software in the

ETU400 User Guide 011603 G-20spec lib (optional) is the library containing the field definition member (“input specs”), and the translatetable membe

ETU400 User Guide 011603 G-21PRNTFRPC Procedure ETU36 PRNTFRPC, workstation file name ,,, #copies , printer idforms id cpi lpi align , 10 10 ,

ETU400 User Guide 011603 G-22on the print spool until the operator releases it forprinting. The default is NO.width (optional) specifies the width i

ETU400 User Guide 011603 G-23PRNTTOPC ProcedureETU36 PRNTTOPC, function spool name , xlat file , qualifier file size COPYPRT , ALL

ETU400 User Guide 011603 G-24file size (optional) is the number of records in the temporary work file used in the translation process. The defaultva

ETU400 User Guide 011603 G-25RENAME FunctionETU36 RENAME, workstation file name ,,, new file name. The RENAME procedure changes the filename of a wo

ETU400 User Guide 011603 G-26TESTFILE ProcedureETU36 TESTFILE, workstation file name ,,, ida offsetNOTIFYThe TESTFILE procedure tests for the presen

ETU400 User Guide 011603 G-27XLT36FIL ProcedureETU36 XLT36FIL, AS/400 label1, date , AS/400 label2, retain , J Treformat , xlate file , xla

ETU400 User Guide 011603 G-28reformat (optional) specifies the type of data translation totake place on the AS/400 file.*TEXT (or *YES) the file is

ETU400 User Guide 011603 G-29XLT36PRT ProcedureETU36 XLT36PRT, function spool name , qualifier ,COPYPRT ALL RELEASEFxxx CANCELTRANSLATE, AS/400 labe

ETU400 User Guide 011603 iiiPROHIBITED USES================You may not:* Make the Software available to any person or entity other than Youremployees

ETU400 User Guide 011603 2-5old versions, since most users do not modify these tables

ETU400 User Guide 011603 G-30mode (optional) specifies whether the target translationfile is to be created by this procedure, or if anexisting file i

ETU400 User Guide 011603 G-31XLTPCFIL ProcedureETU36 XLTPCFIL, AS/400 label1, date , AS/400 label2, retain,JTreformat , xlate file , xlate size , re

ETU400 User Guide 011603 G-32reformat (optional) specifies the type of data translation to take place on the AS/400 file.*TEXT (or *YES) the file i

ETU400 User Guide 011603 G-33XLTPCPRT ProcedureETU36 XLTPCPRT, AS/400 label, date , # copies , printer id ,forms id , cpi , lpi , align hold 1

ETU400 User Guide 011603 H-1Appendix H INTERNATIONAL TRANSLATION TABLES

ETU400 User Guide 011603 H-2Installing International Translation TableNLynx Technologies now supports sixteen languages for the ETU/400 filetransfer

ETU400 User Guide 011603 I-1Appendix I ETU Automation ETU400 AutomationThis section is intended as an explanation of the considerations that one must

ETU400 User Guide 011603 I-2job). The ETU power commands are PWRDELETEB, PCFROMPC, PCTOPC,PWRFROM3XB, PWRRENAMEB, and PWRTO3XB.AUTOMATION MECHANISMSW

ETU400 User Guide 011603 I-3ETU commands: PWRFROM3XB, PWRTO3XB, PCFROMPC, and PCTOPC, as well as non-ETUcommands that can be submitted to a batch. Se

ETU400 User Guide 011603 J-1Appendix J ETU THROUGHPUT CONSIDERATIONS

ETU400 User Guide 011603 2-6If you have a version of ETU prior to 5.01 and have modified or createdtranslation tables, you must modify the tables fur

ETU400 User Guide 011603 J-2ETU THROUGHPUT CONSIDERATIONS This is a guide to answer questions regarding throughput with ETU 400.The latest revision o

ETU400 User Guide 011603 J-3QUESTION:What other options are there to ETU? ANSWER:FTP (such as File Transfer Protocol, using TCP/IP) or Client Access/

ETU400 User Guide 011603 J-4QUESTION:How would I use ETU400 and FTP? ANSWER:If you use ETU reasonably often and wish the file transfers quicker, for

ETU400 User Guide 011603 1 GLOSSARYAllocate To create a file on the microcomputer. API Application Program Interface. The interface(calling conventi

ETU400 User Guide 011603 2F&I Format and Input specifications. A means ofcreating internal file definitions on the AS/400.ETU supports F&I s

ETU400 User Guide 011603 2-7Obtaining Your Host Registration Number1. Have the following information ready before you request your hostregistration

ETU400 User Guide 011603 2-8If you are updating an existing version of ETU, sign on as the systemsecurity officer (QSECOFR), back up your ETU library

ETU400 User Guide 011603 2-9The ETU Compatibility Diskette: For Non-ES32 Emulation ProductsWhen ETU was originally sold, there was a compatibility di

ETU400 User Guide 011603 2-10"5250 Emulation not loaded, verify that your API is loaded."If your API is loaded and this message persists, c

3-1Chapter 3 USING ETUAbout This ChapterStarting ETU A Note About AuthorizationThe ETU Main Menu The ETU Utilities MenuThe ETU CommandsMain Menu:

ETU400 User Guide 011603 3-2About This ChapterThis chapter is intended for beginning users of ETU. It covers the basicsof running ETU in native mode

ETU400 User Guide 011603 3-3Starting ETU You can begin using ETU once it is installed on your host system. To start ETU:1. Load your 5250 emulation s

ETU400 User Guide 011603 3-4The ETU Main MenuThe ETU commands are split between two menus, the Main menu and theUtilities menu. The Main menu, show

ETU400 User Guide 011603 ivLIMITED WARRANTY=================NLynx warrants that, upon delivery by NLynx, the diskettes or other mediaon which the Sof

ETU400 User Guide 011603 3-5The ETU Utilities MenuThe ETU utilities menu provides access to the ETU commands that aren'tused for transferring fi

ETU400 User Guide 011603 3-6The ETU CommandsThere are 20 ETU commands that work with files. These commands can bedivided into five groups, each provi

ETU400 User Guide 011603 3-7Running ETU CommandsWith ETU, there are two ways to run commands: using the ETU menu, orentering ETU commands on the comm

ETU400 User Guide 011603 3-8Using the Command PromptsAfter you select the ETU command that you want to run, either by choosingan option from the menu

ETU400 User Guide 011603 3-9Recalling ETU CommandsIf you run the same ETU command more than once, you can avoid re-keyingrepeated values by using the

ETU400 User Guide 011603 3-10Types of ProcessingAny work that is processed by the AS/400 is called a job. Two importanttypes of jobs are interactive

ETU400 User Guide 011603 3-11About Microcomputer FilesETU works with several types of microcomputers, including IBM PCs (andcompatibles) and Apple Ma

ETU400 User Guide 011603 4-1Chapter 4 LEARNING ABOUT ETUAbout This ChapterWhat is ETU?Data TransferData TranslationOther ETU FunctionsAbout Transferr

ETU400 User Guide 011603 4-2About This ChapterThis chapter is a general overview of ETU and is intended for beginningusers. It explains how data is s

ETU400 User Guide 011603 4-3What is ETU?ETU has two main purposes: data transfer and data translation. Datatransfer entails the actual movement of da

ETU400 User Guide 011603 vLegal NoticesThis document is for use with the NLynx Technologies ETU/400 product.No part of this document may be copied in

ETU400 User Guide 011603 4-4About Transferring FilesETU allows you to transfer files and programs between a host system andany microcomputer connecte

ETU400 User Guide 011603 4-5Transferring Data to Host FilesWhen you transfer data to the host, you can transfer it to an existingfile, or to a new fi

ETU400 User Guide 011603 4-6Data Description SpecificationsWhen you create a physical file (*DATA) on the AS/400, you can define thefile using Data D

ETU400 User Guide 011603 4-7About Translating FilesYou must usually translate data when you transfer it between amicrocomputer and the host. That&apo

ETU400 User Guide 011603 4-8Using Translation TablesASCII and EBCDIC are standard character sets. When you transfer a filebetween a microcomputer and

ETU400 User Guide 011603 4-9ETU Translation Table MembersThe ETU translation tables member names and their specific functions inthe TRANSLATE file ar

ETU400 User Guide 011603 4-10Using Translation Tables with the MacAll ETU commands in which data translation occurs include the TRANSILEparameter. Th

ETU400 User Guide 011603 4-11Table 4-2 ETU Commands in which the translation table file name isoptionalETU Command ETU Main Menu OptionFROM3XB 1PRTTO

ETU400 User Guide 011603 4-12Using Microcomputer Data FormatsIn addition to translating files from ASCII to EBCDIC, ETU formats thedata so that it ca

ETU400 User Guide 011603 4-13Tab format (*TAB)DIF format (*DIF)TAB format is the same as BASIC Sequential,except that tab characters, rather than com

ETU400 User Guide 011603 viPREFACEThis manual is intended for users of the ETU 400 Emulator TransferUtility. It assumes the reader has a basic workin

ETU400 User Guide 011603 3Part Two Running ETU“Running ETU” is intended for all users of ETU. It introduces each ETUcommand and describes how to use

ETU400 User Guide 011603 5-1Chapter 5 TRANSFERRING FILESAbout This ChapterTransferring Data FilesTransferring Data Files From Host to a Microcomputer

ETU400 User Guide 011603 5-2About This ChapterThis chapter is intended for beginning users of ETU. It explains the filebasic transfer commands includ

ETU400 User Guide 011603 5-3Transferring Data FilesThe ETU commands FROM3XB and TO3XB transfer data files between the hostand a microcomputer.Transfe

ETU400 User Guide 011603 5-43. Enter the member name at the Member name prompt:user14. Specify *NONE as the parameter at the Translation table file

ETU400 User Guide 011603 5-5Transferring Data Files From a Microcomputer to the Host:The TO3XB CommandWith the TO3XB command, you can transfer and tr

ETU400 User Guide 011603 5-6TO3XB ExampleIn this example, you will transfer a file on your PC to a new hostphysical file. The file on the PC is calle

ETU400 User Guide 011603 5-7Transferring Print FilesThe ETU commands PRTFROM3X and PRTTO3X allow you to transfer print filesbetween the host and the

ETU400 User Guide 011603 5-8PRTFROM3X ExampleIn this example, there is a host spool file on the host output queueUSER1. You will transfer the file to

ETU400 User Guide 011603 5-94. Choose the spool file you want to transfer.Press the TAB key until the cursor is next to the spool file you want totr

ETU400 User Guide 011603 viiAbout This GuideUse this guide to install and run ETU 400 on the IBM AS/400 hostcomputer.Who Should Use This Guide?All us

ETU400 User Guide 011603 5-10Transferring a PC Print File to the Host:The PRTTO3X command allows you to transfer PC-DOS print files to the hostand ad

ETU400 User Guide 011603 5-11PRTTO3X ExampleIn this example, you will transfer a PC print file to the host and printit on the host printer. The PC fi

ETU400 User Guide 011603 5-12Transferring Host ProgramsThe ETU commands PGMFROM3XB and PGMTO3XB allow you to transfer compiledexecutable host program

ETU400 User Guide 011603 5-13If you are using this command to transfer a program between two differentAS/400s having differing versions of OS/400, yo

ETU400 User Guide 011603 5-14Transfer Host Programs to the Host:The PGMTO3XB command transfers executable host programs from a file onthe micro to th

ETU400 User Guide 011603 5-15PGMTO3XB ExampleIn this example, you will transfer a program from one host system toanother host system. To do this, yo

ETU400 User Guide 011603 6-1Chapter 6 TRANSLATING FILESAbout This ChapterWhy Use the Translation CommandsTranslation Commands Can Run in Batch ModeTr

ETU400 User Guide 011603 6-2About This ChapterThis chapter explains the ETU translation commands. These commands areused in conjunction with the ETU

ETU400 User Guide 011603 6-3Why Use the Translation CommandsIn Chapter 5, you learned about the ETU transfer commands. Those commandshave two purpose

ETU400 User Guide 011603 6-4Translating Data FilesThe translation commands XLATEFROM and XLATETO translate files separatelyfrom the transfer commands

iLegal Notices v© 2000 NLynx Technologies, Inc. All rights reserved. vPREFACE vTrademark Recognition. viAbout This Guide viiWho Should Use This Guide?

ETU400 User Guide 011603 6-5XLATEFROM ExampleSuppose you transferred a PC file to the host using the TO3XB command.You didn't translate the file

ETU400 User Guide 011603 6-64. At the Host output data file prompt, enter the name of the file towhich data will be written once it is translated:ho

ETU400 User Guide 011603 6-7Translating a Host File to Microcomputer Format:The XLATETO command translates a AS/400 physical file to a format usableo

ETU400 User Guide 011603 6-8XLATETO ExampleSuppose there is a file on the AS/400 that you want to transfer to yourMac. Before you transfer the file,

ETU400 User Guide 011603 6-9Translating Print FilesThe translation commands PRTXFRMPC and PRTXTOPC translate print files.The command PRTXFROMPC trans

ETU400 User Guide 011603 6-10Suppose you previously transferred a PC print file to a host file usingthe TO3XB command. Now you want to print the file

ETU400 User Guide 011603 6-11Translating Host Spool Files:The PRTXTOPC CommandThe PRTXTOPC command translates host spool files that reside on an AS/4

ETU400 User Guide 011603 6-12PRTXTOPC ExampleSuppose you have a host spool file on the host that you want to print onthe PC. Before you transfer the

ETU400 User Guide 011603 7-1Chapter 7 WORKING WITH PC FUNCTIONSAbout This ChapterRename a Micro File:The RENAMEB CommandRENAMEB ExampleAllocate a Mic

ETU400 User Guide 011603 7-2About This ChapterThis chapter explains the ETU commands that allow you to perform PCfunctions, such as creating and dele

ETU400 User Guide 011603 iiUSING ETU 3-1About This Chapter 3-2Starting ETU 3-3A Note About User Authorization 3-3The ETU Main Menu 3-4The ETU Utiliti

ETU400 User Guide 011603 7-3Rename a Micro File:The RENAMEB CommandWith the RENAMEB command, you can rename an existing micro file while youare in em

ETU400 User Guide 011603 7-4Allocate a Micro File: The ALOCATB CommandThe ALOCATB command creates a new file on the microcomputer. ALOCATB ExampleIn

ETU400 User Guide 011603 7-5Delete an Existing File:The DELETEB CommandJust as you may need to allocate (create) files on a microcomputer whilein emu

ETU400 User Guide 011603 7-6DELETEB ExampleIn this example, you are running emulation and you want to delete a fileon the PC's a: drive called f

ETU400 User Guide 011603 7-7Test for the Existence of a Micro File:The TESTB CommandWith the TESTB command, you can check to see if a file exists on

ETU400 User Guide 011603 8-1Chapter 8 MODIFYING TRANSLATION TABLESAbout This ChapterAbout Translation TablesModifying a Translation TableMake a Copy

ETU400 User Guide 011603 8-2About This Chapter ETU provides you with eight translation tables which it uses to translatedata. Each table performs a s

ETU400 User Guide 011603 8-3About Translation TablesThe translation tables provided with ETU have three purposes. They:• translate data from ASCII to

ETU400 User Guide 011603 8-4Modifying a Translation TableIf you decide that the standard translation tables included with ETUwon't work for you,

ETU400 User Guide 011603 8-5Make a Copy of the Original TableBefore you modify a translation table member, it is recommended that youcopy the origina