output

String attribute that specifies the name that should be used in the file name other than the default <dbname>. 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 exammple 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