Manuals / Nlynx / Computer Equipment / Network Card

Nlynx ETU400 manual TO3XB Command, Truncate, Flddeffile YES

Models: ETU400

1 314

Download 314 pages 52.42 Kb

Page 178

TO3XB Command

Parameter description	Parameter name	Parameter values
File name	TOFILE	host file name
Library name		*MULTI
Library name		*LIBL
Member name	FRMMBR	library name
Member name	FRMMBR	*FILE
		*MULTI
Record length	RECL	member name
Record length	RECL	*FILE 0-9989
File Type	FILETYPE	*DATA
		*SAVE
		*SRC
Add seq/date field		*SAVF
Add seq/date field	SRCSEQ	NO or YES
Type of translation	TRANSLATE	TEXT or YES
		*DIF
		*BASICS
		*TAB
Translation file name		NO or NONE
Translation file name	TRNSFILE	TRANLATE
		MACTAB
Library name		file name
Library name		*LIBL
Member name	TRANSMBR	library name
Member name	TRANSMBR	*ATOE1
Truncate text	TRUNCATE	member name
Truncate text	TRUNCATE	*NO
DDS or F&I file name	FLDDEFFILE	*YES
DDS or F&I file name	FLDDEFFILE	NONE or DDS
Library name		file name
Library name		*LIBL
Member name	FLDDEFMBR	library name
Member name	FLDDEFMBR	*FILE
Qualified file name	QFNAME1	file name
Qualified file name	QFNAME1	micro file name
Save request definition?	SAVRQS	NO or YES
Request name	DSPSTSMSG	name of request
Display status message?	DSPSTSMSG	NO or YES

The TO3XB command transfers a micro file to the AS/400, and, optionally, translates the data. The data is translated according to the specified translation type and translation table. Four different types of translation can be selected: *DIF, *BASICS, *TAB, and *TEXT (see Chapter 4, Learning About ETU, for more information on each type), or *NONE for no translation.

NOTE: *DIF, *BASICS, and *TAB translations require that the fields in the IBM data file be defined in advance of the file transfer. The fields may be defined with data description specifications (DDS) associated with the data file, or with a source member created with standard RPG F and I specifications that describe the field layouts of the data file.

TOFILE The qualified file name of the AS/400 file into which the micro data is to be written.

Library The name of the library containing the TOFILE. The default is *LIBL. You must specify an existing library

ETU400 User Guide 011603

10-48

Image 178

Nlynx ETU400 manual TO3XB Command, Truncate, Flddeffile YES

Contents

ETU400 Definitions Permitted and Intended UsesProhibited Uses Limited Warranty Legal Notices NLynx Technologies, Inc. All rights reservedTrademark Recognition PrefaceWho Should Use This Guide? About This GuideHow This Guide is Organized 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 ChapterETU Function Security Profile Required Welcome to ETUWhat ETU Can Do for You QsecofrInventory Checklist Security ConsiderationsHardware Requirements Hardware and Software RequirementsSoftware 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 SystemEntering the Registration Code Re-installing ETUObtaining Your Host Registration Number Dspsysval sysvalqsrlnbrRemoving ETU From Your Host System Installing ETU For International UsersTechnical Support Copying Ibmtran To Your Hard Drive ETU Compatibility Diskette For Non-ES32 Emulation ProductsWho Could Use IBMTRAN? IBMTRAN.EXEAlternative Method to Start and Exit Ibmtran Starting ETU When Using IbmtranExiting Ibmtran IbmtranUsing ETU PC-DOSAbout This Chapter Starting ETU ETU Main Menu NlriscliffETU Utilities Menu ETU Commands Using the Menu Running ETU CommandsEntering Commands on the Command Line Using the Command Prompts Using Mac Directory Dialog BoxesRecalling ETU Commands Request DefinitionsTypes of Processing Interactive ETU CommandsBatch ETU Commands StrseuFile Formats About Microcomputer FilesApple Mac Learning about ETU About This Chapter Data Translation What is ETU?Data Transfer Other ETU FunctionsAbout Transferring Files Micro and Host File NamesRecord Length Transferring Data to Host FilesHost File Type 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 Tuples Tab format *TAB DIF format *DIFVectors DATA0,0Running ETU Transferring Files About This Chapter Transferring Data Files From Host to a Microcomputer Transferring Data FilesFROM3XB Example FROM3XB prompt screen Filetype*data srcseq*no translate*none TO3XB prompt screenTO3XB Example Transferring a Host Spool File to a PC Print File Transferring Print FilesAbout Host Spool Files 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 Translation Commands Can Be Run From a Host Terminal Why Use the Translation CommandsTranslation Commands Can Run in Batch Mode 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 Translating Print Files Translating PC Print Files Prtxfrmpc CommandPrtxfrmpc Example ETU400 User Guide Translating Host Spool Files Prtxtopc Command LastCopyprt Prtxtopc ExamplePrint2 Letter2Working with PC Functions ETU400 User Guide \data.pgm Rename a Micro File Renameb CommandRenameb Example Data1.pgmAlocatb Example Allocate a Micro File Alocatb Command\reports\sales.feb Delete an Existing File Deleteb Command Deleteb prompt screenDeleteb Example \report\fiscal.docTestb Example Test for the Existence of a Micro File Testb Command\datafile.doc Modifying Translation Tables About This Chapter About Translation Tables Modifying a Translation Table Editing the Translation Table Make a Copy of the Original TableTranslation Table Record Format To HEX Text DIF Basics TABPad Character Translate Before/AfterEnd-of-Record Action End-of-File Action CommentsOmit unprintable characters Sample Translation TableXBA PAD EOR EOF Comments Numeric CharactersCompiling the New Translation Member Naming the New MemberAdvanced ETU Features About This Chapter Transferring From Multiple Micros Multiple-device TransferQualified file name File Member nameMulti PRT2AD3Using PWRTO3XB Transferring a Host File to Multiple Micros FrmfilePcfrompc Command Micro-to-micro TransfersMICLST1 Pctopc Command QFNAME1Mac File Transfer Examples Transferring Files Between Multiple MacesTrainingTest If InterAxcess is one or more folders deep About Creating Auxiliary Storage Pools Record and Field SelectionTransferring Selected Fields Field name Key fieldField Selection -- Example Salary Employee name Field to be tested Transferring Selected RecordsRelationship 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 screenPcfrompc Batch Transfer ExampleQbatch Time and Date Scheduling Night Time and Date Scheduling ExampleEnter Command Reference ETU Command Reference Qfname Alocatb CommandParameter description Parameter name Parameter values DspstsmsgDeleteb Command NotifyPC-DOS Tables Edittable CommandMac Tables 10-5 Edtudf Command Edtudf Notes FROM3XB Command 10-9 10-10 FROM3XB Notes Strip*no, translate*noMICLIST1 Pcfrompc CommandMICLIST2 XXXXXXXX.XX Pctopc Command 10-15 PGM PGMFROM3XB CommandTgtrls Current PGMTO3XB Command Outq PRTFROM3X CommandET0A1 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 Jobd Sbmbatxfer CommandSbmcmdname UserprfSbmcmd Sbmschjob CommandBefore You Begin TodayTo Schedule a Job PC-DOS Members Strseu CommandSource file member name Mac Members10-46 Testb Command YESTruncate TO3XB CommandFlddeffile YES 10-49 10-50 10-51 Submit to batch Vwsavrqs CommandVwsavrqs Notes Change10-53 Jobd YES Xlatefrom CommandMBR DDS10-55 10-56 Pcdata Last Xlateto CommandJobd SRC 10-58 10-59 10-60 ETU Error Messages Creating DDS SpecificationsCreating F & I Specifications System/36-mode CommandsInside ETU Appendix aAbout This Chapter Editing User-defined Menu Options Edtudf Parameters ModeEdtudf Edtudf ExampleEdit User-defined Functions PmtConfiguring the Audit Trail Figure A-1 The Cfgaudit prompt screenCfgaudit Parameters Checking the Audit Trail Working with ETU Security Granting Authority to a CommandGrtobjaut Regranting Authority to a Previously Revoked Command Revoking Authority From a CommandRvkobjaut 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 ETU Using ETU 5.01 and above with Autokey Batch FilesModifying an Autokey Batch File Example 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 ETU36 Menu Starting ETU in System/36 ModeStrs36 ETU400 User Guide System/36-mode Commands and Native Mode Equivalents Running ETU in System/36 ModeNative Commands Not Supported in the System/36 Mode Menu ETU36, your ETU library nameAllocate Procedure ETU36 AllocateCompile Procedures Notify Delete ProcedureWorkstation file name Mac UsersEditable Procedure Basics TAB Filefrpc ProcedureText ATOE1 Save NoneReformat Record len1Retain Text or *YESTruncate Record len2Input specs Spec libText ETOA1 Filetopc ProcedureDate ETU400 User Guide Librfrpc Procedure YES DIFLib name Xlat sizeReplace Member type Add ctlFile size Library ALL Source Librtopc ProcedureProc PartallRemove ctl ETU400 User Guide Prntfrpc Procedure Width Spool name Prnttopc ProcedureProcedure QualifierETU400 User Guide Rename Function Testfile Procedure AS/400 label1 XLT36FIL ProcedureAS/400 label2 Performedthe default Function XLT36PRT ProcedureDate-1 From window Date-2To window Xltpcfil Procedure Basic Sequential format with Xltpcprt Procedure International Translation Tables Appendix HRstobj OBJSRCxx Savlibnewtable DEVdevice-name RSTLIByyyyyy Installing International Translation TableCountry 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? Batch processing AllocateAscii character set Data transferInteractive processing System/36 modeHost system Job queue