What other options are there to ETU? | Nlynx ETU400 instruction

QUESTION:

What other options are there to ETU?

ANSWER:

FTP (such as File Transfer Protocol, using TCP/IP) or Client Access/400.

QUESTION:

What are the pros and cons of using FTP?

ANSWER:

FTP is fairly easy to use.

FTP does not support EBCDIC to ASCII, or Comma Separated Values, Basic Sequential, or Differential translations. CSV is a comma delimited file where fields in a record is delimited by a comma (commas in the "data" must be quoted).

FTP is supplied as part of the system on OS/400 and Windows 2000.

QUESTION:

What are the pros and cons of using ClientAxcess/400?

ANSWER:

ClientAxcess/400 is an option that you get with your AS/400 whether you want it or not. IBM calls this free. It can be difficult to install. Does not support batch capability, not invokable from the host (must be initiated from the client) and cannot transfer spool files. CA/400 does support CSV, Basic Sequential, or Differential translation. There are two file systems in the AS/400. The original QSYS file system where you have libraries, files and members. And there is IFS (Integrated File System) which is basically a similar file system to Unix (and DOS in some ways). Once installed and configured properly, the drag and drop capabilities are easy to use.

By the way, our ES/TCP has IFS support built in.

QUESTION:

What are the pros and cons of using ETU400?

ANSWER:

ETU is menu-driven and easy to use.

ETU supports CSV translation Basic Sequential, or Differential translation.

ETU can do batch transfers. See http://www.nlynx.com/html/tb-etuauto.htm

If the user wants to create "canned" transfers (something that the MIS guy builds and made available for all to use) or batch driven (run at a scheduled time), ETU is a good choice.

If you are looking for blazing speed, or time is a factor and the transferred file is enormous, then ETU is not the fastest choice. There are ways to improve it by using FTP.

ETU400 User Guide 011603

J-3

Image 311

Nlynx ETU400 manual What other options are there to ETU?

Contents

ETU400 Permitted and Intended Uses Definitions Prohibited Uses Limited Warranty NLynx Technologies, Inc. All rights reserved Legal Notices Preface Trademark Recognition How This Guide is Organized About This GuideWho Should Use This Guide? 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 Qsecofr Welcome to ETUWhat ETU Can Do for You ETU Function Security Profile Required Security Considerations Inventory Checklist Software Requirements Hardware and Software RequirementsHardware 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 Dspsysval sysvalqsrlnbr Re-installing ETUObtaining Your Host Registration Number Entering the Registration Code Technical Support Installing ETU For International UsersRemoving ETU From Your Host System IBMTRAN.EXE ETU Compatibility Diskette For Non-ES32 Emulation ProductsWho Could Use IBMTRAN? Copying Ibmtran To Your Hard Drive Ibmtran Starting ETU When Using IbmtranExiting Ibmtran Alternative Method to Start and Exit Ibmtran PC-DOS Using ETU About This Chapter Starting ETU Nlriscliff ETU Main Menu ETU Utilities Menu ETU Commands Entering Commands on the Command Line Running ETU CommandsUsing the Menu Using Mac Directory Dialog Boxes Using the Command Prompts Request Definitions Recalling ETU Commands Strseu Interactive ETU CommandsBatch ETU Commands Types of Processing Apple Mac About Microcomputer FilesFile Formats Learning about ETU About This Chapter Other ETU Functions What is ETU?Data Transfer Data Translation Micro and Host File Names About Transferring Files Host File Type Transferring Data to Host FilesRecord Length 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 DATA0,0 Tab format *TAB DIF format *DIFVectors Tuples Running ETU Transferring Files About This Chapter FROM3XB Example Transferring Data FilesTransferring Data Files From Host to a Microcomputer FROM3XB prompt screen TO3XB prompt screen Filetype*data srcseq*no translate*none TO3XB Example About Host Spool Files Transferring Print FilesTransferring a Host Spool File to a PC Print File 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 Reduce Modem Time Why Use the Translation CommandsTranslation Commands Can Run in Batch Mode Translation Commands Can Be Run From a Host Terminal 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 Prtxfrmpc Example Translating PC Print Files Prtxfrmpc CommandTranslating Print Files ETU400 User Guide Last Translating Host Spool Files Prtxtopc Command Letter2 Prtxtopc ExamplePrint2 Copyprt Working with PC Functions ETU400 User Guide Data1.pgm Rename a Micro File Renameb CommandRenameb Example \data.pgm \reports\sales.feb Allocate a Micro File Alocatb CommandAlocatb Example Deleteb prompt screen Delete an Existing File Deleteb Command \report\fiscal.doc Deleteb Example \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 Text DIF Basics TAB To HEX End-of-Record Action Translate Before/AfterPad Character Comments End-of-File Action Numeric Characters Sample Translation TableXBA PAD EOR EOF Comments Omit unprintable characters Naming the New Member Compiling the New Translation Member Advanced ETU Features About This Chapter Qualified file name Multiple-device TransferTransferring From Multiple Micros PRT2AD3 Member nameMulti File Using PWRTO3XB Frmfile Transferring a Host File to Multiple Micros Micro-to-micro Transfers Pcfrompc Command MICLST1 QFNAME1 Pctopc Command TrainingTest 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 Key field Field name Field Selection -- Example Salary Employee name Relational operator Transferring Selected RecordsRelationship Field to be tested 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 Qbatch Batch Transfer ExamplePcfrompc Time and Date Scheduling Enter Time and Date Scheduling ExampleNight Command Reference ETU Command Reference Dspstsmsg Alocatb CommandParameter description Parameter name Parameter values Qfname Notify Deleteb Command Mac Tables Edittable CommandPC-DOS Tables 10-5 Edtudf Command Edtudf Notes FROM3XB Command 10-9 10-10 Strip*no, translate*no FROM3XB Notes MICLIST2 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 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 Userprf Sbmbatxfer CommandSbmcmdname Jobd Today Sbmschjob CommandBefore You Begin Sbmcmd To Schedule a Job Mac Members Strseu CommandSource file member name PC-DOS Members 10-46 YES Testb Command Flddeffile YES TO3XB CommandTruncate 10-49 10-50 10-51 Change Vwsavrqs CommandVwsavrqs Notes Submit to batch 10-53 DDS Xlatefrom CommandMBR Jobd YES 10-55 10-56 Jobd SRC Xlateto CommandPcdata Last 10-58 10-59 10-60 System/36-mode Commands Creating DDS SpecificationsCreating F & I Specifications ETU Error Messages Appendix a Inside ETU About This Chapter Editing User-defined Menu Options Mode Edtudf Parameters Pmt Edtudf ExampleEdit User-defined Functions Edtudf Figure A-1 The Cfgaudit prompt screen Configuring the Audit Trail Cfgaudit 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 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 ENT ETU Using ETU 5.01 and above with Autokey Batch FilesModifying an Autokey Batch File Example 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 Strs36 Starting ETU in System/36 ModeETU36 Menu ETU400 User Guide Menu ETU36, your ETU library name Running ETU in System/36 ModeNative Commands Not Supported in the System/36 Mode System/36-mode Commands and Native Mode Equivalents ETU36 Allocate Allocate Procedure Compile Procedures Mac Users Delete ProcedureWorkstation file name Notify Editable Procedure Save None Filefrpc ProcedureText ATOE1 Basics TAB Text or *YES Record len1Retain Reformat Spec lib Record len2Input specs Truncate Date Filetopc ProcedureText ETOA1 ETU400 User Guide YES DIF Librfrpc Procedure Replace Xlat sizeLib name File size Add ctlMember type Partall Librtopc ProcedureProc Library ALL Source Remove ctl ETU400 User Guide Prntfrpc Procedure Width Qualifier Prnttopc ProcedureProcedure Spool name ETU400 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 Appendix H International Translation Tables Crttable SRCxx TRANLIBlibrary-name Installing International Translation TableCountry Rstobj OBJSRCxx Savlibnewtable DEVdevice-name RSTLIByyyyyy 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? Data transfer AllocateAscii character set Batch processing Job queue System/36 modeHost system Interactive processing