Versions Compared

Key

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

...

Note

CSV output is required when all the queries in the instance are either 'Select' queries or 'Stored Procedure' queries which returns single ResultSet.

After enabling this property, the below parameters becomes editable and hence , which act as punctuation in the CSV output. These separators can be customized by providing the respective values:

  • Field Separator
    The value of Column Separator to be used in CSV output.
  • Line Separator
    The value of Row Separator to be used in CSV output.
  • Wrap Character
    The specified character is used to wrap each field that is returned when a query is processed. This field is not mandatory.For example, if the wrap character is " and the field separator is ;,

Example: 

When separators used are:,

  • Field separator →;
  • Line separator ,
  • Start Wrap Character "
  • End Wrap Character  "

then the output will be like:

"13579008642";"john";"hyd"

...

,"124";"joseph";"bang",

Anchor
_Toc364085539
_Toc364085539
Anchor
_Toc372740717
_Toc372740717
Using Named Configurations

...

Adaptavist ThemeBuilder EngineAtlassian Confluence