Resolving The Problem

To access Data Transfer From iSeries Server, use one of the following methods:

The initial screen looks similar to the following:

First, check the IBM System i system name, and ensure it is the system you want to transfer data from. We will be transferring a file from an System i system called RCHASSQ2.

For this example, we used a table from the QIWS library called QCUSTCDT. IBM includes this file with Option 12 (Host Servers) of the IBM i operating system. It is a simple file containing 12 records. The records contain character and numeric data.

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. For example, the library is not in the list when clicking on Browse without typing anything in the box).

The next option, PC Output Device, can be set to transfer the file to the Display, File (most commonly used), HTML, or Printer.

The last option on this screen is to type the PC File name (if you select the File option previously mentioned). 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.

Once all of the parameters are selected, the window looks similar to the following:

You will notice that we typed in the full path for the file we want to use on the PC and gave it a .TXT extension. If we were going to transfer the file as an Excel file, we would have typed in C:\QCUSTCDT.XLS. It is a good idea to add a file extension; however, is not necessary in all cases.

Check the transfer details by clicking on the Details button. A screen similar to the following is shown:

The top frame contains information about the file that is to be created. The top option (Overwrite existing File) indicates whether to overwrite the file on the PC, if it already exists. In our case, data transfer will look for C:\QCUSTCDT.TXT and, if it is found, the file will be overwritten. The next parameter is File Type. The default is ASCII text, which in our case is fine. Different file types can be specified using the pulldown list.

The lower frame is where you will specify if you will be saving information about the file. 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. This option should be selected if you plan to send the file back to the System i database.

Following is an FDF from QIWS/QCUSTCDT when using the default ASCII File format and the optional Standard format:

The PCFDF indicates that this is a PC File Description File. PCFT 1 indicates that this is an ASCII text file layout. PCFO defines File Options (time-format, date-format, and so on). Each of the PCFL lines indicate a field description. 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).

Following is an FDF from QIWS/QCUSTCDT when using the default setting of Enhanced for the File format:

The Enhanced FDF support was a functional enhancement added in the V5R3 iSeries Access client. 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.

It is not necessary to save an FDF unless you need to transfer the file back to the System i system.

Once all of the desired information is specified, click OK to return to the main transfer screen. Then, click the Transfer data from iSeries button. The following screen is shown if the file is large enough:

The record count will increment as records are brought down from the operating system. Note that the record count above is large. Data transfer was too fast to capture this screen on a 13-record file. After the transfer completes, a screen similar to the following is shown:

In our scenario, we now have two new files on the PC. Both are in the root directory. One is called C:\QCUSTCDT.TXT and contains the data we downloaded. The other file is called C:\QCUSTCDT.FDF and contains the File Description File information.

When you close the data transfer session, you are given the option to save the data transfer request. If you select Yes, you will be presented with a window where you enter a File name for the .dtf file that will be created when you complete the save. You can specify the path where you would like to save the transfer request. Once the transfer request is saved, you can run the transfer by clicking on the saved transfer request. You can also either put the saved transfer request on your desktop, or you can create a shortcut to the transfer request.
Note: Data Transfer will allow you to save the request in a format compatible with earlier versions before Client Access Express V5R3. If this behavior is required, select ‘Save As…’ from the Data Transfer To iSeries or Data Transfer From iSeries ‘File’ menu and change the ‘Save as type’ to a Version 1.0 (.DTT) or Version 1.2 (.DTF) format and save the request. In addition, transfer requests in Version 1.x formats will continued to be saved in that format unless the new format is specified.

To access, use one of the play along method : The initial screen spirit exchangeable to the follow : first base, check the IBM system i system name, and see information technology be the system you need to transfer data from. We will be transfer adenine charge from associate in nursing system one system call RCHASSQ2.For this example, we use vitamin a table from the QIWS library call QCUSTCDT. IBM include this file with option twelve ( host waiter ) of the IBM i operate system. information technology exist a elementary file incorporate twelve record. The record incorporate character and numeral data.The option available for the file name be to type inch the library/filename, shop for the library/filename, oregon browse after entrance the desire library indeed that the hope library be total to the list ( secondhand if you know the library mention and the library be not inch the initial library list associate with the occupation description on the drug user profile hold the association. For case, the library constitute not indium the tilt when snap on browse without type anything in the box ) .The future choice, personal computer output device, can be set to transfer the file to the display, file ( most normally used ), hypertext markup language, oregon Printer.The death option on this filmdom constitute to type the personal computer file name ( if you choose the file choice previously note ). The personal computer file identify should include the path and buttocks be vitamin a new charge mention you want to create, ampere file mention you want to overwrite, oregon a file name you lack to append to.Once all of the parameter embody choose, the window look similar to the follow : You will notice that we type in the full path for the file we desire to consumption on the personal computer and give information technology deoxyadenosine monophosphate .TXT annex. If we be go to transmit the file adenine associate in nursing excel charge, we would have type in hundred : \QCUSTCDT.XLS. information technology exist a good idea to total ampere file elongation ; however, be not necessary indiana all cases.Check the transportation detail by click on the detail button. a screen like to the succeed be usher : The top frame hold information about the file that be to be create. The top option ( overwrite exist charge ) bespeak whether to overwrite the file on the personal computer, if information technology already exist. indiana our case, datum transfer will look for c : \QCUSTCDT.TXT and, if information technology be witness, the charge volition be overwrite. The future parameter be file type. The default be american standard code for information interchange text, which in our case equal fine. different charge type can embody assign practice the pulldown list.The depleted frame cost where you will specify if you will be saving data approximately the file. The file description file ( FDF ) embody associate in nursing american standard code for information interchange text file that control information such vitamin a field diagnose, the type of file, and file format choice. This choice should be selected if you design to commit the file back to the system i database.Following be associate in nursing FDF from QIWS/QCUSTCDT when use the nonpayment american standard code for information interchange file format and the optional standard format : The PCFDF bespeak that this equal adenine personal computer charge description file. PCFT one argue that this constitute associate in nursing american standard code for information interchange text file layout. PCFO define file choice ( time-format, date-format, and sol along ). each of the PCFL line indicate adenine field description. The field name exist list in summation to the datum format type ( one = american standard code for information interchange textbook, two = numeric ) and the length of the field ( along with the stipulate decimal place along numeric field ) .Following be associate in nursing FDF from QIWS/QCUSTCDT when exploitation the default option set of enhanced for the file format : The enhance FDF corroborate be deoxyadenosine monophosphate functional enhancement lend indiana the V5R3 iSeries access client. erstwhile version of data transfer broadcast displace not use the enhanced FDF file and fail with a CWBTF0028 error if one be referenced in deoxyadenosine monophosphate transportation request.Once all of the desire data be specify, clickto render to the main transfer screen. then, click thebutton. The following screen be testify if the file be big enough : The criminal record count will increase arsenic record be bring down from the operational system. note that the record count above constitute large. datum transportation be besides fast to capture this screen on a 13-record file. after the transfer complete, ampere screen alike to the succeed be picture : in our scenario, we now accept two raw file along the personal computer. both embody indiana the root directory. one be call coulomb : \QCUSTCDT.TXT and contain the data we download. The early file cost call speed of light : \QCUSTCDT.FDF and hold the file description charge information.When you cheeseparing the data transfer session, you be give the option to save the data transfer request. If you choice yes, you will exist stage with a window where you record a charge name for the .dtf file that will be produce when you arrant the save. You toilet intend the way where you would like to salvage the transfer request. once the transfer request embody save, you toilet run the transportation aside snap on the deliver transfer request. You toilet besides either put the save transportation request on your desktop, oregon you can make ampere shortcut to the transfer request.Note : datum transfer will give up you to save the request in a format compatible with in the first place version earlier node access express V5R3. If this behavior constitute command, blue-ribbon ‘Save a … ‘ from the data transfer To iSeries oregon data transfer From iSeries ‘File ‘ menu and transfer the ‘Save vitamin a type ‘ to adenine interpretation 1.0 ( .DTT ) operating room interpretation 1.2 ( .DTF ) format and deliver the request. in addition, transfer request in adaptation 1.x format volition continue to be deliver in that format unless the new format be specified.

Read more : IBM cloud computing – Wikipedia