I'm having difficulty loading character fields with carriage returns with
loadercli. My control file looks something like...
use user local local
//
sqlmode oracle
//
create table dept (id number(18), name varchar2(32), descr varchar2(4000),
phone varchar2(25))
//
DATALOAD TABLE LOCAL.DEPT
"ID" 1 DEFAULT NULL
"NAME" 2 DEFAULT NULL
"DESCR" 3 DEFAULT NULL
"PHONE" 4 DEFAULT NULL
INFILE 'dept.dat' COMPRESSED
DATE ISO
TIMESTAMP 'YYYY-MM-DD'
NULL ''
//
and my dept.dat file is....
"1","Home Dept","Enterprise Wide Home Dept","415-555-5555"
"2","DC Dept","Washington DC Dept
555 West Road
Washington, DC 00001","555-121-1212"
"3","Chicago Dept","Chicago Dept
555 Wacker Drive
Chicago, IL 60666","312-555-5555"
With SAPDB version 7.4.3 build 17 (my preference at the moment), it does
not recognize the carriage return within the quotes. Instead, it thinks I
would have 7 rows above instead of 3.
I've tried COMPRESSED BINARY as the format, and it never makes it past the
first record (it doesn't know the difference between an in-line carriage
return and a new record).
To eliminate the possible easy solution, I tried both approaches with
build 27 - with the same results.
What's the easiest way to handle these? I was thinking perhaps changing
the inbound file to FORMATTED BINARY, but that would require a good deal
of whitespace padding (say, if my DESCR record was a VARCHAR(4000)...)
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
