Setting up SQL (Fixed Width) Query Exports

To set up an SQL (Fixed Width) Query Export:

  1. Specify this information to create a scheduled task in the Job Scheduler:
    Task Type
    Export Task (Fixed Width Query)
  2. 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.