Open topic with navigation
ODBC to File Export Specification Line Item
Purpose
To define the fields to be included in the ODBC to File data export file, the column headings to use, and any data conversions or formulas required.
Available Toolbar Commands
|
|
Click the Done icon in the toolbar to save the current line item and return to the export specifications main page.
|
|
|
Click the Add icon in the toolbar to save the current line item, clear all fields and keep the window open so that you can add another line item, which will be the last line number available.
|
|
|
Click the Remove icon in the toolbar to delete the current line item, close the window and return to the export specifications page.
|
|
|
Click the Up icon in the toolbar to move the line item up in the line item list relative to the other line items, thereby decreasing the current line item number. Click Done or Add to save your change.
|
|
|
Click the Down icon in the toolbar to move the line item down in line item list relative to the other line items, thereby increasing the current line item number. Click Done or Add to save your change.
|
|
|
Click the Help balloon to open the help for this page.
|
To save any changes you make after creating or editing Export Line Items you must save your changes using either the New, Save, or Save As toolbar commands
File/Key Field
KT_EXPORTS/Export Name
Prerequisites
If an export contains user-defined literals, they should be entered using Substitution Literals.
Line Item Fields
|
|
|
|
Line
|
The order sequence this field should appear in the export.
|
|
Source Column
|
Enter a source column from the Source Table where you want to extract data. Click the search icon  to select a column from a list of column names and their respective data types associated with the Source Table.
To create a computed or derived column reference a valid column and then use the Conversion or Formula fields.
|
|
Target Column
|
Enter the target column heading for this exported field. This field is used when formatting the exported file.
|
|
Conversion
|
Enter any valid dictionary conversion code, substitution parameter, or a literal string. Multiple conversion may be separated by the | (pipe) character.
|
|
Format
|
This field is only used when an export is generated in FIXED format. It is used to over-ride the length of the output and the justification of the output (e.g., 10L for 10 characters, left justified).
|
|
Formula
|
Enter a user-defined formula for this field using standard UniBASIC syntax and commands. The results of the formula will determine the find output value for this field. A formula icon will be displayed in the list view if there is a formula defined for a field. Hover your mouse over the icon to see the note.
|
|
Comments
|
Enter any comments you wish to describe or document this export field. A note icon will be displayed in the list view if there is a formula defined for a field. Hover your mouse over the icon to see the note.
|
Related Topics:
Export Formulas
Export Conversion Codes