Manuals / Nlynx / Computer Equipment / Network Card

Nlynx ETU400 manual Field name, Key field

Models: ETU400

1 314

Download 314 pages 52.42 Kb

Page 117

Field name	The name of the field you want to transfer. You
	may transfer up to 25 fields.
Key field	Specifies whether the field is to be a key field.
	The default, *NONE, does not re-sort the records,
	but rather, leaves them in sequential order. The
	field does not have to be an existing key field
	in the file.
	The total of the key fields cannot exceed 120
	characters in length.

Ascending or descending Specifies whether the records are sorted in ascending or descending order (*ASC or *DES).

ETU400 User Guide 011603

9-13

Image 117

Nlynx ETU400 manual Field name, Key field

Contents

ETU400 Permitted and Intended Uses DefinitionsProhibited Uses Limited Warranty NLynx Technologies, Inc. All rights reserved Legal NoticesPreface Trademark RecognitionAbout This Guide Who Should Use This Guide?How This Guide is Organized Introduction Using ETU Transferring Files Modifying Translation Tables 10-1 ETU Command ReferenceCreating DDS Specifications Appendix D Creating F&I Specifications International Translation Tables Getting Started Chapter IntroductionWhat ETU Can Do for You Welcome to ETUETU Function Security Profile Required QsecofrSecurity Considerations Inventory ChecklistHardware 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 ModePart One, Getting Started Installing ETU About This Chapter Installing the ETU Software Installing ETUELIBNAMexisting-librarySVTRANLsave-translations Old versions, since most users do not modify these tables Registering Your Host System Using ETU During the Evaluation PeriodObtaining Your Host Registration Number Re-installing ETUEntering the Registration Code Dspsysval sysvalqsrlnbrInstalling 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.EXEExiting Ibmtran Starting ETU When Using IbmtranAlternative Method to Start and Exit Ibmtran IbmtranPC-DOS Using ETUAbout This Chapter Starting ETU Nlriscliff ETU Main MenuETU Utilities Menu ETU Commands Running ETU Commands Using the MenuEntering Commands on the Command Line Using Mac Directory Dialog Boxes Using the Command PromptsRequest Definitions Recalling ETU CommandsBatch ETU Commands Interactive ETU CommandsTypes of Processing StrseuAbout Microcomputer Files File FormatsApple Mac Learning about ETU About This Chapter Data Transfer What is ETU?Data Translation Other ETU FunctionsMicro and Host File Names About Transferring FilesTransferring Data to Host Files Record LengthHost File Type Data Description Specifications How Data is Stored About Translating FilesTranslate Using Translation TablesETU Translation Table Members Mactab Using Translation Tables with the MacFROM3XB Prttopc TO3XB Prtfrmpc PWRFROM3XB PWRTO3XB Using Microcomputer Data Formats Vectors Tab format *TAB DIF format *DIFTuples DATA0,0Running 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*noneTO3XB Example Transferring Print Files Transferring a Host Spool File to a PC Print FileAbout Host Spool Files User1 PRTFROM3X ExamplePRTFROM3X Print Queue Screen ATOE3 Transferring a PC Print File to the HostPRTTO3X Example Transferring Host Programs Transfer Host Programs to a Microcomputer PGMFROM3XB CommandBeta1 PGMFROM3XB ExamplePGMTO3XB prompt screen Transfer Host Programs to the HostUserpgm PGMTO3XB ExampleTranslating 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 TimeFiletype*data, srcseq*no, translate*no Translating Data FilesRs132 Xlatefrom ExampleTab Home1Strip*no translate*no Translating a Host File to Microcomputer FormatXlateto Example Translating PC Print Files Prtxfrmpc Command Translating Print FilesPrtxfrmpc Example ETU400 User Guide Last Translating Host Spool Files Prtxtopc CommandPrint2 Prtxtopc ExampleCopyprt Letter2Working with PC Functions ETU400 User Guide Renameb Example Rename a Micro File Renameb Command\data.pgm Data1.pgmAllocate a Micro File Alocatb Command Alocatb Example\reports\sales.feb Deleteb prompt screen Delete an Existing File Deleteb Command\report\fiscal.doc Deleteb ExampleTest 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 HEXTranslate Before/After Pad CharacterEnd-of-Record Action Comments End-of-File ActionXBA PAD EOR EOF Comments Sample Translation TableOmit unprintable characters Numeric CharactersNaming the New Member Compiling the New Translation MemberAdvanced ETU Features About This Chapter Multiple-device Transfer Transferring From Multiple MicrosQualified file name Multi Member nameFile PRT2AD3Using PWRTO3XB Frmfile Transferring a Host File to Multiple MicrosMicro-to-micro Transfers Pcfrompc CommandMICLST1 QFNAME1 Pctopc CommandTransferring 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 nameField Selection -- Example Salary Employee name Relationship Transferring Selected RecordsField to be tested Relational operatorRecord Selection -- Example Record Selection -- Example1Example Entry and Exit ProgramsDeleting Files After Transfer Saving Request Definitions Re-using Request DefinitionsFold/Unfold ExecuteSubmit Batch Transfer prompt screen Performing Batch TransfersBatch 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 DspstsmsgNotify Deleteb CommandEdittable Command PC-DOS TablesMac Tables 10-5 Edtudf Command Edtudf Notes FROM3XB Command 10-9 10-10 Strip*no, translate*no FROM3XB NotesPcfrompc 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 CommandLibrary LPIPrtxtopc Command 10-25 10-26 Miclist Requester Pwrdeleteb CommandPWRFROM3XB Command Exitpgm Entrypgm10-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 UserprfBefore You Begin Sbmschjob CommandSbmcmd TodayTo Schedule a Job Source file member name Strseu CommandPC-DOS Members Mac Members10-46 YES Testb CommandTO3XB Command TruncateFlddeffile YES 10-49 10-50 10-51 Vwsavrqs Notes Vwsavrqs CommandSubmit to batch Change10-53 MBR Xlatefrom CommandJobd YES DDS10-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 CommandsAppendix a Inside ETUAbout This Chapter Editing User-defined Menu Options Mode Edtudf ParametersEdit User-defined Functions Edtudf ExampleEdtudf PmtFigure A-1 The Cfgaudit prompt screen Configuring the Audit TrailCfgaudit 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/400Rmvetu Removing ETU From the AS/400Appendix B ETU CompatibilityAbout This Appendix Modifying an Autokey Batch File Example Using ETU 5.01 and above with Autokey Batch FilesETU ENT ETUAppendix C Creating DDS SpecificationsAbout This Appendix Field Name Field Length Field Type Decimal Positions Creating DDS SpecificationsFigure 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 SpecificationsAbout 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 ModeAbout 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 CharactersAbout 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 CommandsAbout 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 nameETU36 Allocate Allocate ProcedureCompile Procedures Workstation file name Delete ProcedureNotify Mac UsersEditable Procedure Text ATOE1 Filefrpc ProcedureBasics TAB Save NoneRetain Record len1Reformat Text or *YESInput specs Record len2Truncate Spec libFiletopc Procedure Text ETOA1Date ETU400 User Guide YES DIF Librfrpc ProcedureXlat size Lib nameReplace Add ctl Member typeFile size Proc Librtopc ProcedureLibrary ALL Source PartallRemove ctl ETU400 User Guide Prntfrpc Procedure Width Procedure Prnttopc ProcedureSpool name QualifierETU400 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 TablesCountry Installing International Translation TableRstobj OBJSRCxx Savlibnewtable DEVdevice-name RSTLIByyyyyy Crttable SRCxx TRANLIBlibrary-nameAppendix ETU400 AutomationAutomation Mechanisms ETU400 User Guide Appendix J ETU Throughput ConsiderationsWhat 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 transferHost system System/36 modeInteractive processing Job queue