Manuals / Nlynx / Computer Equipment / Network Card

Nlynx ETU400 manual Translating a Host File to Microcomputer Format, Stripno translateno

Models: ETU400

1 314

Download 314 pages 52.42 Kb

Page 82

Translating a Host File to Microcomputer Format:

The XLATETO command translates a AS/400 physical file to a format usable on the microcomputer. You will use this command prior to transferring the file to the PC with the FROM3XB command.

After you translate the data, you must enter the following FROM3XB parameters as shown:

strip(no) translate(no)

When the file is translated, it is written to a different host file, which you specify in the PCDATA parameter. The PCDATA file can be an existing file or a new file. For existing files, enter the names of the file and the member, for the RECL parameter, specify zero.

For new files, enter the file and member names (XLATETO will create these). If you are translating a source physical file, you can remove the first 12 bytes from each record (which contain the source sequence number and date field), by specifying *YES as the STRIP parameter.

If you are translating an ASCII file with a fixed record length, enter *FILE in the RECL parameter. This tells ETU to use the record length of the FRMFILE.

For more information on the FROM3XB command see Chapter 5, Transferring Files, and Chapter 10, ETU Command Reference.

Figure 6-2 The XLATETO prompt screen

Translate data to PC: (XLATETO)

Type choices, press Enter.
Host data	file name: .	. . . . .		Name
Library	name: . . .	. . . . .	*LIBL	Name, *LIBL
Host data	member name:	. . . . .	*FILE	Name, FILE, ALL, *FIRST...
PC data file for use by TOPC: .				Name
Library	name: . . .	. . . . .	*LIBL	Name, *LIBL
PCDATA member name: .		. . . . .	*FILE	Name, *FILE
Strip seq/date field?:		. . . . .	*NO	YES, NO
Type of translate: . .		. . . . .	*TEXT	TEXT, BASICS, DIF, TAB
Translation table file name: . .			TRANSLATE	Name, TRANSLATE, MACTAB
Library	name: . . .	. . . . .	*LIBL	Name, *LIBL
Translation table member name:			ETOA1	Name
Record length (0=existing): . .			*FILE	0-9989, *FILE
Job description: . . .		. . . . .		Name
Library	name: . . .	. . . . .	*LIBL	Name, *LIBL
Field translation definition: .			*DDS	Name, *DDS
Library	name: . . .	. . . . .	*LIBL	Name, *LIBL
				More...
F3=Exit	F4=Prompt	F5=Refresh	F12=Cancel	F13=How to use this display
F24=More keys

ETU400 User Guide 011603

6-7

Image 82

Nlynx ETU400 manual Translating a Host File to Microcomputer Format, Strip*no translate*no

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