Versions Compared

Key

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

...

ParameterDefaultValid Values
AppendFilefalsetrue, false, clear
BinaryFileDir Directory path for data files when BinaryFormat is set to File
BinaryFormatDon't ExportDon't Export, Size, Value, Hex, Base64, File
BooleanFalseFormatfalsefalse, no, 0, off
BooleanTrueFormattruetrue, yes, 1, on
CLOBFileDir Directory path for data files when CLOBFormat is set to File
CLOBFormatValueDon't Export, Size, Value, File
CsvColumnDelimiter\t (TAB) 
CsvIncludeColumnHeadertruetrue, false
CsvColumnHeaderIsColumnAliastruetrue, false
CsvIncludeSQLCommandDon't IncludeDon't Include, Top, Bottom
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-8 
ExcelColumnHeaderIsColumnAliasfalsetrue, 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
ExcelTitle Any title
Filename REQUIRED  
FormatCSVCSV, HTML, XML, SQL, XLS, JSON
HtmlIncludeSQLCommandfalsetrue, false
HtmlIntroText  Any description
HtmlTitle  Any title
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) 
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.
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.
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
XmlIncludeSQLCommandfalsetrue, false
XmlIntroText  Any description
XmlStyleDbVisualizerDbVisualizer, XmlDataSet, FlatXmlDataSet

...