Generic_SQL_Export

Purpose

Generic_SQL_Export is a call back function for exporting Trax FPS data into external data formats by providing an SQL string. Currently supported formats are listed under <Format_Type>.

Arguments

Geneneric_SQL_Export(

<Sql_Text>
An SQL string that specifies the data source.
, <File_Grp>
The name of a File Group as described in the FILE_GRPS table. This entry is used to determine the directory that the generated file is to be put into. A value of “AP Feeds” has been used for several customers.
, <File_Name>
The destination file name to export to.
, <Object_Name>
The destination table name in case of exporting to Microsoft Access. Ignored when exporting to other formats.
, <Format_Type>
Data format to be exported to. Following is a list of valid formats:
“Microsoft Access”
“dBase III”, “dBase IV”
“Excel” equivalant to “Excel 5.0”
“Excel 5.0”, “Excel 4.0”
“Lotus WKS”, “Lotus WK1”
“FoxPro 2.0”, “FoxPro 2.5”, “FoxPro 2.6”
“Paradox 3.X”, “Paradox 4.X”
“Text Delimited”
, <File_Option>

Examples

<Sql_Text>	An SQL string that specifies the data source.
, <File_Grp>	The name of a File Group as described in the FILE_GRPS table. This entry is used to determine the directory that the generated file is to be put into. A value of “AP Feeds” has been used for several customers.
, <File_Name>	The destination file name to export to.
, <Object_Name>	The destination table name in case of exporting to Microsoft Access. Ignored when exporting to other formats.
, <Format_Type>	Data format to be exported to. Following is a list of valid formats: “Microsoft Access” “dBase III”, “dBase IV” “Excel” equivalant to “Excel 5.0” “Excel 5.0”, “Excel 4.0” “Lotus WKS”, “Lotus WK1” “FoxPro 2.0”, “FoxPro 2.5”, “FoxPro 2.6” “Paradox 3.X”, “Paradox 4.X” “Text Delimited”
, <File_Option>