Page History
...
| Parameter | Default | Valid Values | ||||||
|---|---|---|---|---|---|---|---|---|
| AppendFile | false | true, 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}$ | |||||||
| 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 | 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}$ | |||||||
| CLOBFormat | Don't Export | Don't Export, Size, Value, File | ||||||
| CsvColumnDelimiter | \t (TAB) | |||||||
| CsvIncludeColumnHeader | true | true, false | ||||||
| CsvIncludeColumnHeaderPerResult | false | |||||||
| CsvColumnHeaderIsColumnAlias | true | true, false | ||||||
| CsvIncludeSQLCommand | Don't Include | Don't Include, Top, Bottom | ||||||
| CsvSplitFileSize | -1 | Split 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 ] | ||||||
| CsvRemoveNewlines | false | true, false | ||||||
| CsvRowCommentIdentifier | ||||||||
| CsvRowDelimiter | \n | \n (UNIX/Linux/macOS), \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 | Check supported encodings for all encodings. (Use the encoding in the Canonical Name for java.nio API column). | ||||||
| ExcelColumnHeaderIsColumnAlias | true | 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. Convert numeric values to text in the Excel file if true. | ||||||
| ExcelTextDateTime | true | true, false. Convert date, time and timestamp data to text in the Excel file if true. | ||||||
| ExcelTitle | Any title | |||||||
| Filename | REQUIRED | |||||||
| Format | Based 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. | ||||||
| HtmlColumnHeaderIsColumnAlias | true | true, false | ||||||
| HtmlConvertChars | true | true, false. Set to false if you have HTML code in the exported data, so that e.g. < and > characters are not converted to < and > | ||||||
| HtmlFooter | [ Generated by: DbVisualizer version ] | Any text to use in the document footer. Can be set to blank to remove the footer. | ||||||
| HtmlIncludeSQLCommand | false | true, false | ||||||
| HtmlIntroText | Any description | |||||||
| HtmlPerTableHeader | E.g.
| 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 | |||||||
| JSONColumnHeaderIsColumnAlias | true | true, false | ||||||
| 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) | |||||||
| 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 | |||||||
| 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. | |||||||
| SqlGroupBy | Object | Object, 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. | ||||||
| SqlIncludeAutoGeneratedValues | true | Set to false to exclude columns declared as AUTO_INCREMENT or IDENTITY in the INSERT statements. | ||||||
| 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. | |||||||
SqlQualifyColumnName | false | true, false | ||||||
| SqlQualifyObjectName | true | true, false | ||||||
| SqlRowCommentIdentifier | -- | |||||||
| SqlSeparator | ; | Statement separator character. | ||||||
| SqlSplitFileSize | -1 | Split 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 | |||||||
| 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 | ||||||
| XmlColumnHeaderIsColumnAlias | true | true, false | ||||||
| XmlIncludeSQLCommand | false | true, false | ||||||
| XmlIntroText | Any description | |||||||
| XmlStyle | DbVisualizer | DbVisualizer, XmlDataSet, FlatXmlDataSet |
...
Overview
Content Tools