About This Appendix | Nlynx ETU400 manual

About This Appendix

On the AS/400, files can be defined with Data Definition Specifications (DDS) or Format and Input specifications (F&I). This appendix explains how to define files using F&I specs. F&I specs define field-oriented files on the AS/400, which are files in either *TAB, *BASICS, or *DIF format. Before you can transfer a field-oriented file, the file must be defined with F&I specs. F&I specs are not needed when transferring straight text files (*TEXT format).

F&I specs are created using the Source Entry Utility (SEU) on the AS/400. In order to use SEU you must have the proper authority. Your system administrator can verify for you whether you will be able to use SEU.

To create F&I specs for a file, you must know how each field in the file is defined. For example, you should know the field name, field length, and whether the field is numeric or alphabetic.

This appendix shows you how to create F&I specs with SEU by providing an example for you to follow.

ETU400 User Guide 011603

D-2

Image 225

Nlynx ETU400 manual About This Appendix

Contents

ETU400 Permitted and Intended Uses Definitions Prohibited Uses Limited Warranty NLynx Technologies, Inc. All rights reserved Legal Notices Preface Trademark Recognition About This Guide Who Should Use This Guide?How This Guide is Organized Introduction Using ETU Transferring Files Modifying Translation Tables 10-1 ETU Command Reference Creating DDS Specifications Appendix D Creating F&I Specifications International Translation Tables Getting Started Chapter Introduction What ETU Can Do for You Welcome to ETUETU Function Security Profile Required Qsecofr Security Considerations Inventory Checklist Hardware and Software Requirements Hardware RequirementsSoftware Requirements Features of Version Features of Version Features of Version Compatibility with Non-ES32 Emulation Products Native Mode and System/36 Mode Part One, Getting Started Installing ETU About This Chapter Installing the ETU Software Installing ETU ELIBNAMexisting-librarySVTRANLsave-translations Old versions, since most users do not modify these tables Registering Your Host System Using ETU During the Evaluation Period Obtaining Your Host Registration Number Re-installing ETUEntering the Registration Code Dspsysval sysvalqsrlnbr Installing ETU For International Users Removing ETU From Your Host SystemTechnical Support Who Could Use IBMTRAN? ETU Compatibility Diskette For Non-ES32 Emulation ProductsCopying Ibmtran To Your Hard Drive IBMTRAN.EXE Exiting Ibmtran Starting ETU When Using IbmtranAlternative Method to Start and Exit Ibmtran Ibmtran PC-DOS Using ETU About This Chapter Starting ETU Nlriscliff ETU Main Menu ETU Utilities Menu ETU Commands Running ETU Commands Using the MenuEntering Commands on the Command Line Using Mac Directory Dialog Boxes Using the Command Prompts Request Definitions Recalling ETU Commands Batch ETU Commands Interactive ETU CommandsTypes of Processing Strseu About Microcomputer Files File FormatsApple Mac Learning about ETU About This Chapter Data Transfer What is ETU?Data Translation Other ETU Functions Micro and Host File Names About Transferring Files Transferring Data to Host Files Record LengthHost File Type Data Description Specifications How Data is Stored About Translating Files Translate Using Translation Tables ETU Translation Table Members Mactab Using Translation Tables with the Mac FROM3XB Prttopc TO3XB Prtfrmpc PWRFROM3XB PWRTO3XB Using Microcomputer Data Formats Vectors Tab format *TAB DIF format *DIFTuples DATA0,0 Running ETU Transferring Files About This Chapter Transferring Data Files Transferring Data Files From Host to a MicrocomputerFROM3XB Example FROM3XB prompt screen TO3XB prompt screen Filetype*data srcseq*no translate*none TO3XB Example Transferring Print Files Transferring a Host Spool File to a PC Print FileAbout Host Spool Files User1 PRTFROM3X Example PRTFROM3X Print Queue Screen ATOE3 Transferring a PC Print File to the Host PRTTO3X Example Transferring Host Programs Transfer Host Programs to a Microcomputer PGMFROM3XB Command Beta1 PGMFROM3XB Example PGMTO3XB prompt screen Transfer Host Programs to the Host Userpgm PGMTO3XB Example Translating Files About This Chapter Translation Commands Can Run in Batch Mode Why Use the Translation CommandsTranslation Commands Can Be Run From a Host Terminal Translation Commands Reduce Modem Time Filetype*data, srcseq*no, translate*no Translating Data Files Rs132 Xlatefrom Example Tab Home1 Strip*no translate*no Translating a Host File to Microcomputer Format Xlateto Example Translating PC Print Files Prtxfrmpc Command Translating Print FilesPrtxfrmpc Example ETU400 User Guide Last Translating Host Spool Files Prtxtopc Command Print2 Prtxtopc ExampleCopyprt Letter2 Working with PC Functions ETU400 User Guide Renameb Example Rename a Micro File Renameb Command\data.pgm Data1.pgm Allocate a Micro File Alocatb Command Alocatb Example\reports\sales.feb Deleteb prompt screen Delete an Existing File Deleteb Command \report\fiscal.doc Deleteb Example Test for the Existence of a Micro File Testb Command Testb Example\datafile.doc Modifying Translation Tables About This Chapter About Translation Tables Modifying a Translation Table Make a Copy of the Original Table Editing the Translation TableTranslation Table Record Format Text DIF Basics TAB To HEX Translate Before/After Pad CharacterEnd-of-Record Action Comments End-of-File Action XBA PAD EOR EOF Comments Sample Translation TableOmit unprintable characters Numeric Characters Naming the New Member Compiling the New Translation Member Advanced ETU Features About This Chapter Multiple-device Transfer Transferring From Multiple MicrosQualified file name Multi Member nameFile PRT2AD3 Using PWRTO3XB Frmfile Transferring a Host File to Multiple Micros Micro-to-micro Transfers Pcfrompc Command MICLST1 QFNAME1 Pctopc Command Transferring Files Between Multiple Maces Mac File Transfer ExamplesTrainingTest If InterAxcess is one or more folders deep Record and Field Selection About Creating Auxiliary Storage PoolsTransferring Selected Fields Key field Field name Field Selection -- Example Salary Employee name Relationship Transferring Selected RecordsField to be tested Relational operator Record Selection -- Example Record Selection -- Example1 Example Entry and Exit Programs Deleting Files After Transfer Saving Request Definitions Re-using Request Definitions Fold/Unfold Execute Submit Batch Transfer prompt screen Performing Batch Transfers Batch Transfer Example PcfrompcQbatch Time and Date Scheduling Time and Date Scheduling Example NightEnter Command Reference ETU Command Reference Parameter description Parameter name Parameter values Alocatb CommandQfname Dspstsmsg Notify Deleteb Command Edittable Command PC-DOS TablesMac Tables 10-5 Edtudf Command Edtudf Notes FROM3XB Command 10-9 10-10 Strip*no, translate*no FROM3XB Notes Pcfrompc Command MICLIST1MICLIST2 XXXXXXXX.XX Pctopc Command 10-15 PGMFROM3XB Command PGMTgtrls Current PGMTO3XB Command PRTFROM3X Command OutqET0A1 PRTFROM3X Translate prompt screen PRTTO3X Command 10-21 Pcmbr Prtxfrmpc Command Library LPI Prtxtopc Command 10-25 10-26 Miclist Requester Pwrdeleteb Command PWRFROM3XB Command Exitpgm Entrypgm 10-30 10-31 10-32 10-33 Pwrrenameb Command PWRTO3XB Command 10-36 10-37 10-38 10-39 10-40 Renameb Command Sbmcmdname Sbmbatxfer CommandJobd Userprf Before You Begin Sbmschjob CommandSbmcmd Today To Schedule a Job Source file member name Strseu CommandPC-DOS Members Mac Members 10-46 YES Testb Command TO3XB Command TruncateFlddeffile YES 10-49 10-50 10-51 Vwsavrqs Notes Vwsavrqs CommandSubmit to batch Change 10-53 MBR Xlatefrom CommandJobd YES DDS 10-55 10-56 Xlateto Command Pcdata LastJobd SRC 10-58 10-59 10-60 Creating F & I Specifications Creating DDS SpecificationsETU Error Messages System/36-mode Commands Appendix a Inside ETU About This Chapter Editing User-defined Menu Options Mode Edtudf Parameters Edit User-defined Functions Edtudf ExampleEdtudf Pmt Figure A-1 The Cfgaudit prompt screen Configuring the Audit Trail Cfgaudit Parameters Checking the Audit Trail Granting Authority to a Command Working with ETU SecurityGrtobjaut Revoking Authority From a Command Regranting Authority to a Previously Revoked CommandRvkobjaut Unable to open display file with device specified Securing Devices on the AS/400 Rmvetu Removing ETU From the AS/400 Appendix B ETU Compatibility About This Appendix Modifying an Autokey Batch File Example Using ETU 5.01 and above with Autokey Batch FilesETU ENT ETU Appendix C Creating DDS Specifications About This Appendix Field Name Field Length Field Type Decimal Positions Creating DDS Specifications 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 Appendix D Creating F&I Specifications 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 Appendix E Error Messages Native Mode 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 Appendix F ASCII-EBCDIC Printable Characters 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 Appendix G System/36-mode Commands About This Appendix Starting ETU in System/36 Mode ETU36 MenuStrs36 ETU400 User Guide Native Commands Not Supported in the System/36 Mode Running ETU in System/36 ModeSystem/36-mode Commands and Native Mode Equivalents Menu ETU36, your ETU library name ETU36 Allocate Allocate Procedure Compile Procedures Workstation file name Delete ProcedureNotify Mac Users Editable Procedure Text ATOE1 Filefrpc ProcedureBasics TAB Save None Retain Record len1Reformat Text or *YES Input specs Record len2Truncate Spec lib Filetopc Procedure Text ETOA1Date ETU400 User Guide YES DIF Librfrpc Procedure Xlat size Lib nameReplace Add ctl Member typeFile size Proc Librtopc ProcedureLibrary ALL Source Partall Remove ctl ETU400 User Guide Prntfrpc Procedure Width Procedure Prnttopc ProcedureSpool name Qualifier ETU400 User Guide Rename Function Testfile Procedure XLT36FIL Procedure AS/400 label1AS/400 label2 Performedthe default XLT36PRT Procedure FunctionDate-1 Date-2 From windowTo window Xltpcfil Procedure Basic Sequential format with Xltpcprt Procedure Appendix H International Translation Tables Country Installing International Translation TableRstobj OBJSRCxx Savlibnewtable DEVdevice-name RSTLIByyyyyy Crttable SRCxx TRANLIBlibrary-name Appendix ETU400 Automation Automation Mechanisms ETU400 User Guide Appendix J ETU Throughput Considerations What kind of throughput can I expect? What other options are there to ETU? How would I use ETU400 and FTP? Ascii character set AllocateBatch processing Data transfer Host system System/36 modeInteractive processing Job queue