Creating F & I Specifications | Nlynx ETU400 instruction

Creating F & I Specifications

In order to transfer tabular data, like that found in spreadsheets or data bases, you must create a template that tells the AS/400 where each field begins and ends, and what type of data will be in each field. This is done through the use of Format and Input (F&I) specifications or DDS specifications. See Appendix C for a detailed explanation of DDS specifications.

In this example you will see how to create F&I specs that allow a PC file to be transferred and properly formatted on the AS/400. The PC file is called SAMPLE and was created using a PC spreadsheet application. The PC spreadsheet file is represented in Figure D-1 shown below. This spreadsheet contains four fields. Table D-1, at the bottom of this page, describes how each field is defined.

Figure D-1 SAMPLE file created with PC spreadsheet
	A		B		C	D		E
1	Bart Simpson		President		45301	San Jose
2	Homer Simpson		Vice President		34500	Austin
3	Fred Flintstone		General Manager		57500	Denver
4	Cliff Anderson		Technical Support Manager		42300	Springfield
5	Tom Stiles		Customer Relations		32400	Los Angeles
6	Monica Martinez		Manager		24300	Buda
6	Monica Martinez		Office Manager		24300	Buda
7	Scott Haram		Director of Intelligence		00700	Chicago
8	Tom Williams		Sales Manager		43200	Dallas
9	Mr. Spock		Foreign Relations		23400	Vulcan
10	Dilbert Dill		Engineering Manager		42300	San Jose
11	Wally Findley		Marketing Manager		76700	Houston
12	Herman Munster		Software Engineer		66600	Waco
13	Cosmo Kramer		Personal Director		32100	New York
14	Harry Potter		Vice President		43200	London
15	Gandalf Wizard		Information Systems
16			Manager
16
17
18
19
20
21
Table D-1 Field definitions for file SAMPLE
Field Name		Field Length Field Type		Decimal Positions
NAME		17	Alphabetic	-
TITLE		36	Alphabetic	-
SALARY		7	Numeric	2
CITY		15	Alphabetic	-

ETU400 User Guide 011603

D-3

Image 226

Nlynx ETU400 manual Creating F & I Specifications, Field Name Field Length Field Type Decimal Positions

Contents

ETU400 Definitions Permitted and Intended Uses Prohibited Uses Limited Warranty Legal Notices NLynx Technologies, Inc. All rights reserved Trademark Recognition Preface Who Should Use This Guide? About This GuideHow This Guide is Organized Introduction Using ETU Transferring Files Modifying Translation Tables ETU Command Reference 10-1 Creating DDS Specifications Appendix D Creating F&I Specifications International Translation Tables Getting Started Introduction Chapter ETU Function Security Profile Required Welcome to ETUWhat ETU Can Do for You Qsecofr Inventory Checklist Security Considerations Hardware 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 Products Part One, Getting Started Installing ETU About This Chapter Installing ETU Installing the ETU Software ELIBNAMexisting-librarySVTRANLsave-translations Old versions, since most users do not modify these tables Using ETU During the Evaluation Period Registering Your Host System Entering the Registration Code Re-installing ETUObtaining Your Host Registration Number Dspsysval sysvalqsrlnbr Removing 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.EXE Alternative Method to Start and Exit Ibmtran Starting ETU When Using IbmtranExiting Ibmtran Ibmtran Using ETU PC-DOS About This Chapter Starting ETU ETU Main Menu Nlriscliff ETU Utilities Menu ETU Commands Using the Menu Running ETU CommandsEntering Commands on the Command Line Using the Command Prompts Using Mac Directory Dialog Boxes Recalling ETU Commands Request Definitions Types of Processing Interactive ETU CommandsBatch ETU Commands Strseu File Formats About Microcomputer FilesApple Mac Learning about ETU About This Chapter Data Translation What is ETU?Data Transfer Other ETU Functions About Transferring Files Micro and Host File Names Record Length Transferring Data to Host FilesHost File Type Data Description Specifications About Translating Files How Data is Stored Using Translation Tables Translate ETU Translation Table Members Using Translation Tables with the Mac Mactab FROM3XB Prttopc TO3XB Prtfrmpc PWRFROM3XB PWRTO3XB Using Microcomputer Data Formats Tuples Tab format *TAB DIF format *DIFVectors DATA0,0 Running 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 screen TO3XB Example Transferring a Host Spool File to a PC Print File Transferring Print FilesAbout Host Spool Files PRTFROM3X Example User1 PRTFROM3X Print Queue Screen Transferring a PC Print File to the Host ATOE3 PRTTO3X Example Transfer Host Programs to a Microcomputer PGMFROM3XB Command Transferring Host Programs PGMFROM3XB Example Beta1 Transfer Host Programs to the Host PGMTO3XB prompt screen PGMTO3XB Example Userpgm Translating 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 Time Translating Data Files Filetype*data, srcseq*no, translate*no Xlatefrom Example Rs132 Home1 Tab Translating a Host File to Microcomputer Format Strip*no translate*no Xlateto Example Translating Print Files Translating PC Print Files Prtxfrmpc CommandPrtxfrmpc Example ETU400 User Guide Translating Host Spool Files Prtxtopc Command Last Copyprt Prtxtopc ExamplePrint2 Letter2 Working with PC Functions ETU400 User Guide \data.pgm Rename a Micro File Renameb CommandRenameb Example Data1.pgm Alocatb Example Allocate a Micro File Alocatb Command\reports\sales.feb Delete an Existing File Deleteb Command Deleteb prompt screen Deleteb Example \report\fiscal.doc 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 To HEX Text DIF Basics TAB Pad Character Translate Before/AfterEnd-of-Record Action End-of-File Action Comments Omit unprintable characters Sample Translation TableXBA PAD EOR EOF Comments Numeric Characters Compiling the New Translation Member Naming the New Member Advanced ETU Features About This Chapter Transferring From Multiple Micros Multiple-device TransferQualified file name File Member nameMulti PRT2AD3 Using PWRTO3XB Transferring a Host File to Multiple Micros Frmfile Pcfrompc Command Micro-to-micro Transfers MICLST1 Pctopc Command QFNAME1 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 Field name Key field Field Selection -- Example Salary Employee name Field to be tested Transferring Selected RecordsRelationship Relational operator Record Selection -- Example1 Record Selection -- Example Entry and Exit Programs Example Deleting Files After Transfer Re-using Request Definitions Saving Request Definitions Execute Fold/Unfold Performing Batch Transfers Submit Batch Transfer prompt screen Pcfrompc 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 Dspstsmsg Deleteb Command Notify PC-DOS Tables Edittable CommandMac Tables 10-5 Edtudf Command Edtudf Notes FROM3XB Command 10-9 10-10 FROM3XB Notes Strip*no, translate*no 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 Prtxfrmpc Command Pcmbr LPI Library Prtxtopc Command 10-25 10-26 Pwrdeleteb Command Miclist Requester PWRFROM3XB Command Entrypgm Exitpgm 10-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 Userprf Sbmcmd Sbmschjob CommandBefore You Begin Today To Schedule a Job PC-DOS Members Strseu CommandSource file member name Mac Members 10-46 Testb Command YES Truncate TO3XB CommandFlddeffile YES 10-49 10-50 10-51 Submit to batch Vwsavrqs CommandVwsavrqs Notes Change 10-53 Jobd YES Xlatefrom CommandMBR DDS 10-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 Commands Inside ETU Appendix a About This Chapter Editing User-defined Menu Options Edtudf Parameters Mode Edtudf Edtudf ExampleEdit User-defined Functions Pmt Configuring the Audit Trail Figure A-1 The Cfgaudit prompt screen 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 Securing Devices on the AS/400 Unable to open display file with device specified Removing ETU From the AS/400 Rmvetu ETU Compatibility Appendix B About This Appendix ETU Using ETU 5.01 and above with Autokey Batch FilesModifying an Autokey Batch File Example ENT ETU Creating DDS Specifications Appendix C About This Appendix Creating DDS Specifications Field Name Field Length Field Type Decimal Positions 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 Creating F&I Specifications Appendix D 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 Error Messages Native Mode Appendix E 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 ASCII-EBCDIC Printable Characters Appendix F 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 System/36-mode Commands Appendix G About 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 name Allocate Procedure ETU36 Allocate Compile Procedures Notify Delete ProcedureWorkstation file name Mac Users Editable Procedure Basics TAB Filefrpc ProcedureText ATOE1 Save None Reformat Record len1Retain Text or *YES Truncate Record len2Input specs Spec lib Text ETOA1 Filetopc ProcedureDate ETU400 User Guide Librfrpc Procedure YES DIF Lib name Xlat sizeReplace Member type Add ctlFile size Library ALL Source Librtopc ProcedureProc Partall Remove ctl ETU400 User Guide Prntfrpc Procedure Width Spool name Prnttopc ProcedureProcedure 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 International Translation Tables Appendix H Rstobj OBJSRCxx Savlibnewtable DEVdevice-name RSTLIByyyyyy Installing International Translation TableCountry Crttable SRCxx TRANLIBlibrary-name ETU400 Automation Appendix Automation Mechanisms ETU400 User Guide ETU Throughput Considerations Appendix J What 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 transfer Interactive processing System/36 modeHost system Job queue