Dear Rick,
Thanks for the lengthy explanation.
I'm still quite new to derby, and beginning to notice it's flexibility,
haha.
Regards,
Albert Kam
--
Do not pursue the past. Do not lose yourself in the future.
The past no longer is. The future has not yet come.
Looking deeply at life as it is in
Hi Albert,
Derby's understanding of CSV predates RFC 4180. For instance, Derby
trims leading and trailing spaces from imported columns although this
behavior is forbidden by RFC 4180. Derby's CSV dialect is described in
the Tools Guide in a section titled "File format for input and output".
T
Hello Apache Derby,
I'm using db-derby-10.4.1.3-bin, and when i'm importing a csv file like this
:
*ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE
(null,'SMS_OUT','/home/albert/mnt/linuxdb/rnd/sofco_sms/CSVs/sms_out.csv',null,null,null,0);
*
an error pops out like this :
*ERROR XIE0R: Import error on lin