Use this page to specify information about the target file.
If you are using this file as an ODBC target, the following rules apply:
If the file is local to the agent that is accessing the file, you must specify the fully qualified file name in this field.
If this file is the target for a DB2 OLAP Server Data Warehouse Center program, for example, DB2 OLAP: Load data from a file with load rules (ESSDATA2), the following rules apply:
If the file-location flag in your program indicates that the file is on an ESSBASE client, you must specify a fully qualified file name in this field.
If the file-location flag indicates that the target file is on the ESSBASE server, you must specify the file name without an extension.
Certain Data Warehouse Center functions, such as data viewing, are not valid on server-based files that are defined as targets for DB2 OLAP Server programs.
If this file is the target for a program that originates outside of the Data Warehouse Center, you must provide the file name in one of the following formats:
Fully qualified file name
File name with an extension (8.3 format)
File name without an extension
The rules for specifying a target file name for a program that originates outside of the Data Warehouse Center will vary from program to program. See the documentation about the program to determine the format that the program requires.
Use this page to specify the fields to be included in the flat file.
The Fields list contains one row for each field of data that was read from the file. If the First row contains column names check box is selected on the Parameters page, the first column of each row in the Fields list contains the names of the columns in the file as read by the system. If the check box on the Parameters page is not selected, the first column of each row contains system-generated column names. The subsequent columns in the list contain values that are read from the file.
The File preview area shows the actual data from the file. The number of columns in the preview area is determined by the number of columns of data in the file. The column headings are identical to the values in the first column of each row of the Fields list. You cannot edit the values in the File preview area.
Type a name for the column.
Select the data type for the column. The data type can be LONG VARCHAR or NUMERIC.
Type the maximum length of the data for the column.
This field is only applicable for the LONG VARCHAR data type.
Select the data precision for the column.
This field is only applicable for the NUMERIC data type.
If the data type for the column supports precision, type the number of digits to the right of the decimal point.
Type a short description for the column.
The description can be up to 200 characters long.
