10-58 | Nlynx ETU400 specs

The XLATETO command translates an AS/400 physical file member prior to transferring it to a micro. It is intended for use in instances where translation is to occur sometime before the actual transfer with the FROM3XB command (for instance, on a long-distance telephone line in order to keep line costs down). This command can be put on the JOBQ with the SBMJOB command (in that case, do not specify the JOBD parameter). This command may be executed from any terminal on the AS/400, not necessarily the connecting micro, as it does not involve any interaction with the micro.

When using FROM3XB to transfer the resulting data, code the FROM3XB parameters STRIP and TRANSLATE as follows:

strip(no), translate(no)

FRMFILE The file name of the AS/400 file to be translated.

Library The library containing the FRMFILE file. *LIBL is the default, specifying that all libraries in the library list are to be searched.

FRMMBR The FRMFILE member name. You can enter the member name or one of the following values:

*FILE Translates the member with the same name as the FRMFILE file (the default).

*ALL Translates all members in the file into one member. *ALL is not valid with *DIF translation.

*FIRST Processes the first member (arrival sequence) in the file.

*LAST Processes the last member (arrival sequence) in the file.

PCDATA The name of the AS/400 physical file that is to contain the translated data.

Library The library containing the PCDATA. *LIBL is the default, specifying that all libraries in the library list are to be searched.

PCMBR The PCDATA file member name.

STRIP For source physical files only: Specifies whether the 12-byte source sequence number and data field for source physical files is to be removed before translation.

*YES Strip off (ignore) the first 12 bytes.

*NO Do not strip off any data from the record (default).

TRANSLATE Specifies the type of file translation that is to be performed:

*TEXT Converts the file to text format (the default).

*DIF Converts the file to DIF format.

ETU400 User Guide 011603

10-58

Image 188

Nlynx ETU400 manual 10-58

Contents

ETU400 Definitions Permitted and Intended Uses Prohibited Uses Limited Warranty Legal Notices NLynx Technologies, Inc. All rights reserved Trademark Recognition Preface How This Guide is Organized About This GuideWho Should Use This Guide? Introduction Using ETU Transferring Files Modifying Translation Tables ETU Command Reference 10-1 Creating DDS Specifications Appendix D Creating F&I Specifications International Translation Tables Getting Started Introduction Chapter Welcome to ETU What ETU Can Do for YouETU Function Security Profile Required Qsecofr Inventory Checklist Security Considerations Software Requirements Hardware and Software RequirementsHardware Requirements Features of Version Features of Version Features of Version Native Mode and System/36 Mode Compatibility with Non-ES32 Emulation Products Part One, Getting Started Installing ETU About This Chapter Installing ETU Installing the ETU Software ELIBNAMexisting-librarySVTRANLsave-translations Old versions, since most users do not modify these tables Using ETU During the Evaluation Period Registering Your Host System Re-installing ETU Obtaining Your Host Registration NumberEntering the Registration Code Dspsysval sysvalqsrlnbr Technical Support Installing ETU For International UsersRemoving ETU From Your Host System ETU Compatibility Diskette For Non-ES32 Emulation Products Who Could Use IBMTRAN?Copying Ibmtran To Your Hard Drive IBMTRAN.EXE Starting ETU When Using Ibmtran Exiting IbmtranAlternative Method to Start and Exit Ibmtran Ibmtran Using ETU PC-DOS About This Chapter Starting ETU ETU Main Menu Nlriscliff ETU Utilities Menu ETU Commands Entering Commands on the Command Line Running ETU CommandsUsing the Menu Using the Command Prompts Using Mac Directory Dialog Boxes Recalling ETU Commands Request Definitions Interactive ETU Commands Batch ETU CommandsTypes of Processing Strseu Apple Mac About Microcomputer FilesFile Formats Learning about ETU About This Chapter What is ETU? Data TransferData Translation Other ETU Functions About Transferring Files Micro and Host File Names Host File Type Transferring Data to Host FilesRecord Length Data Description Specifications About Translating Files How Data is Stored Using Translation Tables Translate ETU Translation Table Members Using Translation Tables with the Mac Mactab FROM3XB Prttopc TO3XB Prtfrmpc PWRFROM3XB PWRTO3XB Using Microcomputer Data Formats Tab format *TAB DIF format *DIF VectorsTuples DATA0,0 Running ETU Transferring Files About This Chapter FROM3XB Example Transferring Data FilesTransferring Data Files From Host to a Microcomputer FROM3XB prompt screen Filetype*data srcseq*no translate*none TO3XB prompt screen TO3XB Example About Host Spool Files Transferring Print FilesTransferring a Host Spool File to a PC Print File PRTFROM3X Example User1 PRTFROM3X Print Queue Screen Transferring a PC Print File to the Host ATOE3 PRTTO3X Example Transfer Host Programs to a Microcomputer PGMFROM3XB Command Transferring Host Programs PGMFROM3XB Example Beta1 Transfer Host Programs to the Host PGMTO3XB prompt screen PGMTO3XB Example Userpgm Translating Files About This Chapter Why Use the Translation Commands Translation Commands Can Run in Batch ModeTranslation Commands Can Be Run From a Host Terminal Translation Commands Reduce Modem Time Translating Data Files Filetype*data, srcseq*no, translate*no Xlatefrom Example Rs132 Home1 Tab Translating a Host File to Microcomputer Format Strip*no translate*no Xlateto Example Prtxfrmpc Example Translating PC Print Files Prtxfrmpc CommandTranslating Print Files ETU400 User Guide Translating Host Spool Files Prtxtopc Command Last Prtxtopc Example Print2Copyprt Letter2 Working with PC Functions ETU400 User Guide Rename a Micro File Renameb Command Renameb Example\data.pgm Data1.pgm \reports\sales.feb Allocate a Micro File Alocatb CommandAlocatb Example Delete an Existing File Deleteb Command Deleteb prompt screen Deleteb Example \report\fiscal.doc \datafile.doc Test for the Existence of a Micro File Testb CommandTestb Example Modifying Translation Tables About This Chapter About Translation Tables Modifying a Translation Table Translation Table Record Format Make a Copy of the Original TableEditing the Translation Table To HEX Text DIF Basics TAB End-of-Record Action Translate Before/AfterPad Character End-of-File Action Comments Sample Translation Table XBA PAD EOR EOF CommentsOmit unprintable characters Numeric Characters Compiling the New Translation Member Naming the New Member Advanced ETU Features About This Chapter Qualified file name Multiple-device TransferTransferring From Multiple Micros Member name MultiFile PRT2AD3 Using PWRTO3XB Transferring a Host File to Multiple Micros Frmfile Pcfrompc Command Micro-to-micro Transfers MICLST1 Pctopc Command QFNAME1 TrainingTest Transferring Files Between Multiple MacesMac File Transfer Examples If InterAxcess is one or more folders deep Transferring Selected Fields Record and Field SelectionAbout Creating Auxiliary Storage Pools Field name Key field Field Selection -- Example Salary Employee name Transferring Selected Records RelationshipField to be tested Relational operator Record Selection -- Example1 Record Selection -- Example Entry and Exit Programs Example Deleting Files After Transfer Re-using Request Definitions Saving Request Definitions Execute Fold/Unfold Performing Batch Transfers Submit Batch Transfer prompt screen Qbatch Batch Transfer ExamplePcfrompc Time and Date Scheduling Enter Time and Date Scheduling ExampleNight Command Reference ETU Command Reference Alocatb Command Parameter description Parameter name Parameter valuesQfname Dspstsmsg Deleteb Command Notify Mac Tables Edittable CommandPC-DOS Tables 10-5 Edtudf Command Edtudf Notes FROM3XB Command 10-9 10-10 FROM3XB Notes Strip*no, translate*no MICLIST2 Pcfrompc CommandMICLIST1 XXXXXXXX.XX Pctopc Command 10-15 Tgtrls Current PGMFROM3XB CommandPGM PGMTO3XB Command ET0A1 PRTFROM3X CommandOutq PRTFROM3X Translate prompt screen PRTTO3X Command 10-21 Prtxfrmpc Command Pcmbr LPI Library Prtxtopc Command 10-25 10-26 Pwrdeleteb Command Miclist Requester PWRFROM3XB Command Entrypgm Exitpgm 10-30 10-31 10-32 10-33 Pwrrenameb Command PWRTO3XB Command 10-36 10-37 10-38 10-39 10-40 Renameb Command Sbmbatxfer Command SbmcmdnameJobd Userprf Sbmschjob Command Before You BeginSbmcmd Today To Schedule a Job Strseu Command Source file member namePC-DOS Members Mac Members 10-46 Testb Command YES Flddeffile YES TO3XB CommandTruncate 10-49 10-50 10-51 Vwsavrqs Command Vwsavrqs NotesSubmit to batch Change 10-53 Xlatefrom Command MBRJobd YES DDS 10-55 10-56 Jobd SRC Xlateto CommandPcdata Last 10-58 10-59 10-60 Creating DDS Specifications Creating F & I SpecificationsETU Error Messages System/36-mode Commands Inside ETU Appendix a About This Chapter Editing User-defined Menu Options Edtudf Parameters Mode Edtudf Example Edit User-defined FunctionsEdtudf Pmt Configuring the Audit Trail Figure A-1 The Cfgaudit prompt screen Cfgaudit Parameters Checking the Audit Trail Grtobjaut Granting Authority to a CommandWorking with ETU Security Rvkobjaut Revoking Authority From a CommandRegranting Authority to a Previously Revoked Command Securing Devices on the AS/400 Unable to open display file with device specified Removing ETU From the AS/400 Rmvetu ETU Compatibility Appendix B About This Appendix Using ETU 5.01 and above with Autokey Batch Files Modifying an Autokey Batch File ExampleETU ENT ETU Creating DDS Specifications Appendix C About This Appendix Creating DDS Specifications Field Name Field Length Field Type Decimal Positions Figure C-2 The AS400 PDM screen Figure C-3 The Select Members screen Figure C-4 The Work With Members screen Figure C-5 The Start Source Entry Utility screen Figure C-6 The SEU Edit screen Figure C-7 The SEU Edit Screen after F4 prompt Figure C-8 The SEU Edit Screen Figure C-9 SEU Edit screen Figure C-10 The SEU Edit screen Figure C-11 The SEU Edit screen Figure C-12 The SEU Edit screen Figure C-13 The SEU Edit screen Figure C-14 The SEU Exit screen Figure C-15 The PDM screen Creating F&I Specifications Appendix D About This Appendix Creating F & I Specifications Figure D-2 The Start Source Entry Utility screen Figure D-3 The SEU Edit screen Figure D-4 The SEU Edit screen for line ETU400 User Guide Figure D-5 The SEU Edit screen for line ETU400 User Guide Figure D-6 SEU Edit screen for line ETU400 User Guide Figure D-7 SEU Edit screen for line Figure D-8 SEU Edit screen for line ETU400 User Guide Figure D-9 The SEU Exit screen Error Messages Native Mode Appendix E About This Appendix USR Messages Transfer Problems User Messages USR1255 File &1 was not found on the PC disk/diskette USR4001 The PC disk/diskette is full Transfer ended Timing problem Or on ETU36 Solution Host file you specified could not be found Addlible Pctran Only known cause was a remote controller Trying to type during a transfer CPF Messages QS36F is not in the library list CPF5035 Data mapping error on member ETU400 User Guide SYS Messages Problem OCL Problems Problem Change it back and IPL Etunew Problem ASCII-EBCDIC Printable Characters Appendix F About This Appendix Ebcdic Ascii 100 101 102 103 104 105 106 107 108 ETU400 User Guide 202 CA 203 CB 204 CC 205 CD 206 CE 207 CF 208 D0 221 DD 222 DE 223 DF 224 E0 225 E1 System/36-mode Commands Appendix G About This Appendix Strs36 Starting ETU in System/36 ModeETU36 Menu ETU400 User Guide Running ETU in System/36 Mode Native Commands Not Supported in the System/36 ModeSystem/36-mode Commands and Native Mode Equivalents Menu ETU36, your ETU library name Allocate Procedure ETU36 Allocate Compile Procedures Delete Procedure Workstation file nameNotify Mac Users Editable Procedure Filefrpc Procedure Text ATOE1Basics TAB Save None Record len1 RetainReformat Text or *YES Record len2 Input specsTruncate Spec lib Date Filetopc ProcedureText ETOA1 ETU400 User Guide Librfrpc Procedure YES DIF Replace Xlat sizeLib name File size Add ctlMember type Librtopc Procedure ProcLibrary ALL Source Partall Remove ctl ETU400 User Guide Prntfrpc Procedure Width Prnttopc Procedure ProcedureSpool name Qualifier ETU400 User Guide Rename Function Testfile Procedure AS/400 label2 XLT36FIL ProcedureAS/400 label1 Performedthe default Date-1 XLT36PRT ProcedureFunction To window Date-2From window Xltpcfil Procedure Basic Sequential format with Xltpcprt Procedure International Translation Tables Appendix H Installing International Translation Table CountryRstobj OBJSRCxx Savlibnewtable DEVdevice-name RSTLIByyyyyy Crttable SRCxx TRANLIBlibrary-name ETU400 Automation Appendix Automation Mechanisms ETU400 User Guide ETU Throughput Considerations Appendix J What kind of throughput can I expect? What other options are there to ETU? How would I use ETU400 and FTP? Allocate Ascii character setBatch processing Data transfer System/36 mode Host systemInteractive processing Job queue