Nlynx ETU400 Скачать руководство пользователя

Страница: 185 / 314

ETU400 User Guide 011603

10-55

Library

The library containing the PCDATA file. *LIBL is the
default.

PCMBR

The PCDATA file member name. The default is *FILE.

TOFILE

The qualified file name of the AS/400 file into which the
micro data is to be written.

Library

The library containing the TOFILE file. *LIBL is the
default.

TOMBR

The TOFILE member name. If the member does not exist, it will
be added to the file. If it does exist, the member will first

be cleared before the current data is written. The default is

*FILE.

RECL

The record length of the AS/400 file. It is the actual data
length. If you specify SRCSEQ(*YES), the record length used

in allocating the file is 12 greater than that supplied in

this parameter, to make room for the sequence number/date

field being added. You must specify the record length of the

file if the TOFILE file is to be created. If the file already

exists, the specified length must be 0 or must match the file

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 whether a 12-byte source sequence number and data
field is to be written in the first 12 bytes of the record.

This allows the translated record to be read by the AS/400

Source Entry Utility (SEU). Note that SRCSEQ can be specified

even if the file is not translated, in which case

untranslated data would be sequenced. This parameter also

affects the actual record length of the file.

*NO

Do not add the sequence number/date field. The
record length is equal to that specified. *NO is

the default.

*YES

Add the sequence number/date field. Actual record
length is 12 greater than the specified record

length.

TRANSLATE

The type of file translation that is to occur.

*TEXT

The qualified file exists in ASCII text format.
This is the default.

*DIF

The qualified file exists in DIF format.

*BASICS

The qualified file exists in BASIC Sequential
format.

*TAB

The qualified file exists in BASIC Sequential
format with tab characters as field delimiters.

Содержание ETU400

Страница 1: ...i ETU400 User Guide AS 400FileTransferUtility...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 30: ...ETU400 User Guide 011603 2 5 old versions since most users do not modify these tables...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 131: ...mand PCTOPC Command PGMFROM3XB Command PGMTO3XB Command PRTFRO3XB Command PRTTO3XB Command PRTXFROMPC Command PRTXTOPC Command PWRDELETEB Command PWRFROM3XB Command PWRRENAMEB Command PWRTO3XB Command...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 183: ...ETU400 User Guide 011603 10 53...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 207: ...ETU400 User Guide 011603 C 1 Appendix C CREATINGDDS SPECIFICATIONS About This Appendix Creating DDS Specifications...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 224: ...ETU400 User Guide 011603 D 1 Appendix D CREATINGF ISPECIFICATIONS About This Appendix Creating DDS Specifications...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 239: ...ETU400 User Guide 011603 E 1 Appendix E ERRORMESSAGES NATIVEMODE...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 264: ...ETU400 User Guide 011603 F 1 Appendix F ASCII EBCDICPRINTABLECHARACTERS...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 271: ...ETU400 User Guide 011603 G 1 Appendix G System 36 mode Commands This appendix contains the commands used to emulate ETU36...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 304: ...ETU400 User Guide 011603 H 1 Appendix H INTERNATIONALTRANSLATIONTABLES...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 309: ...ETU400 User Guide 011603 J 1 Appendix J ETUTHROUGHPUTCONSIDERATIONS...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Результаты поиска

Содержание ETU400

Отзывы:

Похожие инструкции для ETU400

Бренды по названию

Популярные бренды

Nlynx ETU400, Руководство пользователя

Результаты поиска

Содержание ETU400

Отзывы:

Похожие инструкции для ETU400

Бренды по названию

Популярные бренды