Question & Answer
Following are instructions on creating an ACS FDFX file description file:
1. Open Data Transfer from the main ACS interface and on the tab "From IBM i" enter values for the parameters. The IBM i file name is usually the file you want to upload data to, or it can be a file with the same field layout as the file you want to upload to. Following is an example:
2. Click the Details button.
For the file type, select the file type from the drop-down that matches the type of PC file you plan to upload to the IBM i. The options are:
Comma-separated values (.csv)
Tab-delimited text (.txt)
Microsoft Excel (.xlsx)
Microsoft Excel 97-2003 (.xls)
Dos Random (.dsr)
Under Client file description, check the box to Save client file description. Specify a path and name for the fdfx file.
You can take the defaults for the rest of the parameters in this window.
Here is an example of the File Details pane:
Click OK to return to the main transfer pane.
3. Click the 'Data Options' button and add 1=0 to the Where clause (to prevent the pc data file from being created...you don't want or need that file).
4. Click the Start Transfer button to download the IBM i file and create the fdfx file.
You get the message:
Click OK on the message to create the fdfx file without an unnecessary PC data file.
The Field Description File contents are similar between IBM i Access for Windows and IBM i Access Client Solutions, but not identical.
Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries, or both.
18 December 2019