Manuals / Nlynx / Computer Equipment / Network Card

Nlynx ETU400 manual Record and Field Selection, About Creating Auxiliary Storage Pools

Models: ETU400

1 314

Download 314 pages 52.42 Kb

Page 116

Figure 9-2 Transferring Files With InterAxcess Several Levels Deep

Record and Field Selection

Record selection and field selection are features that allow you to transfer only the records and fields you specify. This feature is part of the PWRFROM3XB command. Record selection and field selection are not mutually exclusive functions of ETU, although it's not necessary to use them together.

NOTE: Record and field selection can be used only with externally-defined host physical files.

About Creating Auxiliary Storage Pools

The Record and Field Selection feature within the PWRFROM3XB command will not work properly if you define one or more additional Auxiliary Storage Pools on the AS/400. This is because ETU creates temporary work files in the library QTEMP, which is always located in Auxiliary Storage Pool #1 (which comes with OS/400). If you create an additional Auxiliary Storage Pool, ETU cannot create the work files associated with the data file that is stored in any newly created Auxiliary Storage Pools.

If you do create a new Auxiliary Storage Pool, you can simulate record and field selection in a file transfer operation by creating a logical file or and open query file and transferring those files.

Transferring Selected Fields

When you transfer a physical file from the host to a micro with the PWRFROM3XB command, you have the choice of transferring all the fields in the file, or, using field selection, transferring only the fields you select. You can also specify the order in which the data will reside in the micro file.

For each field you select to transfer, supply information to the following parameters, found under the heading FLDSEL (field selection) on the PWRFROM3XB prompt screen. The parameters are:

ETU400 User Guide 011603

9-12

Image 116

Nlynx ETU400 manual Record and Field Selection, About Creating Auxiliary Storage Pools, Transferring Selected Fields

Contents

ETU400 Definitions Permitted and Intended UsesProhibited Uses Limited Warranty Legal Notices NLynx Technologies, Inc. All rights reservedTrademark Recognition PrefaceHow This Guide is Organized About This GuideWho Should Use This Guide? Introduction Using ETU Transferring Files Modifying Translation Tables ETU Command Reference 10-1Creating DDS Specifications Appendix D Creating F&I Specifications International Translation Tables Getting Started Introduction ChapterWelcome to ETU What ETU Can Do for YouETU Function Security Profile Required QsecofrInventory Checklist Security ConsiderationsSoftware 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 ProductsPart One, Getting Started Installing ETU About This Chapter Installing ETU Installing the ETU SoftwareELIBNAMexisting-librarySVTRANLsave-translations Old versions, since most users do not modify these tables Using ETU During the Evaluation Period Registering Your Host SystemRe-installing ETU Obtaining Your Host Registration NumberEntering the Registration Code Dspsysval sysvalqsrlnbrTechnical 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.EXEStarting ETU When Using Ibmtran Exiting IbmtranAlternative Method to Start and Exit Ibmtran IbmtranUsing ETU PC-DOSAbout This Chapter Starting ETU ETU Main Menu NlriscliffETU Utilities Menu ETU Commands Entering Commands on the Command Line Running ETU CommandsUsing the Menu Using the Command Prompts Using Mac Directory Dialog BoxesRecalling ETU Commands Request DefinitionsInteractive ETU Commands Batch ETU CommandsTypes of Processing StrseuApple Mac About Microcomputer FilesFile Formats Learning about ETU About This Chapter What is ETU? Data TransferData Translation Other ETU FunctionsAbout Transferring Files Micro and Host File NamesHost File Type Transferring Data to Host FilesRecord Length Data Description Specifications About Translating Files How Data is StoredUsing Translation Tables TranslateETU Translation Table Members Using Translation Tables with the Mac MactabFROM3XB Prttopc TO3XB Prtfrmpc PWRFROM3XB PWRTO3XB Using Microcomputer Data Formats Tab format *TAB DIF format *DIF VectorsTuples DATA0,0Running 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 screenTO3XB Example About Host Spool Files Transferring Print FilesTransferring a Host Spool File to a PC Print File PRTFROM3X Example User1PRTFROM3X Print Queue Screen Transferring a PC Print File to the Host ATOE3PRTTO3X Example Transfer Host Programs to a Microcomputer PGMFROM3XB Command Transferring Host ProgramsPGMFROM3XB Example Beta1Transfer Host Programs to the Host PGMTO3XB prompt screenPGMTO3XB Example UserpgmTranslating 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 TimeTranslating Data Files Filetype*data, srcseq*no, translate*noXlatefrom Example Rs132Home1 TabTranslating a Host File to Microcomputer Format Strip*no translate*noXlateto Example Prtxfrmpc Example Translating PC Print Files Prtxfrmpc CommandTranslating Print Files ETU400 User Guide Translating Host Spool Files Prtxtopc Command LastPrtxtopc Example Print2Copyprt Letter2Working 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 screenDeleteb 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 TABEnd-of-Record Action Translate Before/AfterPad Character End-of-File Action CommentsSample Translation Table XBA PAD EOR EOF CommentsOmit unprintable characters Numeric CharactersCompiling the New Translation Member Naming the New MemberAdvanced ETU Features About This Chapter Qualified file name Multiple-device TransferTransferring From Multiple Micros Member name MultiFile PRT2AD3Using PWRTO3XB Transferring a Host File to Multiple Micros FrmfilePcfrompc Command Micro-to-micro TransfersMICLST1 Pctopc Command QFNAME1TrainingTest 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 fieldField Selection -- Example Salary Employee name Transferring Selected Records RelationshipField to be tested Relational operatorRecord Selection -- Example1 Record Selection -- ExampleEntry and Exit Programs ExampleDeleting Files After Transfer Re-using Request Definitions Saving Request DefinitionsExecute Fold/UnfoldPerforming Batch Transfers Submit Batch Transfer prompt screenQbatch 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 DspstsmsgDeleteb Command NotifyMac Tables Edittable CommandPC-DOS Tables 10-5 Edtudf Command Edtudf Notes FROM3XB Command 10-9 10-10 FROM3XB Notes Strip*no, translate*noMICLIST2 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 PcmbrLPI LibraryPrtxtopc Command 10-25 10-26 Pwrdeleteb Command Miclist RequesterPWRFROM3XB Command Entrypgm Exitpgm10-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 UserprfSbmschjob Command Before You BeginSbmcmd TodayTo Schedule a Job Strseu Command Source file member namePC-DOS Members Mac Members10-46 Testb Command YESFlddeffile YES TO3XB CommandTruncate 10-49 10-50 10-51 Vwsavrqs Command Vwsavrqs NotesSubmit to batch Change10-53 Xlatefrom Command MBRJobd YES DDS10-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 CommandsInside ETU Appendix aAbout This Chapter Editing User-defined Menu Options Edtudf Parameters ModeEdtudf Example Edit User-defined FunctionsEdtudf PmtConfiguring the Audit Trail Figure A-1 The Cfgaudit prompt screenCfgaudit 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 specifiedRemoving ETU From the AS/400 RmvetuETU Compatibility Appendix BAbout This Appendix Using ETU 5.01 and above with Autokey Batch Files Modifying an Autokey Batch File ExampleETU ENT ETUCreating DDS Specifications Appendix CAbout This Appendix Creating DDS Specifications Field Name Field Length Field Type Decimal PositionsFigure 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 DAbout 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 EAbout 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 FAbout 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 GAbout 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 nameAllocate Procedure ETU36 AllocateCompile Procedures Delete Procedure Workstation file nameNotify Mac UsersEditable Procedure Filefrpc Procedure Text ATOE1Basics TAB Save NoneRecord len1 RetainReformat Text or *YESRecord len2 Input specsTruncate Spec libDate Filetopc ProcedureText ETOA1 ETU400 User Guide Librfrpc Procedure YES DIFReplace Xlat sizeLib name File size Add ctlMember type Librtopc Procedure ProcLibrary ALL Source PartallRemove ctl ETU400 User Guide Prntfrpc Procedure Width Prnttopc Procedure ProcedureSpool name QualifierETU400 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 HInstalling International Translation Table CountryRstobj OBJSRCxx Savlibnewtable DEVdevice-name RSTLIByyyyyy Crttable SRCxx TRANLIBlibrary-nameETU400 Automation AppendixAutomation Mechanisms ETU400 User Guide ETU Throughput Considerations Appendix JWhat 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 transferSystem/36 mode Host systemInteractive processing Job queue