Setting up SQL (Fixed Width) Query Exports
To set up an SQL (Fixed Width) Query Export:
-
Specify this information to create a scheduled task in the Job
Scheduler:
- Task Type
- Export Task (Fixed Width Query)
-
Specify this information for the Export Task (Fixed Width Query)
task type:
- SQL Query
- Specify the SQL query to execute.
- File Name
- Specify the path and file name to be exported, using the absolute path with respect to the application server.
- Add Date and Time to Each File Name
- Optionally, select this check box if you want to append the date and time to the export file. The format is: Filename_yyyyMMdd_HHmmss.txt.
- Performs Difference
- Optionally, select this check box if you want the export task
to perform a difference between the current SQL query results and the last SQL
query results of the same Export Task (Fixed Width Query) task. Only the
information that is different is written to the new SQL query fixed width file.
When you run the initial export task, the application creates two directories: /compare and /new. These directories reside in the same location of the exported output file. For each running of the same export task, the new exported file is placed in the /new directory and is compared with the file in the /compare directory (if any exists). The resulting difference file is placed in the main folder.
The file in the /new directory is copied to the /compare directory for future runs of the same export task.
- Definition File Name
- Specify the definition file name, including the absolute path
to the definition file. The file must be on the application server with the
application.
See Definition file.
See Job Scheduler.