Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

ParameterDefaultValid Values
AppendFilefalsetrue, false, clear (i.e. start with a new file for the first result and then append to it)
BinaryFileDir
Path for data files when BinaryFormat is set to File, see Exporting a Table for details. Note! Variables for columns column names must include the scope option when entered manually into a script, e.g. /Users/hans/exp/${dbvis-date}$/${COUNTRIES||||||scope=post}$
BinaryFormatDon't ExportDon't Export, Size, Value, Hex, Base64, File
BooleanFalseFormatfalsefalse, no, 0, off
BooleanTrueFormattruetrue, yes, 1, on
CLOBFileDir
Path for data files when CLOBFormat is set to File, see  Exporting a Table for details. Note! Variables for columns column names must include the scope option when entered manually into a script, e.g. /Users/hans/exp/${dbvis-date}$/${COUNTRIES||||||scope=post}$
CLOBFormatDon't ExportDon't Export, Size, Value, File
CsvColumnDelimiter\t (TAB)
CsvIncludeColumnHeadertruetrue, false
CsvIncludeColumnHeaderPerResultfalse
CsvColumnHeaderIsColumnAliastruetrue, false
CsvIncludeSQLCommandDon't IncludeDon't Include, Top, Bottom
CsvSplitFileSize-1Split the result over multiple files if it is larger than the specified size, or -1 to never split. The size must be specified as size [ g | G | m | M | k | K ]
CsvRemoveNewlinesfalsetrue, false
CsvRowCommentIdentifier

CsvRowDelimiter\n\n (UNIX/Linux/macOS), \r\n (Windows)
DateFormatyyyy-MM-ddSee valid formats in Changing the Data Display Format document
DecimalNumberFormatUnformattedSee valid formats in Changing the Data Display Format document
DestinationFileFile
EncodingUTF-8Check supported encodings for all encodings. (Use the encoding in the Canonical Name for java.nio API column).
ExcelColumnHeaderIsColumnAliastruetrue, false
ExcelFileFormatBinary

Two formats are supported

  • Binary Excel (xls) supporting export of max 65 535 rows. Specified as "Binary Excel (xls)", "Binary" or "xls"
  • OOXML, Excel 2007 (xlsx). Specified as "OOXML, Excel 2007 (xlsx)", "OOXML" or "xlsx"
ExcelIncludeColumnHeadertruetrue, false
ExcelIncludeSQLCommandfalsetrue, false
ExcelIntroText
Any description
ExcelSheetName
Used when exporting to excel. Sets the name of exported excel sheet.
ExcelTextOnlyfalsetrue, false. Convert numeric values to text in the Excel file if true.
ExcelTextDateTimetruetrue, false. Convert date, time and timestamp data to text in the Excel file if true.
ExcelTitle
Any title
Filename REQUIRED
FormatBased on file extension, or CSV if none

CSV, HTML, XML, SQL, XLS, JSON. If Format is not specified, the file extension is used to determine the format. If there is no recognized file extension, CSV is used as the default.

HtmlColumnHeaderIsColumnAliastruetrue, false
HtmlConvertCharstruetrue, false. Set to false if you have HTML code in the exported data, so that e.g. < and > characters are not converted to &lt; and &gt;
HtmlFooter[ Generated by: DbVisualizer version ]Any text to use in the document footer. Can be set to blank to remove the footer.
HtmlIncludeSQLCommandfalsetrue, false
HtmlIntroText
Any description
HtmlPerTableHeader

E.g.

Date:2017-05-31 16:48:23
Columns:4
Table:COUNTRIES


HTML code that describes the table. To fit into the rest of the HTML code, it must start with <tr> and end with </tr>. The pre-defined DbVisualizer variables can be used, e.g. ${dbvis-object}$ to include the table name.
HtmlTitle
Any title
JSONColumnHeaderIsColumnAliastruetrue, false
JSONStyleArrayArray, Rows
NumberFormatUnformattedSee valid formats in Changing the Data Display Format document
QuoteDuplicateEmbeddedtruetrue, false (quote char is the same as QuoteTextData)
QuoteTextDataNoneNone, Single, Double
Settings
The path to an XML file containing all settings
ShowNullAs(null)
SqlAfterExportStmts
Any statements to include in the script after the SQL statements for the exported objects, e.g. set foreign_key_checks = 1;
SqlBeforeExportStmts
Any statements to include in the script before the SQL statements for the exported objects, e.g.  set foreign_key_checks = 0;
SqlBeginIdentifier
Character to use to begin a quoted identifier. Note! To specify a double-quote, you must duplicate it since double-quote is also used to enclose the parameter value.
SqlBlockBeginDelim
String to use to begin an SQL block when exporting complex DDL statements using the @ddl command.
SqlBlockEndDelim
String to use to end an SQL block
SqlDelimitedIdentifierstruetrue, false
SqlEndIdentifier
Character to use to end a quoted identifier. Note! To specify a double-quote, you must duplicate it since double-quote is also used to enclose the parameter value.
SqlGroupByObjectObject, Statement. Set to Object to generate DROP, CREATE, INSERT, and ALTER statements (where applicable) for each exported object in turn. Set to Statement to group all statements of the same type together, e.g. first DROP statements for all exported objects, then CREATE statements for all exported objects, etc.
SqlIncludeAutoGeneratedValuestrueSet to false to exclude columns declared as AUTO_INCREMENT or IDENTITY in the INSERT statements.
SqlIncludeCreateDDLfalsetrue, false
SqlIncludeSQLCommandDon't IncludeDon't Include, Top, Bottom
SqlQualifier
Qualifier to use when qualifying table names. If not set, DbVisualizer tries to determine the schema and use it as the qualifier.

SqlQualifyColumnName

falsetrue, false
SqlQualifyObjectNametruetrue, false
SqlRowCommentIdentifier--
SqlSeparator;Statement separator character.
SqlSplitFileSize-1Split the result over multiple files if it is larger than the specified size, or -1 to never split. The size must be specified as size [ g | G | m | M | k | K ]
TableName
Can be set if DbVisualizer cannot determine the value for the ${dbvis-object}$ variable
TimeFormatHH:mm:ssSee valid formats in Changing the Data Display Format document
TimeStampFormatyyyy-MM-dd HH:mm:ss.SSSSSSSee valid formats in Changing the Data Display Format document
XmlColumnHeaderIsColumnAliastruetrue, false
XmlIncludeSQLCommandfalsetrue, false
XmlIntroText
Any description
XmlStyleDbVisualizerDbVisualizer, XmlDataSet, FlatXmlDataSet

...