![]() The record count will increment as records are brought down from the operating system. The following screen is shown if the file is large enough: Then, click the Transfer data from iSeries button. Once all of the desired information is specified, click OK to return to the main transfer screen. It is not necessary to save an FDF unless you need to transfer the file back to the System i system. Older versions of data transfer programs cannot use the enhanced FDF files and fail with a CWBTF0028 error if one is referenced in a transfer request. The Enhanced FDF support was a functional enhancement added in the V5R3 iSeries Access client. The field name is listed in addition to the data format type (1 = ASCII Text, 2 = Numeric) and the length of the field (along with the specified decimal places on Numeric fields).įollowing is an FDF from QIWS/QCUSTCDT when using the default setting of Enhanced for the File format: Each of the PCFL lines indicate a field description. PCFO defines File Options (time-format, date-format, and so on). PCFT 1 indicates that this is an ASCII text file layout. The PCFDF indicates that this is a PC File Description File. This option should be selected if you plan to send the file back to the System i database.įollowing is an FDF from QIWS/QCUSTCDT when using the default ASCII File format and the optional Standard format: The File Description File (FDF) is an ASCII text file that contains information such as field names, the type of file, and file format options. The lower frame is where you will specify if you will be saving information about the file. Different file types can be specified using the pulldown list. The default is ASCII text, which in our case is fine. In our case, data transfer will look for C:\QCUSTCDT.TXT and, if it is found, the file will be overwritten. The top option (Overwrite existing File) indicates whether to overwrite the file on the PC, if it already exists. The top frame contains information about the file that is to be created. A screen similar to the following is shown: ![]() It is a good idea to add a file extension however, is not necessary in all cases.Ĭheck the transfer details by clicking on the Details button. If we were going to transfer the file as an Excel file, we would have typed in C:\QCUSTCDT.XLS. You will notice that we typed in the full path for the file we want to use on the PC and gave it a. Once all of the parameters are selected, the window looks similar to the following: The PC file name should include the path and can be a new file name you want to create, a file name you want to overwrite, or a file name you want to append to. The last option on this screen is to type the PC File name (if you select the File option previously mentioned). The next option, PC Output Device, can be set to transfer the file to the Display, File (most commonly used), HTML, or Printer. For example, the library is not in the list when clicking on Browse without typing anything in the box). The options available for the File name are to type in the library/filename, Browse for the library/filename, or Browse after entering the desired library so that the desired library is added to the list (used if you know the library name and the library is not in the initial library list associated with the job description on the user profile making the connection. The records contain character and numeric data. It is a simple file containing 12 records. IBM includes this file with Option 12 (Host Servers) of the IBM i operating system. We will be transferring a file from an System i system called RCHASSQ2.įor this example, we used a table from the QIWS library called QCUSTCDT. The initial screen looks similar to the following:įirst, check the IBM System i system name, and ensure it is the system you want to transfer data from. įrom a PC5250 emulation screen, click on the Recv button (or use the menu options under Transfer). Right-click on the Desktop, select New, and select Data transfer from iSeries (this option will initiate a wizard where the desired entries can be entered). ![]() Using menus, go to Start, Programs, IBM iSeries Access for Windows, and Data transfer from iSeries. Open the iSeries Access group of icons, and select the Data transfer from iSeries icon. To access Data Transfer From iSeries Server, use one of the following methods: 1. Where a difference is important, the version of the product is used to identify the differences. For the purposes of this document, the terms Client Access, Client Access Express, iSeries Access, and System i Access can be used interchangeably. These names essentially refer to the same product however, the functionality and name changed over the last several releases. Important Note: This document discusses Client Access for Microsoft Windows 95 and Windows NT, Client Access Express, IBM iSeries Access, and IBM System i Access products.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |