...
- first message: first 10 rows from first query
- second message: remaining 8 rows from first query and 2nd update query results.
- third message: 3rd update query result and first 9 rows of second select query.
- fourth message: remaining two rows from second query.
CSV Configuration
Figure : CSV Configuration
When When Enable CSV Output property property is selected, output of the queries will be in CSV format.
Figure: CSV Configuration
| Note |
|---|
This property is supported when CSV output is required only in the instance are either Select queries or Stored Procedures Procedure queries which return single ResultSet. |
After enabling this property, the below parameters becomes editable. These separators, which act as punctuation in the CSV output,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. For example , if the wrap character is " and the field separator is ; This Field is not mandatory.
When separators used are:,
- Field separator → ;
- Line separator → ,
- Wrap Character → "
then the output will be like:
"13579008642";"john";"hyd". This Field is not mandatory.,"124";"joseph";"bang",
Escape Character: This field is not mandatory. If the wrap character mentioned in CPS turn up in the values returned from the DB, then those characters will be prefixed by escape character specified. If no character is specified, no action will be taken.
...