A file action defines a copy, move or delete step that happens to Native ODBC temporary files after a load is run.
There are six different file action programs:
File Action | Description |
---|---|
copy all files | Copies all temporary files for the Load table (including the temporary data file) to another specified directory. |
copy data files | Copies the Native ODBC Load table's temporary data file to another specified directory. Also enables a new file name to be specified. |
delete all files | Deletes all temporary files for the Load table (including the temporary data file). |
delete data files | Deletes the Native ODBC Load table's temporary data file. |
move all files | Moves all temporary files for the Load table (including the temporary data file) to another specified directory. |
move data files | Moves the Native ODBC Load table's temporary data file to another specified directory. Also enables a new file name to be specified. |
Note
A Load table may have more than one file action. File actions are processed in order, based on the action number.
Creating a File Action
To create a file action:
- Click the File Actions tab of the Load table Properties window.
- Click Add new action and then select After load from the Action Type drop-down list.
- Enter the Action Description.
- Select the Action Program from the drop-down list (see above for the options).
- For action programs of copy... and move..., enter the target directory name.
- For copy data files and move data files, optionally enter the file's new name.
- Click Save (Update) Action.
- Repeat if necessary for additional file actions.
- Click OK.