Nlynx ETU400, User Manual

Page 1: ...i ETU400 User Guide AS 400FileTransferUtility...

Page 2: ...r refer to any person or entity that acquires or uses this Package Software means the computer programs contained in this Package together with all codes techniques software tools formats designs conc...

Page 3: ...n of the Software or use it for any purpose other than Your internal purposes Copy any portion of the Software except to make a backup copy or to transfer to a hard disk drive or other permanent stora...

Page 4: ...OSTS INCURRED IN CONNECTION WITH OBTAINING SUBSTITUTE SOFTWARE CLAIMS BY OTHERS INCONVENIENCE OR SIMILAR COSTS C NLYNX IS NOT LIABLE FOR ANY DAMAGES TO YOU OR ANY OTHER PERSON IN EXCESS OF THE PRICE Y...

Page 5: ...ed trademark and Windows is a registered trademark of Microsoft Corporation IBM is a registered trademark and AS 400 is a registered trademark of International Business Machines corporation January 20...

Page 6: ...SC 21 9620 AS 400 Security Concepts and Planning SC21 8083 AS 400 SEU User s Guide Reference SC09 1172 Trademark Recognition Throughout this manual the terms IBM IBM PC IBM PC XT IBM PC AT IBM PS 2 A...

Page 7: ...ed for all users of ETU and should be read prior to installation It lists the items you should have received with ETU the host and microcomputer hardware and software requirements for running ETU and...

Page 8: ...c Users 1 8 Compatibility with Non ES32 Emulation Products 1 8 Native Mode and System 36 Mode 1 8 Part One Getting Started 1 9 INSTALLING ETU 2 1 About This Chapter 2 2 Installing ETU 2 3 Installing t...

Page 9: ...ing Mac Directory Dialog Boxes 3 8 Request Definitions 3 9 Types of Processing 3 10 Interactive ETU Commands 3 10 Batch ETU Commands 3 10 About Microcomputer Files 3 11 File Formats 3 11 PC DOS 3 11 A...

Page 10: ...ransfer Host Programs to a Microcomputer 5 12 The PGMFROM3XB Command 5 12 PGMFROM3XB Example 5 13 Transfer Host Programs to the Host 5 14 TRANSLATING FILES 6 1 About This Chapter 6 2 Why Use the Trans...

Page 11: ...he New Member 8 10 ADVANCED ETU FEATURES 9 1 About This Chapter 9 2 Multiple device Transfer 9 3 Transferring From Multiple Micros 9 3 Using PWRTO3XB 9 5 Transferring a Host File to Multiple Micros 9...

Page 12: ...10 4 EDTUDF Command 10 6 EDTUDF Notes 10 7 FROM3XB Command 10 8 FROM3XB Notes 10 11 PCFROMPC Command 10 12 PCTOPC Command 10 14 PGMFROM3XB Command 10 16 PGMTO3XB Command 10 17 PRTFROM3X Command 10 18...

Page 13: ...endix A A 1 INSIDE ETU A 1 About This Chapter A 2 Editing User defined Menu Options A 3 EDTUDF Parameters A 4 EDTUDF Example A 5 Configuring the Audit Trail A 6 The CFGAUDIT Parameters A 7 Checking th...

Page 14: ...BCDIC PRINTABLE CHARACTERS F 1 About This Appendix F 2 This appendix lists the ASCII and EBCDIC characters and their hexadecimal equivalents Use this table when you create or modify an ETU translation...

Page 15: ...6 XLT36FIL Procedure G 27 XLT36PRT Procedure G 29 XLTPCFIL Procedure G 31 XLTPCPRT Procedure G 33 Appendix H H 1 INTERNATIONAL TRANSLATION TABLES H 1 Installing International Translation Table H 2 App...

Page 16: ...rted is intended for all users of ETU It describes how to install and how to use ETU If you are new to ETU you will be introduced to concepts and terms that will help you master it 2 1 Installing ETU...

Page 17: ...Can Do For You Inventory Checklist Security Considerations Hardware and Software Requirements Hardware Requirements Software Requirements Features of Versions Notes to Mac Users Compatibility with Non...

Page 18: ...omputer of the same type Transfer user specified fields or records between the host and the microcomputer Transfer a single host file to as many as ten microcomputers with one command Translate files...

Page 19: ...system security officer QSECOFR The security level associated with each function may be changed to allow more users access to or to limit the number of user for a particular ETU function Table 1 1 lis...

Page 20: ...r higher Source Entry Utility SEU NOTE You must specify if your machine is a CISC or RISC version Each PC requires Windows 32 bit operating systems Win95 Win98 SE ME XP or 2000 One of the NLynx Techno...

Page 21: ...ers However the latest version of OS 400 allows a column width of only 378 A new translation table is included ETU 400 contains a new translation table for host to PC file EBCDIC to ASCII file transla...

Page 22: ...RISC 5 04 required IBM PTF SP36296 to be installed on the AS 400 prior to the installation of the ETU RISC CD ROM On OS 400 V3R7 the handling of Optical Files OPTFILE on the Restore Object RSTOBJ OS...

Page 23: ...lems that were occurring with spreadsheet data 3 Transfer commands with DIF file translation would replace a one quote embedded in the data stream with two quotes for the commands that were missed whe...

Page 24: ...disk with a program called IBMTRAN that enabled any emulation to work This software only works with other DOS software using serial COM ports IBMTRAN was never ported to the Windows environment IBMTR...

Page 25: ...ETU400 User Guide 011603 1 9 Part One Getting Started Getting Started is intended for all users of ETU It describes how to use 2 1 Installing ETU 3 1 Using ETU 4 1 Learning About ETU...

Page 26: ...pleting the Host Registration Procedure Re installing ETU Removing ETU From Your Host System Installing ETU For International Users The ETU Compatibility Diskette For DOS only Non ES32 Emulation Produ...

Page 27: ...tem administrator or other experienced host user responsible for installing the ETU software on the AS 400 This chapter explains how to install the ETU software how to register ETU with NLynx Technolo...

Page 28: ...s are saved to the target library The installation procedure attempts to apply any command authorities from the existing library into the target library In addition you have the option of retaining yo...

Page 29: ...enter the ETU installation procedure Type ETUINSTALL TLIBNAM target library DEVNAM device name ELIBNAM existing library SVTRANL save translations where target library is the library in which ETU will...

Page 30: ...ETU400 User Guide 011603 2 5 old versions since most users do not modify these tables...

Page 31: ...o end of file character After you change the source be sure to run the EDITTABLE command Registering Your Host System ETU 400 is licensed to be installed on a single host system and may be run on only...

Page 32: ...15 U S phone 888 NLynx67 European phone 44 161 928 7014 We will phone or FAX your host registration number to you Entering the Registration Code Once you receive your host registration number you can...

Page 33: ...stem that supports a language other than U S English you may need to install the foreign language translation table appropriate for your language To install foreign language tables see Appendix H Inte...

Page 34: ...ome emulation products such as protocol converters have their own ETU interface programs If your emulation package includes a program specified as an interface to ETU you should use that program inste...

Page 35: ...n 4 After the program loads it automatically hotkeys back to emulation You can now run any ETU command Exiting IBMTRAN After you load IBMTRAN on your PC it remains in memory until you unload it To exi...

Page 36: ...Menu Microcomputer Commands Utilities Menu File Translation Commands Utilities Menu Translation Table Commands Running ETU Commands Using the Menu Entering Commands on the Command Line Using the Comma...

Page 37: ...rs of ETU It covers the basics of running ETU in native mode on the AS 400 In this chapter you will learn how to start ETU how to use the ETU menu how to enter ETU commands about using ETU with PC or...

Page 38: ...d on the AS 400 command line wsmenus NOTE The AS 400 library containing ETU must be in your library list When the ETU menu displays you can execute any ETU command provided you have proper authorizati...

Page 39: ...functions have been added the right side of the menu is blank as it appears below in Figure 3 1 For information on adding user defined functions to the Main menu see the command EDTUDF edit user defi...

Page 40: ...enu select option 20 from the ETU Main menu Figure 3 2 The ETU Utilities Menu Menu WSMENUS Emulator Transfer Utility AS 400 NLRISC NLRISCLIFF COPYRIGHT C 1998 NLynx Systems ETU Utilities Menu PC Funct...

Page 41: ...ed in Chapter 9 Advanced ETU Features Option 1 PWRFROM3XB Option 2 PWRTO3XB Option 3 PCFROMPC Option 4 PCTOPC Utilities Menu Microcomputer Commands These commands allow you to work with micro files wh...

Page 42: ...e information about that command For example to transfer a file from the workstation to the host using the TO3XB command enter TO3XB on the command line and press F4 This displays the TO3XB prompt scr...

Page 43: ...xt to the parameter keyword the parameter can be extended for additional values To enter the additional values place the cursor next to for more enter a plus sign and press ENTER When you have filled...

Page 44: ...to run a command For example if you transfer a file from the host to the micro using the FROM3XB command the request definition is the summation of the values you entered for each parameter The comman...

Page 45: ...u must run these commands from the microcomputer that you are sending the file to or receiving it from The power commands can be initiated from any AS 400 display The source or target device specified...

Page 46: ...w Refer to the user guide for your microcomputer s operating system for additional information PC DOS Format drive pathname micro_file_name ext Example C SUBDIR1 EXAMPLE TXT where drive is C pathname...

Page 47: ...ETU Functions About Transferring Files Micro and Host File Names Transferring Data to Host Files Record Length Host File Type Data Description Specifications About Translating Files How Data is Stored...

Page 48: ...ETU and is intended for beginning users It explains how data is stored on the host and the microcomputer and how ETU makes it possible to transfer data between the two systems The information you prov...

Page 49: ...have data translation take place over the phone line the data can be translated more efficiently on the host system For example if you are transferring a file from the host to a remote micro you can f...

Page 50: ...es of the host file and the micro file you want to transfer or translate You should be familiar with the following file name parameters Qualified file name The name of the micro file you are transferr...

Page 51: ...files defined with DDS specifications the record length should be zero the default Host File Type When you transfer a file to the host from the micro with the TO3XB or PWRTO3XB commands ETU will crea...

Page 52: ...he same DDS specifications be sure to use different file names when creating the physical files The DDS definition is stored as a member within a source physical file When you are transferring data to...

Page 53: ...ords Field definitions are usually maintained external to the file Data is stored in an EBCDIC character set On the PC Files are stored in fixed or variable length records Multiple field definition fo...

Page 54: ...PC or a Mac ETU comes with seven translation tables four for PC DOS translations and three for Mac translations The translation tables are actually members within two files All translation tables for...

Page 55: ...the end of each record Trailing blanks are not stripped May be suitable for postal IRS or banking applications ATOE1 The ASCII to EBCDIC PC DOS fixed and variable length translation member ATOE3 The A...

Page 56: ...Type of translate TEXT NO TEXT DIF BASICS Translation table file name TRANSLATE Name TRANSLATE MACTAB Library name LIBL Name LIBL Member name ETOA1 Name Record length 0 existing FILE 0 9989 FILE DDS o...

Page 57: ...TU400 User Guide 011603 4 11 Table 4 2 ETU Commands in which the translation table file name is optional ETU Command ETU Main Menu Option FROM3XB 1 PRTTOPC 3 TO3XB 4 PRTFRMPC 6 PWRFROM3XB 7 PWRTO3XB 8...

Page 58: ...the data to be used on the host To specify a translation type enter the appropriate value at the TRANSLATE parameter in any of the file transfer commands To transfer a file between the host and a mic...

Page 59: ...fields and records Data in a DIF file looks similar to that shown below Table 4 5 Example of a DIF data file TABLE 0 1 VECTORS 0 0006 TUPLES 0 000000012 DATA0 0 1 0 NOTE Most micro applications provid...

Page 60: ...ended for all users of ETU It introduces each ETU command and describes how to use the commands An example of how to use each command is also provided Transferring Files Translating Files Working with...

Page 61: ...to a Host The TO3XB Command TO3XB Example Transferring Print Files Transferring a Host Spool File to a PC Print File The PRTFROM3X Command PRTFROM3X Example Transferring a PC Print File to a Host The...

Page 62: ...ms For each file type ETU has one command that transfers a host object to a microcomputer and another command that transfers a microcomputer object to the host The commands described in this chapter a...

Page 63: ...lation command XLATETO prior to using FROM3XB If you translate the file with the XLATETO command you must specify TRANSLATE NONE in the FROM3XB command See Chapter 4 Learning About ETU for details abo...

Page 64: ...NTER to start the command Figure 5 1 The FROM3XB prompt screen Transfer from 3X FROM3XB Type choices press Enter File name Name Library name LIBL Name LIBL Member name FILE Name FILE FIRST LAST SAVE f...

Page 65: ...peration ETU uses the existing file definition For more information about file definitions see Chapter 4 Learning About ETU If you prefer not to have the data translated during the TO3XB operation you...

Page 66: ...or the File type because the host file being created with this command is a physical file 5 Use the translation type that translates BASIC Sequential files At the Type of translate prompt enter basics...

Page 67: ...ues waiting to be released to a printer They are stored in a format that is recognizable only to a host printer Before you can transfer a spool file to a PC it must be changed into a physical file wit...

Page 68: ...eue prompt user1 Use LIBL for the Output queue library name 3 Use the defaults for the translation table file and member names TRANSLATE and ETOA1 respectively Once you have entered the appropriate in...

Page 69: ...CP QTLPD11518 RDY 1 1 STD 5 QPJOBLOG QPGMR QSTRUPJD RDY 6 1 STD 5 QPJOBLOG QSYS QWCBTCLNUP RDY 1 1 STD 5 QPJOBLOG QSYS QWCBTCLNUP RDY 1 1 STD 5 QPJOBLOG QPGMR QDB2MULTI RDY 1 1 STD 5 F3 Exit F5 Redisp...

Page 70: ...on it by entering YES in the HOLD parameter NOTE Always use the translation table member ATOE3 in file TRANSLATE with this command This table transfers print files from ASCII to EBCDIC Figure 5 6 The...

Page 71: ...se the defaults for all other parameters 1 Choose option 6 from the ETU Main menu The PRTTO3X screen displays 2 Enter the name of the PC file at the Qualified file name prompt a report prt 3 Enter the...

Page 72: ...not transfer it back to the AS 400 using ETU 5 02 or later NOTE Do not use these commands to transfer host source code To transfer source code use the FROM3XB and TO3XB commands Transfer Host Programs...

Page 73: ...on the AS 400 that you want to transfer to the micro The host program is called BETA1 and is in the USER library You will transfer it to a PC file called a beta1 pgm 1 Choose option 2 from the ETU Mai...

Page 74: ...nformation and asked to delete the existing program or cancel the transfer request No translation is necessary when you use this command That s because the program you are transferring from the micro...

Page 75: ...nto a PC attached by emulation to the second host and start ETU The file on the PC is called a beta1 pgm You will transfer it to a file on the host called USERPGM in the QGPL library 1 Choose option 5...

Page 76: ...al Translation Commands Reduce Connection Time Translating Data Files Translating a Microcomputer File to a Host Format The XLATEFROM Command XLATEFROM Example Translating a Host File to Microcomputer...

Page 77: ...h NONE as the translation type XLATETO Translates a host physical file to ASCII You can then transfer the file to the micro using the FROM3XB command with NONE as the translation type PRTXFRMPC Transl...

Page 78: ...ly This means that while the host is processing the ETU command your host session is tied up and can t be used By specifying no translation when you transfer a file you reduce the amount of time it ta...

Page 79: ...as been received from the micro with the TO3XB command You can use XLATEFROM only if the TO3XB parameters were coded as shown filetype data srcseq no translate no For more information on the TO3XB com...

Page 80: ...lays 2 Choose option 10 from the ETU Utilities menu The XLATEFROM screen displays 3 At the PC data file prompt enter the name of the file to be translated rs132 Figure 6 1 The XLATEFROM prompt screen...

Page 81: ...e1 5 Use the defaults for the parameters PC member and Host output file 6 At the Type of translate prompt enter the translation type tab 7 Enter the name of the translation table for ASCII to EBCDIC t...

Page 82: ...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 F...

Page 83: ...plays 2 Choose option 8 from the ETU Utilities menu The XLATETO screen displays 3 At the Host data file name prompt enter the name of the file to be translated lot14 4 At the PC data file prompt enter...

Page 84: ...nts when it reaches the top of the queue unless you enter YES in the HOLD parameter In that case the file remains in the output queue until you release it manually To run the PRTXFRMPC command supply...

Page 85: ...rameters associated with this command 1 Choose option 20 from the ETU Main menu The ETU Utilities menu displays 2 Choose option 11 from the ETU Utilities menu The PRTXFRMPC screen displays 3 At the PC...

Page 86: ...r on the PRTXTOPC prompt screen To run CPYSPLF within the PRTXTOPC command enter COPYPRT in the ACTION parameter Figure 6 4 The PRTXTPC prompt screen Copyprt spool file PC XLT PRTXTOPC Type choices pr...

Page 87: ...menu The PRTXTOPC screen displays 3 At the PC data prompt enter the name of the file to which the host spool file will be translated print2 4 At the Action to perform prompt enter the type of translat...

Page 88: ...About This Chapter Rename a Micro File The RENAMEB Command RENAMEB Example Allocate a Micro File The ALOCATB Command ALOCATB Example Delete an Existing File The DELETEB Command DELETEB Example Test Fo...

Page 89: ...s while you are running emulation They eliminate the need for you to return to the PC or Mac environment to create or delete a file Four commands are discussed in this chapter The commands and their f...

Page 90: ...Choose option 20 from the ETU Main menu The ETU Utilities menu displays 2 Choose option 2 from the ETU Utilities menu The RENAMEB prompt screen displays 3 Enter the micro file name at the Qualified f...

Page 91: ...The ETU Utilities menu displays 2 Choose option 1 from the ETU Utilities menu The ALOCATB prompt screen displays 3 At the Qualified file name prompt enter the name for the micro file you want to crea...

Page 92: ...it doesn t find the file you want to delete Enter NO at the NOTIFY prompt if you don t want ETU to notify you NOTE When you use the DELETEB command all data in the designated micro file will be perma...

Page 93: ...displays 2 Choose option 3 from the ETU Utilities menu The DELETEB prompt screen displays 3 At the Qualified file name prompt enter the name of the micro file you want to delete a report fiscal doc 4...

Page 94: ...lled c datafile doc 1 Choose option 20 from the ETU Main menu The ETU Utilities menu displays 2 Choose option 4 from the ETU Utilities menu 3 At the Qualified file name prompt enter the name of the fi...

Page 95: ...ES About This Chapter About Translation Tables Modifying a Translation Table Make a Copy of the Original Table Editing the Translation Table Translation Table Record Format Sample Translation Table Co...

Page 96: ...our needs you can modify an existing table This chapter explains how to modify a translation table and how to use the modified table to translate data This chapter is intended only for advanced users...

Page 97: ...rce file TRANSSRC ETOA1 The EBCDIC to ASCII character translation member producing a variable length record with carriage return and line feed added after the last byte of data in each record Trailing...

Page 98: ...t process First make a copy of the source member containing the translation table you want to modify This step keeps the original tables intact Next edit the translation table In this step you will ch...

Page 99: ...displays you can edit the source member using any of the normal SEU commands For information on using SEU see the IBM manual AS 400 SEU User s Guide Reference SC09 1172 After you have made the appropr...

Page 100: ...ter When found it replaces the data with the TO HEX characters if any Consult Appendix A for hexadecimal values for both ASCII and EBCDIC character sets Hexadecimal data uses the characters 0 through...

Page 101: ...F sequence is found in a TO3XB translation An example of the source statement for this is FROM HEX XBA EOR Comment 0D0A B Y If CR LF then pad and write Pad Character Contains the value B for blank hex...

Page 102: ...the remainder of the input record being processed contains only the character specified in the TO HEX field of the TRAIL statement EOF statement This statement defines the action to be taken upon end...

Page 103: ...1 in the file TRANSSRC in the library containing ETU It can be printed with the Source Entry Utility Figure 8 4 Sample ASCII to EBCDIC Translation Table FROM HEX TO HEX XBA PAD EOR EOF Comments 01 Omi...

Page 104: ...default for the translation file is always TRANSLATE The default for the member name depends on the ETU command being used If you fail to take into account the default names when you name the new phy...

Page 105: ...InterAxcess is located at the root level of the hard drive If InterAxcess is one or more folders deep Record and File Selection About Creating Auxiliary Storage Pools Transferring Selected Fields Fie...

Page 106: ...xit program support Executes user defined programs within the context of the power command File deletion Deletes a file on the source system after that file is transferred to the target system Savable...

Page 107: ...mmands in batch mode NOTE To transfer a file to or from multiple devices you must be authorized to use each device specified in the transfer In addition each device must be powered on have emulation l...

Page 108: ...name MULTI The member names will be the same as the device names from which the file was transferred To store the files in one physical file with a single member specify the following parameters as s...

Page 109: ...g convention any files sent in a second file transfer from the same named micros to the same host library will end up with exactly the same names as the files sent in the first transfer device 1 devic...

Page 110: ...the file on the micro to which to transfer the file Any path name you enter must already exist on the micro ETU does not create subdirectories MICLIST The device name of the target micro The default...

Page 111: ...m multiple micros to the same destination directory using PCFROMPC you must rename any files sent in a first transfer before performing a second transfer This procedure is necessary because when files...

Page 112: ...ce names Each device you transfer from must be powered on have emulation loaded and have the AS 400 sign on screen displayed MICLST2 The device name of the target micro The default REQUESTER transfers...

Page 113: ...ich the PCTOPC command is currently being run To transfer a file from a different micro enter the device name of the micro You must be authorized to use the device you specify in this parameter or the...

Page 114: ...r Examples In the two examples below assume the following you are using the PCTOPC command described on page 10 14 to transfer a file named Test from your Mac to two other Maces Test resides in a fold...

Page 115: ...as you normally would taking special care with the qualified pathname as described in step 3 3 For the qualified pathname enter Training Test The colons before Training represent the following The fir...

Page 116: ...he library QTEMP which is always located in Auxiliary Storage Pool 1 which comes with OS 400 If you create an additional Auxiliary Storage Pool ETU cannot create the work files associated with the dat...

Page 117: ...ld is to be a key field The default NONE does not re sort the records but rather leaves them in sequential order The field does not have to be an existing key field in the file The total of the key fi...

Page 118: ...ne number fields in the order shown above follow these steps 1 Enter the file transfer and translation information as you would with any file transfer 2 Enter a plus sign next to the FLDSEL parameter...

Page 119: ...Stiles 30 000 Brandybuck 65 000 Dilbert 75 000 Wally 80 000 Martinez 90 000 Haram 100 000 Simpson 1 Enter the file transfer and translation information as you would with any file transfer 2 In the FLD...

Page 120: ...ship Relates one test case to another The first test case must use IF The default NONE transfers all records in the file The other relationships are AND OR ANDIF ORIF and are used in situations where...

Page 121: ...uses the same employee file as in the other examples Suppose you want to transfer a file from the host to a PC You will transfer only the records that meet the following set of criteria the value in t...

Page 122: ...able to run in batch Example Suppose you have a payroll file on the host that you want to transfer to a PC Before you transfer the file you want to update it with current payroll information by runni...

Page 123: ...in the PWRFROM3XB command the host file you are transferring to the micro is deleted after the transfer occurs If you do not have the authorization to delete files on the host or if there are logical...

Page 124: ...sfer the file Re using Request Definitions Once you have saved a request definition you can re use it at any time with the ETU command VWSAVRQS view saved requests Using this command you can run the s...

Page 125: ...ge the saved request 4 Delete Deletes the specified request 5 Extended view Displays an extended view of the request Only 45 characters can be displayed on the screen If the saved request is longer th...

Page 126: ...display F24 More keys SBMCMDNAM The name of the ETU command you want to submit to batch Enter PCFROMPC PCTOPC PWRFROM3XB or PWRTO3XB JOBNAME The name of the job you are submitting to batch The defaul...

Page 127: ...ubmit the command to run in batch mode using the SBMBATXFER command The file you will transfer is called a test2 doc and is on a PC whose device name is PRT3AD3 You will transfer the file to another P...

Page 128: ...TODAY 000000 999999 TODAY 1 Job name JOBD Name JOBD Job description QBATCH Name Library name LIBL Name LIBL Bottom F3 Exit F4 Prompt F5 Refresh F12 Cancel F13 How to use this display F24 More keys At...

Page 129: ...nd you want to schedule pwrfrom3xb 4 Enter the time that the job will be released to the job queue for the hour 22 for the minute 30 This will release the job at 10 30 p m 5 Since you want the job to...

Page 130: ...ide 011603 9 26 Part Three CommandReference Command Reference is an alphabetical presentation of al AS 400 native mode ETU commands and the parameters and values associated with each command 10 1 Comm...

Page 131: ...mand PCTOPC Command PGMFROM3XB Command PGMTO3XB Command PRTFRO3XB Command PRTTO3XB Command PRTXFROMPC Command PRTXTOPC Command PWRDELETEB Command PWRFROM3XB Command PWRRENAMEB Command PWRTO3XB Command...

Page 132: ...status message DSPSTSMSG YES or NO The ALOCATB command allocates creates an empty file on the micro QFNAME The name of the micro file to be allocated For additional information see About Microcomputer...

Page 133: ...e to be deleted For additional information See About Microcomputer Files in Chapter 3 NOTIFY Specifies whether you will be notified if the file to be deleted is not found This is done by sending a mes...

Page 134: ...anslation SRCMBR The name of the source member containing the translation table The following translate table members are provided with ETU PC DOS Tables ETOA1 EBCDIC to ASCII variable length records...

Page 135: ...also shipped in a translate file called MACTAB The members in this file do not have the M at the end of the name for example ATOE1 Library The name of the library containing the TRANSFILE LIBL is a v...

Page 136: ...ted adding the user defined option press F3 to return to the main menu NOTE In order for the new menu option to display on the ETU Main menu you must exit the ETU menu press F3 and redisplay the ETU m...

Page 137: ...F9 function key While in change mode you can change or delete a user defined function or display an extended view of an existing user defined function To change a user defined function enter 1 next to...

Page 138: ...inition SAVRQS NO or YES Request name name of request Display status message DSPSTSMSG NO or YES The FROM3XB command transfers data from an AS 400 physical or logical file member to a file on the micr...

Page 139: ...cord the default YES Strip off ignore the first 12 bytes TRANSLATE Determines whether the data is to be translated and if so what type of translation is to be performed TEXT or YES The AS 400 file is...

Page 140: ...file containing either physical file data description specifications DDS or file and input F I specifications If the file being transferred was previously defined with either DDS or F I specification...

Page 141: ...ranslated data into a workfile that is created for this purpose PCTTOWORK in QTEMP It is this workfile that will then be transferred to the micro If the sequence number and date fields like those of a...

Page 142: ...ransferring Files With PCFROMPC and PWRTO3XB in Chapter 9 in order to minimize the risk of copying over previously transferred files QFNAME1 The name of the micro file to be transferred If you are tra...

Page 143: ...sferred files To avoid this situation change the name of the files once they are received on the target micro or copy them to a different directory NOTE This parameter must be changed from REQUESTER t...

Page 144: ...be authorized to use the device you specify in this parameter or the transfer will fail NOTE This parameter must be changed from REQUESTER to the device name of the source micro when you run the PCTO...

Page 145: ...ETU400 User Guide 011603 10 15 DSPSTSMSG Displays program status messages during the execution of the command The default is YES To turn the messages off enter NO...

Page 146: ...CMATPG QFNAME1 The name of the micro file to contain the AS 400 program For additional information see About Microcomputer Files in Chapter 3 PGM The qualified name of the AS 400 executable program to...

Page 147: ...sfer source code with the FROM3XB PWRFROM3XB TO3XB or PWRTO3XB command NOTE To use this command you must be signed on as a security officer or be authorized to execute the program QSCMATPG QFNAME1 The...

Page 148: ...400 command CPYSPLF translates the file for the micro and stores it in the AS 400 file which you specify on the TRANSLATE prompt screen see Figure 10 1 on the following page You will then transfer th...

Page 149: ...F12 Cancel F13 How to use this display F24 More keys The screen you get with 1 Copyprt Figure 10 2 The PRTFROM3X Transfer prompt screen Transfer from 3X FROM3XB Type choices press Enter File name PCPR...

Page 150: ...s PC DOS print files from the PC to the AS 400 and adds them to the AS 400 print queue Mac Users Do not run this procedure It is intended for use only with PC DOS QFNAME1 The name of the micro file to...

Page 151: ...ecifies whether the print file should automatically start and print the job at the completion of the translation transfer NO The print file will start immediately upon termination of this command the...

Page 152: ...anslation table member name TRANSMBR ATOE3 member name The PRTXFRMPC is a batch mode command that translates PC DOS print files that were previously transferred from the PC by the TO3XB command The pr...

Page 153: ...label to associate with the new print job being added to the print queue OUTQ The default is STD COPIES The number of copies of the new print job to print The default is 1 HOLD Specifies whether the p...

Page 154: ...NONE Lines per page LINES 066 line number Begin translation in which column FROM 001 column number End translation in which column TO 132 column number Translation table file name TRANSFILE TRANSLATE...

Page 155: ...name LAST is the default ONLY Copies the spooled output file from the job when only one has the specified file name JOB Valid only on ACTION COPYPRT the name of the job that created the spooled output...

Page 156: ...either sensitive data or data that has no meaning for the current task The specified value must be in the range of 1 to 198 The default TO column is 132 TRANSFILE The qualified file name of the trans...

Page 157: ...The PWRDELETEB parameters are described below QFNAME The name of the micro file to be deleted MICLST The device name of the micro that contains the file to be deleted REQUESTER Deletes the file from t...

Page 158: ...ion TRANSLATE TEXT or YES NO or NONE DIF BASICS TAB Save request definition SAVRQS NO or YES Request name name of request Translation file name TRNSFILE TRANLATE MACTAB file name Library name LIBL lib...

Page 159: ...reuse at a later time SAVRQS NOTE The record and field selection feature within the PWRFROM3XB command will not work properly if you define one or more additional Auxiliary Storage Pools on the AS 400...

Page 160: ...te the file specify YES The use of this parameter is dependent on the user s authority to the host file SAVTYP Must be used to transfer files that were previously transferred to the host with the SAVE...

Page 161: ...f the name for example ETOA1M The Mac translation members are also shipped in a file called MACTAB The members in this file do not have the M at the end of the name for example ETOA1 Library name The...

Page 162: ...he file after the file is transferred to the micro The default NONE does not re sort the records but leaves them in sequential order Valid Key Field values are KEY1 KEY2 KEY3 up to KEY25 For the field...

Page 163: ...e to which to compare the data in the field Enter numeric values for numeric fields alphabetic values for alphabetic fields Enclose alphabetic fields in single quotation marks NOTE For Saved Requests...

Page 164: ...cro in emulation mode or from a dumb terminal You can also run this command in batch mode The PWRRENAMEB parameters are described below QFNAME The name of the micro file to be renamed NEWFIL The new n...

Page 165: ...ELACE ADD File Type FILETYPE DATA SAVE SRC SAVF Add seq date field SRCSEQ NO or YES Truncate text TRUNCATE NO or YES Delete micro file after transfer DLTFILE NO or YES Save request definition SAVRQS N...

Page 166: ...on see About Microcomputer Files in Chapter 3 MICLST The device name of the source micro Files from up to ten micros can be transferred The file and path names must be identical on each micro REQUESTE...

Page 167: ...l be assigned the same name as the device name of the micro from which the data was transferred This value is not available for SAVF files RECL The record length of the host TOFILE file If the file wi...

Page 168: ...is created A record length RECL of 528 bytes is required and TRANSLATE must be NONE NOTE To create a SAVF object you must be authorized to execute the CRTSAVF command SRCSEQ Determines whether a 12 by...

Page 169: ...to ten characters long To recall the saved request use the ETU command VWSAVRQS TRANSFILE The file name of the translation table file to be used when translation is specified The default translate fil...

Page 170: ...ary name The name of the library containing the specified program EXITPGM The name of any user specified exit program to be run after transferring the file Library name The name of the library contain...

Page 171: ...the micro Mac Users The directory dialog box is unavailable for the RENAME option QFNAME The name of the micro file including the path to be renamed For additional information see About Microcomputer...

Page 172: ...om the user s AS 400 user profile You can specify any name up to ten characters JOBD The job description The default USRPRF uses the job description associated with the user s AS 400 profile Library n...

Page 173: ...e a job you must first start the job called JOBSCHED which controls the job scheduling This job is part of a procedure that submits a program called SCHPGM to the QINTER subsystem Every time QINTER is...

Page 174: ...em format that you want the job released The default is TODAY which releases the job on the current day at the specified time For instance if the system format is DDMMYY enter the 041591 for April 15...

Page 175: ...Library The name of the library containing the SRCFILE file the same library in which ETU is stored LIBL is the default SRCMBR The name of the source physical file member to be edited or created The d...

Page 176: ...e of the AS 400 types supported by SEU SAME Specifies that the same source type is used as when the member was edited type BAS BASP CBL CL CMD DSPF LF PF PLI PRTF PRG RPT TXT CLP CMNF DFU QRY MXDF TEX...

Page 177: ...u will be notified if the file exists via a completion message QFNAME The name of the micro file to be tested For additional information see About Microcomputer Files in Chapter 3 NOTIFY Determines wh...

Page 178: ...e 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...

Page 179: ...3XB command with the SAVTYPE parameter and TRANSLATE NONE SRC A source physical file is created If a SRC file is created 12 bytes will be added to the RECL value A source physical file can be read by...

Page 180: ...ame for example ATOE1M The Mac translation members are also shipped in a file called MACTAB The members in this file do not have the M at the end of the name for example ATOE1 Library The library cont...

Page 181: ...es the current request definition so it can be used at a later time The request definition is this completed TO3XB command with the parameter values as you have specified them The default is NO To sav...

Page 182: ...may be submitted to batch not the FROM3XB or TO3XB commands Batch command cannot be longer than 256 characters 3 Change Allows you to change the saved request 4 Delete Deletes the specified request 5...

Page 183: ...ETU400 User Guide 011603 10 53...

Page 184: ...y name LIBL library name Field translation definition DDS or F I file name FLDDEFFILE DDS file name Library name LIBL library name Member name FLDDEFMBR FILE FIRST LAST member name The XLATEFROM comma...

Page 185: ...record length Any length from 1 to 9989 is supported FILETYPE The type of TOFILE file to be created DATA A physical file is created the default SRC A source physical file is created SRCSEQ Specifies...

Page 186: ...sequence in the qualified file The end of record character is defined in the translation table see Table 8 1 position 40 41 in Chapter 8 To fold indicates that once the current host record is filled a...

Page 187: ...ame to contain the translated data Library name LIBL library name Host member name PCMBR FILE member name of PCDATA file Add seq date field SRCSEQ NO or YES Type of translation TRANSLATE TEXT or YES D...

Page 188: ...he library list are to be searched FRMMBR The FRMFILE member name You can enter the member name or one of the following values FILE Translates the member with the same name as the FRMFILE file the def...

Page 189: ...be used 1 9989 Specifies the record length for the translation work file If an ASCII fixed record length translation is to be performed specify FILE to produce the desired file If you are not translat...

Page 190: ...You can enter the member name or one of the following values FILE Transfers the member with the same name as the FLDEFFILE file the default value FIRST Transfers the first member arrival sequence in t...

Page 191: ...ormation A 1 Inside ETU B 1 ETU Compatibility C 1 Creating DDS Specifications D 1 Creating F I Specifications E 1 ETU Error Messages F 1 EBCDIC ASCII Printable Characters G 1 System 36 mode Commands H...

Page 192: ...Parameters EDTUDF Example Configuring the Audit Trail The CFGAUDIT Parameters Checking the Audit Trail Working With ETU Security Granting Authority to a Command Revoking Authority From a Command Regr...

Page 193: ...the utilities and explains how to use them This chapter is intended for experienced host users and the security officer Some tasks you can perform with the ETU utilities include adding user defined me...

Page 194: ...r a user other than yourself press F4 You are prompted to enter a user profile You can add user defined functions for a single user or a group of users To add a user defined function for a single user...

Page 195: ...cute when selected from the ETU Main menu Valid entries are PMT Displays the prompt screen for the command specified in the Function parameter Before the user defined function can be executed you must...

Page 196: ...USER Press ENTER The Edit User Defined Function screen displays 4 At the Description prompt enter the name of the option as you want it to appear on the menu including UPPER and lower case characters...

Page 197: ...ntries to an output queue of your choice or send the entries directly to a printer rather than put them on hold To change the audit trail configuration display the Configure Audit Trail prompt screen...

Page 198: ...the output queue to which the audit trail entries are sent The default is QPRINT You may enter any valid AS 400 output queue Library The library in which the output queue resides LIBL is a valid libra...

Page 199: ...information Command Name of the transfer command File name The qualified file name of the file that was transferred Device The name of the device or devices from which or to which the file was transf...

Page 200: ...uthority SPCAUT value ALLOBJ all users with that profile automatically have access to the ETU power commands on the ETU Main menu To revoke the power commands from this user profile you must change th...

Page 201: ...ich you wish to revoke authority 4 Enter the user or profile name for which you wish to revoke authority 5 Change the authority parameter to ALL 6 Press ENTER To revoke authority from an ETU command o...

Page 202: ...is not authorized the program ends and sends the following error message to the screen Unable to open display file with device specified In order to take advantage of device specific authority your AS...

Page 203: ...intact all non ETU objects in that library NOTE It is critical that you backup your ETU library prior to running this command in the event that any user data located in this library is inadvertently...

Page 204: ...ETU400 User Guide 011603 B 1 Appendix B ETUCOMPATIBILITY About this Appendix Using ETU with Autokey Batch Files Modifying an Autokey Batch File Example...

Page 205: ...earlier versions of ETU However the menus for ETU 5 01 have been enhanced This may cause some Autokey batch files that were used with earlier versions of ETU not to execute properly This appendix exp...

Page 206: ...a sales wed tofile wedsales recl 132 ENT ETU If you use an Autokey batch file that calls an ETU command from the ETU menu like the example shown below you must modify the batch file due to changes in...

Page 207: ...ETU400 User Guide 011603 C 1 Appendix C CREATINGDDS SPECIFICATIONS About This Appendix Creating DDS Specifications...

Page 208: ...needed when transferring straight text files TEXT format DDS specs are created using the Programming Development Manager PDM utility on the AS 400 In order to use PDM you must have authority to it You...

Page 209: ...u will define each field Figure C 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 Mana...

Page 210: ...PDM screen shown in Figure C 2 appears Select option 3 and press ENTER to work with members If you receive an error after this command you may not have the authority to perform this task see your sys...

Page 211: ...oices press Enter File QDDSSRC Name F4 for list Library LIBL LIBL CURLIB name Member Name ALL ALL name generic Type ALL ALL type generic BLANK F3 Exit F4 Prompt F5 Refresh F12 Cancel Type QDDSSRC in t...

Page 212: ...RISC File QDDSSRC Library QGPL Position to Type options press Enter 2 Edit 3 Copy 4 Delete 5 Display 6 Print 7 Rename 8 Display description 9 Save 13 Change text 14 Compile 15 Create module Opt Member...

Page 213: ...ER Figure C 5 The Start Source Entry Utility screen Start Source Entry Utility STRSEU Type choices press Enter Source file QDDSSRC Name PRV Library QGPL Name LIBL CURLIB PRV Source member SAMPLE Name...

Page 214: ...entering data Figure C 6 The SEU Edit screen Columns 1 80 Edit QGPL QDDSSRC SEU SAMPLE FMT PF A T Name RLen TDpB Functions Beginning of data End of data F3 Exit F4 Prompt F5 Refresh F9 Retrieve F10 Cu...

Page 215: ...these DDS specs For each prompt you can press HELP to receive more information Figure C 7 The SEU Edit Screen after F4 prompt Columns 1 80 Edit QGPL QDDSSRC SEU SAMPLE FMT PF A T Name RLen TDpB Funct...

Page 216: ...er I places SEU in insert mode and the letter P allows you to be prompted to enter the next record Figure C 8 The SEU Edit Screen Columns 1 80 Edit QGPL QDDSSRC SEU SAMPLE FMT PF A T Name RLen TDpB Fu...

Page 217: ...RECORD End of data Prompt type PF Sequence number Name Data Decimal Type Name Ref Length Type Positions Use NAME 17 A Functions F3 Exit F4 Prompt F5 Refresh F11 Previous record F12 Cancel F23 Select...

Page 218: ...A T Name RLen TDpB Functions Beginning of data 0001 00 R RECORD 0002 00 A NAME 17A End of data Prompt type PF Sequence number Name Data Decimal Type Name Ref Length Type Positions Use TITLE 35 A Func...

Page 219: ...ing of data 0001 00 R RECORD 0002 00 A NAME 17A 0003 00 A TITLE 35A End of data Prompt type PF Sequence number Name Data Decimal Type Name Ref Length Type Positions Use SALARY 8 S 2 Functions F3 Exit...

Page 220: ...Functions Beginning of data 0001 00 R RECORD 0002 00 A NAME 17A 0003 00 A TITLE 35A 0004 00 A SALARY 8S 2 End of data Prompt type PF Sequence number Name Data Decimal Type Name Ref Length Type Positio...

Page 221: ...e line that you want the new line to appear after and then press F4 Otherwise press F3 to exit Figure C 13 The SEU Edit screen Columns 1 80 Edit QGPL QDDSSRC SEU SAMPLE FMT PF A T Name RLen TDpB Funct...

Page 222: ...The SEU Exit screen Exit Type choices press Enter Change create member Y Y Yes N No Member SAMPLE Name F4 for list File QDDSSRC Name F4 for list Library QGPL Name Text DDS Spec for sample file transfe...

Page 223: ...screen Work with Members Using PDM NLRISC File QDDSSRC Library QGPL Position to Type options press Enter 2 Edit 3 Copy 4 Delete 5 Display 6 Print 7 Rename 8 Display description 9 Save 13 Change text 1...

Page 224: ...ETU400 User Guide 011603 D 1 Appendix D CREATINGF ISPECIFICATIONS About This Appendix Creating DDS Specifications...

Page 225: ...efined with F I specs F I specs are not needed when transferring straight text files TEXT format F I specs are created using the Source Entry Utility SEU on the AS 400 In order to use SEU you must hav...

Page 226: ...ield 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...

Page 227: ...ce Entry Utility STRSEU Type choices press Enter Source file QRPGSRC Name PRV Library QGPL Name LIBL CURLIB PRV Source member SAMPLE Name PRV SELECT Source type RPG Name SAME BAS BASP Option BLANK BLA...

Page 228: ...een exactly as shown in Figure D 3 and then press ENTER Figure D 3 The SEU Edit screen Columns 1 80 Edit QGPL QRPGSRC SEU SAMPLE FMT 1 2 3 4 5 6 7 8 Beginning of data 0001 00 End of data Prompt type S...

Page 229: ...rrectly a message The Type entry is not H F E L I C O or U position 6 will appear telling you the position with an illegal value After you press Enter the format specification you ve just created move...

Page 230: ...a prompt at the bottom of the screen exactly as shown in Figure D 4 and then press ENTER Column 6 is the Form Type and must contain the letter I Columns 7 through 14 may contain a valid file name for...

Page 231: ...as shown in Figure D 5 and then press ENTER Figure D 5 The SEU Edit screen for line 0003 00 Columns 1 80 Edit QGPL QRPGSRC SEU SAMPLE FMT F FFilenameIPEAF RlenLK1AIOvKlocEDevice KExit Entry A U1 Begi...

Page 232: ...er the ending position of the Name field This field ends in position 17 Use columns 53 through 58 to title the field for reference This example calls the field NAME After you press Enter the input spe...

Page 233: ...ENTER Figure D 6 SEU Edit screen for line 0004 00 Columns 1 80 Edit QGPL QRPGSRC SEU SAMPLE FMT F FFilenameIPEAF RlenLK1AIOvKlocEDevice KExit Entry A U1 Beginning of data 0001 00 FSAMPLE IP F 128 DISK...

Page 234: ...the ending position of the Job Title field This field ends in position 52 Use columns 53 through 58 to title the field for reference This example calls the field TITLE After you press Enter the input...

Page 235: ...D 7 and then press ENTER Figure D 7 SEU Edit screen for line 0005 00 Columns 1 80 Edit QGPL QRPGSRC SEU SAMPLE FMT F FFilenameIPEAF RlenLK1AIOvKlocEDevice KExit Entry A U1 Beginning of data 0001 00 F...

Page 236: ...sitions of the line containing statement 5 and pressing Enter When the new statement line is displayed press F4 to display a prompt in which to enter the input specification 14 The field statement num...

Page 237: ...48 through 51 to enter the ending position of the City field This field ends in position 76 Use columns 53 through 58 to title the field for reference This example calls the field CITY If you need to...

Page 238: ...prior to issuing the SEU command The F I specification called SAMPLE for the demo file called ETUFILE is now defined You can now use this F I definition to transfer the file using ETU Figure D 9 The...

Page 239: ...ETU400 User Guide 011603 E 1 Appendix E ERRORMESSAGES NATIVEMODE...

Page 240: ...lists the ETU error messages that are most likely to occur when you use ETU The messages appear in order of their ETU message number which precedes each message For each message you will find the erro...

Page 241: ...rmation 1 Go to a command line and type WRKMSGF ETUMSGF and press the Enter key 2 Take a 5 on the ETU message file 3 Type the error message USR in the Position to field and press Enter NOTE If the err...

Page 242: ...eue name Once you fill that in you usually have to page down to the bottom to get to near the last entry in the queue which should be yours Sometimes the last entry is a QPRTSPLQ HOLD file so it is th...

Page 243: ...C disk diskette after moving to a new system He used to monitor for a CPF CAUSE Usually this is a good message Sometimes users monitor for CPF messages in batch files A newer version of ETU might not...

Page 244: ...FROM3XB command PROBLEM USR1255 File 1 was not found on the PC disk diskette CAUSE The OPEN FILE command sent to the PC emulator failed because the file name specified was not found in the current dir...

Page 245: ...at name exists and is open by another application it can cause this The file may already exist and have the Read only attribute set in it s Properties Right click on the file and select Properties to...

Page 246: ...the RENAMEB command was not found SOLUTION Verify the name of the file you want to rename and retry the operation CAUSE The name you specified for the new PC file already exists SOLUTION Enter a diff...

Page 247: ...ing the T03XB or PWRT03XB command to transfer a micro file to a new host file PROBLEM USR8255 For FILETYPE equal to DATA or SAVF SRCSEX must be equal to NO CAUSE The values specified for the FILETYPE...

Page 248: ...de 011603 E 10 The values specified for the FILETYPE and RECL parameters are not compatible with each other SOLUTION If the value for the FILETYPE parameter is SAVF the value for the RECL parameter mu...

Page 249: ...change the FRMMBR value to either FILE FIRST or LAST PROBLEM USR9013 DOS error code 0C General failure Probable error media error CAUSE The diskette disk adapter detected an error while trying to wor...

Page 250: ...ing the data file with no intervening end of field designation SOLUTION Insure that the PC data file is in the format specified for the translation type on the command Correct the data file or command...

Page 251: ...n the Copyright screen is displayed ETU is currently only supported with NLynx Decision Data s ES32 emulation There once was a DOS Compatibility disk with a program called IBMTRAN that enabled any emu...

Page 252: ...a catchall for ETU problems not previously identified and clarified CAUSE Trying to type during a transfer SOLUTION Do not key inside the emulation screen during a transfer Do not press Enter on the m...

Page 253: ...mand or create a library CRTLIB command and a file with the appropriate name 02 Change the file name the library name or both the file name and library name with an appropriate override file command 0...

Page 254: ...the record number is not zero the error occurred on an attempt to read an existing record from a file See the previously listed message CPF5035 to determine which physical file fields is in error The...

Page 255: ...digit was truncated 3 A floating point value exceeded the maximum representable value 4 A floating point value was less than the minimum representable value 5 A floating point value that is not a num...

Page 256: ...could not be converted from an ASCII CCSID to an EBCDIC CCSID or could not be converted from or to a UCS 2 Universal Coded Character Set CCSID The addition of shift out and shift in characters or the...

Page 257: ...ocedure is running TRANSMIT FILE BEING CREATED ERROR see statement LOAD PCRCB2 SYS1235 Options 3 Program PCRCB2 in LOAD statement was not found CAUSE The ETU library is not correctly loaded SOLUTION 1...

Page 258: ...tomer installed the ETU 36 software but not as a security officer SOLUTION The installation requires some privileges that require the use of the security officer privileges There is no work around as...

Page 259: ...ol file to a physical file use an OS 400 command called CPYSPLF The command interface only allows for a single spool file to be copied In general the OS 400 spool file interface is very restrictive Bo...

Page 260: ...would see that this is where to change from A to C SOLUTION You will need to find the CL script and modify it The line that needs to change will look similar to this FROM3XB FRMFILE GEORGE QFNAME1 a...

Page 261: ...I O error was detected in XLATN DOS 4 10 Emulation Message is displayed when it starts to do the translating It does not get this message when executed through the menu option 13 CAUSE A parameter in...

Page 262: ...only typing in the filename Could be caused by using an incorrect path name in a script Could be caused by not reading the A drive SOLUTION Put an in the qualified filename field and it will prompt t...

Page 263: ...f you then look at the tasks list the emuapp32 is running twice For what it is worth the first uses a lot more memory PROBLEM When running a CL procedure you get these errors Error RPG0202 caused prog...

Page 264: ...ETU400 User Guide 011603 F 1 Appendix F ASCII EBCDICPRINTABLECHARACTERS...

Page 265: ...ETU400 User Guide 011603 F 2 About This Appendix This appendix lists the ASCII and EBCDIC characters and their hexadecimal equivalents Use this table when you create or modify an ETU translation table...

Page 266: ...08 9 09 10 0A 11 0B 12 0C 13 0D 14 0E 15 OF 16 10 17 11 18 12 19 13 20 14 21 15 22 16 23 17 24 18 25 19 26 1A 27 1B 28 1C 29 1D 30 1E 31 1F 32 20 space 33 21 34 22 35 23 36 24 37 25 38 26 39 27 40 28...

Page 267: ...C 68 44 D 69 45 E 70 46 F 71 47 G 72 48 H 73 49 I 74 4A J 75 4B K 76 4C L 77 4D M 78 4E N 79 4F O 80 50 P 81 51 Q 82 52 R 83 53 S 84 54 T 85 55 U 86 56 V 87 57 W 88 58 X 89 59 Y 90 5A Z 91 5B 92 5C 9...

Page 268: ...22 7A z 123 7B 124 7C 125 7D 126 7E 127 7F 128 80 129 81 a 130 82 b 131 83 c 132 84 d 133 85 e 134 86 f 135 87 g 136 88 h 137 89 i 138 8A j 139 8B k 140 8C l 141 8D 142 8E 143 8F 144 90 145 91 j 146 9...

Page 269: ...B2 179 B3 180 B4 181 B5 182 B6 183 B7 184 B8 185 B9 186 BA 187 BB 188 BC 189 BD 190 BE 191 BF 192 C0 193 C1 A 194 C2 B 195 C3 C 196 C4 D 197 C5 E 198 C6 F 199 C7 G 200 C8 H 201 C9 I 202 CA 203 CB 204...

Page 270: ...3 DF 224 E0 225 E1 226 E2 S 227 E3 T 228 E4 U 229 E5 V 230 E6 W 231 E7 X 232 E8 Y 233 E9 Z 234 EA 235 EB 236 EC 237 ED 238 EE 239 EF 240 F0 241 F1 242 F2 243 F3 244 F4 245 F5 246 F6 247 F7 248 F8 249...

Page 271: ...ETU400 User Guide 011603 G 1 Appendix G System 36 mode Commands This appendix contains the commands used to emulate ETU36...

Page 272: ...sed by a System 36 mode OCL procedure The syntax of the native command when used in OCL is the same as entering the command from the System 36 mode command line all uppercase letters However most nati...

Page 273: ...when you issue the command MENU ETU36 Select a menu option and you will be prompted for the parameters required by the procedure you selected Figure G 1 The ETU36 menu Menu ETU36 Workstation ID WH Em...

Page 274: ...XLT36PRT procedure 10 executes the XLTPCFIL procedure 11 executes the XLTPCPRT procedure 13 executes the FILETOPC procedure 14 executes the LIBRTOPC procedure 15 executes the PRNTTOPC procedure 16 exe...

Page 275: ...The System 36 mode of ETU 400 does not support the following ETU native mode commands and utilities EDITTABLE EDTUDF PCFROMPC PCTOPC PWRFROM3XB PWRTO3XB SBMBATXFER SBMSCHJOB STRSEU VWSAVRQS System 36...

Page 276: ...ure ETU36 ALLOCATE workstation file name The ALLOCATE procedure allocates a new file on the workstation workstation file name is the name of the workstation file to be allocated For additional informa...

Page 277: ...e not provided in the S 36 mode The native mode translate tables provide the required support If you execute the COMPILE procedure it calls the native mode ETU command EDITTABLE used to compile the tr...

Page 278: ...on File Name on page ____ notify Specifies whether you should be notified with a halt message if the workstation file is not found in the directory optional If NO is specified the procedure continues...

Page 279: ...ctions are not provided in the S 36 mode The native mode translate tables provide the required support If you execute the EDITABLE function it calls the native mode ETU command STRSEU used to edit the...

Page 280: ...DIF 1000 BASICS TAB spec lib clilb ETU36 FILEFRPC workstation file name AS400 label record len1 T 128 SAVE NONE The FILEFRPC procedure transfers a file from the workstation to the AS 400 optionally tr...

Page 281: ...acters as the field delimiters SAVE permits offline storage and moves executable programs between workstations see below NONE no translation of the file is to be performed the default When using SAVE...

Page 282: ...ly for the field oriented translation methods DIF BASICS TAB See Chapter 5 for more information on creating the F and I RPG specifications truncate optional is YES if data exceeding the record length...

Page 283: ...workstation data format AS 400 label is the label name of the file to be sent to the workstation date optional is the date of file AS 400 label YMD format Reformat optional specifies the type of data...

Page 284: ...r ETOA2M for fixed length records xlat size optional is the number of records in the temporary work file used in the translation process The default value is 1000 record len optional is the record len...

Page 285: ...lib name replace clib YES NO add ctl member type file size YES member name P xlate size NO S The LIBRFRPC procedure transfers and optionally translates a workstation file into library members on the A...

Page 286: ...n the translation process The default value is 1000 record len2 optional is the record length of the translation work file The default value is the record length of the library member work file record...

Page 287: ...library The default value is NO member name if add ctl is YES is the library member name of the workstation data when replaced in the library lib name member type optional if add ctl is YES is the lib...

Page 288: ...me is only a partial name enter ALL to have all members of the specified type extracted from the library Leave this entry blank if the member name is complete member type optional is the type of the l...

Page 289: ...he field delimiters NONE no translation of the file is to be performed the default xlat file optional is the translation table file Translation file member ETOA1 is provided on the AS 400 distribution...

Page 290: ...n member input specs and the translate table member xlat table If left blank this parameter defaults to the current library workstation file name is the name of the workstation file to receive the lib...

Page 291: ...will default to the value specified in the configuration of the workstation on which the PRNTFRPC procedure is executed forms id optional is the forms number name on which to print the report If left...

Page 292: ...r releases it for printing The default is NO width optional specifies the width in columns of the file to be printed Width may be 132 the default or 198 translate table optional specifies the name of...

Page 293: ...type to be extracted in the form Fxxxx or ALL to extract all inactive print spool items Examine the COPYPRT procedure in the manual System Reference for the AS 400 Environment for more information on...

Page 294: ...on Any number from 1 to 198 is valid The default value is 1 to window optional is the print column position of the report s on which to end translation Any number from 1 to 198 must be equal to or lar...

Page 295: ...YFILE TXT If not specified it defaults to the current default directory on your workstation new file name is the new name to be given to the workstation file NOTE The new file name plus extension shou...

Page 296: ...o be tested For additional information see Workstation File Name on page 4 2 lda offset optional has two possible values NOTIFY and LDA position If NOTIFY is specified the operator will be sent a mess...

Page 297: ...l1 is the label name of the AS 400 file to be translated date optional is the date of the AS 400 file to be translated YMD format AS 400 label2 is the label name of the file that will contain the resu...

Page 298: ...late from the EBCDIC to the ASCII character set in fixed length records See the EDITABLE and COMPILE procedures for more information on creating new translation table files The default value is ETOA1...

Page 299: ...at spool name is the spool name id of the print reports on the AS 400 print spool Valid entries are the spool id in the form SPxxxx the forms type to be extracted in the form Fxxxx or ALL to extract a...

Page 300: ...al is the date of the AS 400 file to be added to AS 400 label2 retain optional is the file retention how long the file is to exist for the translated AS 400 label2 Allowed values are T or J Specifying...

Page 301: ...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 tra...

Page 302: ...c Users Do not use the default xlat file value You must use the value ATOE1M xlat size optional is the number of records in the temporary work file used in the translation process The default value is...

Page 303: ...the value specified in the configuration of the workstation on which the XLTPCPRT procedure is executed forms id optional is the forms number name on which to print the report If left blank the entry...

Page 304: ...ETU400 User Guide 011603 H 1 Appendix H INTERNATIONALTRANSLATIONTABLES...

Page 305: ...If you are using the U S English table you do not need to install the files on the translation table diskette To install the translation tables on your AS 400 follow the steps below 1 Insert the medi...

Page 306: ...M3XB RENAMEB TESTB FROM3XB PRTFROM3X PRTTO3X EDITTABLE and STRSEU You must run these commands from the microcomputer that you are sending the file to or receiving it from Interactive commands can be p...

Page 307: ...on software will work but the scripting mechanism does not interact so it will not know when the file transfer is complete So if ETU is used in a macro it needs to be the last command of the macro VWS...

Page 308: ...400 User Guide 011603 I 3 ETU commands PWRFROM3XB PWRTO3XB PCFROMPC and PCTOPC as well as non ETU commands that can be submitted to a batch See page 9 21 and 10 47 of the ETU400 User Guide for specifi...

Page 309: ...ETU400 User Guide 011603 J 1 Appendix J ETUTHROUGHPUTCONSIDERATIONS...

Page 310: ...SP it will slow it down Your AS400 CPU speed and OS 400 version will make a difference If there is a lot of other processing taking place on your host it will slow it down If the job is submitted to a...

Page 311: ...t 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 me...

Page 312: ...stead of spool file You have to be careful with dates however If Query outputs to a physical file it does not reformat the data This is an issue with dates because the AS 400 use the century date form...

Page 313: ...ssed when it reaches the top of the queue data transfer The process of moving data between the micro and the host with ETU data translation An ETU process in which data is changed from ASCII to EBCDIC...

Page 314: ...rast with physical file OCL Object Constraint Language A modeling language used to set up strings of valid OS400 commands output queue A waiting area on the AS 400 where host spool files are sent unti...