Difference between revisions of "SET CSVHEADING"
From Lianjapedia
Yvonne.milne (Talk | contribs) (Created page with "==Purpose== Enable or disable the inclusion of field name headings in COPY TO ... TYPE CSV exports ==Syntax== SET CSVHEADING ON | OFF | (<expL>) ==See Also== APPEND FROM...") |
Yvonne.milne (Talk | contribs) |
||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
− | + | Enables or disable the inclusion of field name headings in COPY TO ... TYPE CSV exports | |
==Syntax== | ==Syntax== |
Revision as of 11:06, 23 October 2013
Contents
Purpose
Enables or disable the inclusion of field name headings in COPY TO ... TYPE CSV exports
Syntax
SET CSVHEADING ON | OFF | (<expL>)
See Also
APPEND FROM, COPY, COPY FILE, COPY STRUCTURE, COPY STRUCTURE EXTENDED, DECRYPT, ENCRYPT, SET FILTER, SET XMLFORMAT
Description
The SET CSVHEADING set command works in conjunction with the COPY TO ... TYPE CSV command. If SET CSVHEADING is ON (default), the first line of the csv text file created will be the field names. If SET CSVHEADING is OFF, the field names will be omitted.
Example
open database southwind use products set csvheading off copy to exportproducts type CSV delimited with '|' type exportproducts.csv