[
https://issues.apache.org/jira/browse/TRAFODION-2680?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16080895#comment-16080895
]
Anoop Sharma commented on TRAFODION-2680:
-----------------------------------------
trafodion command line interface trafci supports a SET statement "set markup
csv"
that could be issued in a session.
When it is set, output of select statement are returned in csv format.
That output could be logged to get csv compatible output in a file.
Default separator is comma but other separators could also be set.
Details of 'set markup' stmt are in the command interface guide.
http://trafodion.apache.org/docs/command_interface/Trafodion_Command_Interface_Guide.pdf
> CSV_FORMAT function
> -------------------
>
> Key: TRAFODION-2680
> URL: https://issues.apache.org/jira/browse/TRAFODION-2680
> Project: Apache Trafodion
> Issue Type: New Feature
> Components: sql-cmp
> Affects Versions: 2.2-incubating
> Environment: All
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
>
> To make it easier to get Trafodion data into spreadsheets, add a CSV_FORMAT
> function to Trafodion SQL.
> Syntax: CSV_FORMAT(argument1, ... ,argumentn)
> Semantics: The result of CSV_FORMAT is a VARCHAR string consisting of a
> comma-separated list of the argument values. If the argument itself contains
> a comma, it is surrounded with double quotes.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
