Xltpcfil Procedure, Text ATOE1 | Nlynx ETU400 instruction

XLTPCFIL Procedure

ETU36 XLTPCFIL, AS/400 label1,		date	,	AS/400 label2,		retain,
						J
reformat ,	xlate file		,	xlate size		T
reformat ,	xlate file		,	xlate size	, record len,
*TEXT	ATOE1			1000		128

date ,

truncate

YES

NO

*DIF	, xlat file ,	xlate size , input specs,
*BASICS		1000
*TAB
	spec lib
	clib

The XLTPCFIL procedure translates a previously transferred workstation data file into an AS/400 formatted data file.

AS/400 label1	is the name of workstation data file residing on the
	AS/400 that is to be reformatted for the AS/400.
date	(optional) is the date of the “AS/400 label1”
	file (YMD format).
AS/400 label2	is the label (name) of the file that will contain the
	results of the translation process. This name cannot
	already be on the AS/400 disk when this procedure is
	called.
retain	(optional) is the file retention (how long the file is
	to exist) for the translated file “AS/400 label2”.
	Allowed values are T or J. Specifying T results in the
	file existing indefinitely (until specifically
	deleted), and specifying J will result in the file
	being automatically deleted at the end of the current
	AS/400 job. The default value is T.

ETU400 User Guide 011603

G-31

Image 301

Nlynx ETU400 manual Xltpcfil Procedure, Text ATOE1

Contents

ETU400 Permitted and Intended Uses Definitions Prohibited Uses Limited Warranty NLynx Technologies, Inc. All rights reserved Legal Notices Preface Trademark Recognition Who Should Use This Guide? About This GuideHow This Guide is Organized 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 What ETU Can Do for You Welcome to ETUETU Function Security Profile Required Qsecofr Security Considerations Inventory Checklist Hardware Requirements Hardware and Software RequirementsSoftware 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 Obtaining Your Host Registration Number Re-installing ETUEntering the Registration Code Dspsysval sysvalqsrlnbr Removing ETU From Your Host System Installing ETU For International UsersTechnical Support Who Could Use IBMTRAN? ETU Compatibility Diskette For Non-ES32 Emulation ProductsCopying Ibmtran To Your Hard Drive IBMTRAN.EXE Exiting Ibmtran Starting ETU When Using IbmtranAlternative Method to Start and Exit Ibmtran Ibmtran PC-DOS Using ETU About This Chapter Starting ETU Nlriscliff ETU Main Menu ETU Utilities Menu ETU Commands Using the Menu Running ETU CommandsEntering Commands on the Command Line Using Mac Directory Dialog Boxes Using the Command Prompts Request Definitions Recalling ETU Commands Batch ETU Commands Interactive ETU CommandsTypes of Processing Strseu File Formats About Microcomputer FilesApple Mac Learning about ETU About This Chapter Data Transfer What is ETU?Data Translation Other ETU Functions Micro and Host File Names About Transferring Files Record Length Transferring Data to Host FilesHost File Type 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 Vectors Tab format *TAB DIF format *DIFTuples DATA0,0 Running ETU Transferring Files About This Chapter Transferring Data Files From Host to a Microcomputer Transferring Data FilesFROM3XB Example FROM3XB prompt screen TO3XB prompt screen Filetype*data srcseq*no translate*none TO3XB Example Transferring a Host Spool File to a PC Print File Transferring Print FilesAbout Host Spool Files 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 Can Run in Batch Mode Why Use the Translation CommandsTranslation Commands Can Be Run From a Host Terminal Translation Commands Reduce Modem Time 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 Translating Print Files Translating PC Print Files Prtxfrmpc CommandPrtxfrmpc Example ETU400 User Guide Last Translating Host Spool Files Prtxtopc Command Print2 Prtxtopc ExampleCopyprt Letter2 Working with PC Functions ETU400 User Guide Renameb Example Rename a Micro File Renameb Command\data.pgm Data1.pgm Alocatb Example Allocate a Micro File Alocatb Command\reports\sales.feb Deleteb prompt screen Delete an Existing File Deleteb Command \report\fiscal.doc Deleteb Example Testb 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 Text DIF Basics TAB To HEX Pad Character Translate Before/AfterEnd-of-Record Action Comments End-of-File Action XBA PAD EOR EOF Comments Sample Translation TableOmit unprintable characters Numeric Characters Naming the New Member Compiling the New Translation Member Advanced ETU Features About This Chapter Transferring From Multiple Micros Multiple-device TransferQualified file name Multi Member nameFile PRT2AD3 Using PWRTO3XB Frmfile Transferring a Host File to Multiple Micros Micro-to-micro Transfers Pcfrompc Command MICLST1 QFNAME1 Pctopc Command Mac 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 Key field Field name Field Selection -- Example Salary Employee name Relationship Transferring Selected RecordsField to be tested Relational operator 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 Pcfrompc Batch Transfer ExampleQbatch Time and Date Scheduling Night Time and Date Scheduling ExampleEnter Command Reference ETU Command Reference Parameter description Parameter name Parameter values Alocatb CommandQfname Dspstsmsg Notify Deleteb Command PC-DOS Tables Edittable CommandMac Tables 10-5 Edtudf Command Edtudf Notes FROM3XB Command 10-9 10-10 Strip*no, translate*no FROM3XB Notes MICLIST1 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 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 Sbmcmdname Sbmbatxfer CommandJobd Userprf Before You Begin Sbmschjob CommandSbmcmd Today To Schedule a Job Source file member name Strseu CommandPC-DOS Members Mac Members 10-46 YES Testb Command Truncate TO3XB CommandFlddeffile YES 10-49 10-50 10-51 Vwsavrqs Notes Vwsavrqs CommandSubmit to batch Change 10-53 MBR Xlatefrom CommandJobd YES DDS 10-55 10-56 Pcdata Last Xlateto CommandJobd SRC 10-58 10-59 10-60 Creating F & I Specifications Creating DDS SpecificationsETU Error Messages System/36-mode Commands Appendix a Inside ETU About This Chapter Editing User-defined Menu Options Mode Edtudf Parameters Edit User-defined Functions Edtudf ExampleEdtudf Pmt Figure A-1 The Cfgaudit prompt screen Configuring the Audit Trail Cfgaudit 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 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 Modifying an Autokey Batch File Example Using ETU 5.01 and above with Autokey Batch FilesETU ENT 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 ETU36 Menu Starting ETU in System/36 ModeStrs36 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 name ETU36 Allocate Allocate Procedure Compile Procedures Workstation file name Delete ProcedureNotify Mac Users Editable Procedure Text ATOE1 Filefrpc ProcedureBasics TAB Save None Retain Record len1Reformat Text or *YES Input specs Record len2Truncate Spec lib Text ETOA1 Filetopc ProcedureDate ETU400 User Guide YES DIF Librfrpc Procedure Lib name Xlat sizeReplace Member type Add ctlFile size Proc Librtopc ProcedureLibrary ALL Source Partall Remove ctl ETU400 User Guide Prntfrpc Procedure Width Procedure Prnttopc ProcedureSpool name Qualifier ETU400 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 Appendix H International Translation Tables Country Installing International Translation TableRstobj OBJSRCxx Savlibnewtable DEVdevice-name RSTLIByyyyyy Crttable SRCxx TRANLIBlibrary-name 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? Ascii character set AllocateBatch processing Data transfer Host system System/36 modeInteractive processing Job queue