Page History
...
| Parameter | Default | Valid Values |
|---|---|---|
| AppendFile | false | true, false, clear |
| BinaryFileDir | Directory path for data files when BinaryFormat is set to File | |
| BinaryFormat | Don't Export | Don't Export, Size, Value, Hex, Base64, File |
| BooleanFalseFormat | false | false, no, 0, off |
| BooleanTrueFormat | true | true, yes, 1, on |
| CLOBFileDir | Directory path for data files when CLOBFormat is set to File | |
| CLOBFormat | Value | Don't Export, Size, Value, File |
| CsvColumnDelimiter | \t (TAB) | |
| CsvIncludeColumnHeader | true | true, false |
| CsvColumnHeaderIsColumnAlias | true | true, false |
| CsvIncludeSQLCommand | Don't Include | Don't Include, Top, Bottom |
| CsvRemoveNewlines | false | true, false |
| CsvRowCommentIdentifier | ||
| CsvRowDelimiter | \n | \n (UNIX/Linux/Mac OS XmacOS), \r\n (Windows) |
| DateFormat | yyyy-MM-dd | See valid formats in Changing the Data Display Format document |
| DecimalNumberFormat | Unformatted | See valid formats in Changing the Data Display Format document |
| Destination | File | File |
| Encoding | UTF-8 | |
| ExcelColumnHeaderIsColumnAlias | false | true, false |
| ExcelFileFormat | Binary | Two formats are supported
|
| ExcelIncludeColumnHeader | true | true, false |
| ExcelIncludeSQLCommand | false | true, false |
| ExcelIntroText | Any description | |
| ExcelSheetName | Used when exporting to excel. Sets the name of exported excel sheet. | |
| ExcelTextOnly | false | true, false |
| ExcelTitle | Any title | |
| Filename | REQUIRED | |
| Format | CSV | CSV, HTML, XML, SQL, XLS, JSON |
| HtmlIncludeSQLCommand | false | true, false |
| HtmlIntroText | Any description | |
| HtmlTitle | Any title | |
| JSONStyle | Array | Array, Rows |
| NumberFormat | Unformatted | See valid formats in Changing the Data Display Format document |
| QuoteDuplicateEmbedded | true | true, false (quote char is the same as QuoteTextData) |
| QuoteTextData | None | None, Single, Double |
| Settings | The path to an XML file containing all settings | |
| ShowNullAs | (null) | |
| 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 | |
| SqlDelimitedIdentifiers | true | true, 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. | |
| SqlIncludeCreateDDL | false | true, false |
| SqlIncludeSQLCommand | Don't Include | Don'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. | |
| SqlQualifyObjectName | true | true, false |
| SqlRowCommentIdentifier | -- | |
| SqlSeparator | ; | Statement separator character. |
| TableName | Can be set if DbVisualizer cannot determine the value for the ${dbvis-object}$ variable | |
| TimeFormat | HH:mm:ss | See valid formats in Changing the Data Display Format document |
| TimeStampFormat | yyyy-MM-dd HH:mm:ss.SSSSSS | See valid formats in Changing the Data Display Format document |
| XmlIncludeSQLCommand | false | true, false |
| XmlIntroText | Any description | |
| XmlStyle | DbVisualizer | DbVisualizer, XmlDataSet, FlatXmlDataSet |
...
Overview
Content Tools