output

String attribute that specifies the name that should be used in the file name other than the default. The output file will be generated in the current working directory of the process calling the rdm_dbExport() function unless a path specification is given in the file specification.

For example, the default file name for a CSV file is: <dbname>_<tablename>.csv

Setting the output to: myFileName will produce the following for an extract of the example BOOKSHOP database:

optString = "type=CSV;output=myFileName"

Output files generated:

myFileName_ACCTMGR.csv
myFileName_AUCTION.csv
myFileName_AUTHOR.csv
myFileName_BID.csv
myFileName_BOOK.csv
myFileName_GENRES.csv
myFileName_GENRES_BOOKS.csv
myFileName_NOTE.csv
myFileName_NOTE_LINE.csv
myFileName_PATRON.csv
myFileName_RELATED_NAME.csv
myFileName_SALE.csv
myFileName_SUBJECTS.csv
myFileName_SUBJECTS_BOOKS.csv

Note

A full file specification can be used in the output designation. For example, "output=/myDirectory/Path/myFileName".

If a file extension is provided in the output file name specification, that extension will be included in the <dbname> replacement and will NOT be the extension of the file, for example:

optString = "type=CSV;output=myFileName.txt"

Output files generated:

myFileName.txt_ACCTMGR.csv
myFileName.txt_AUCTION.csv
myFileName.txt_AUTHOR.csv
myFileName.txt_BID.csv
myFileName.txt_BOOK.csv
myFileName.txt_GENRES.csv
myFileName.txt_GENRES_BOOKS.csv
myFileName.txt_NOTE.csv
myFileName.txt_NOTE_LINE.csv
myFileName.txt_PATRON.csv
myFileName.txt_RELATED_NAME.csv
myFileName.txt_SALE.csv
myFileName.txt_SUBJECTS.csv
myFileName.txt_SUBJECTS_BOOKS.csv