How to use “CREATE TABLE” to define a table structure for csv file?
For insatnce, CREATE TABLE chk (businessmode CHAR(14),”first name” char(16),”last name” char(18), company char(50),trade CHAR(35), address char(30), address2 char(30), city char(19), flag char(2),ID char(7),serialNO numeric(6,0),_CSV_Separator char(1) default ‘,’, _CSV_Quoter char(1) default ‘”‘,_CSV_Header boolean default false) will define a csv table called chk. _CSV_Separator, _CSV_EOL, _CSV_Quoter, _CSV_Header, _CSV_Comment, and _CSV_ColumnCount4EmptyFile, are special columns, which can be used to define a different value from connection properites. _CSV_Separator specifies a character used to separate the values of the fields. _CSV_EOL specifies 1~2 character sequence to terminate one line. _CSV_Quoter specifies a character used to quote the string value. _CSV_Header indicates whether the first record of CSV file to consist of the names of the fields in the data following. _CSV_Comment specify whether ther’re some comment lines before csv header and data rows. If you use n (integ
