Here's the table and the DATALOAD command:
CREATE TABLE proto_groupings ( protocol_id int NOT NULL DEFAULT SERIAL (1) primary key, short_name char(32) NOT NULL DEFAULT '', description char(254) NOT NULL DEFAULT '', protocolid_str char(254) NOT NULL DEFAULT '', parameter_str char(16) NOT NULL DEFAULT '', grouptype_name char(32) NOT NULL DEFAULT '', group_name char(32) NOT NULL DEFAULT '' )
DATALOAD TABLE proto_groupings grouptype_name 1 group_name 2 short_name 3 description 4 protocolid_str 5 INFILE '&1protoload.txt' DELIMITER '' COMPRESSED SEPARATOR ','
That's two single quotes after the DELIMITER work and two single quotes around the comma symbol.
The &1 is parameter 1 passed into "loadercli" via the -p1 command line switch. You need to specify the entire path of the input file (unless its in a special directory, I think).
The data file (protoload.txt) contains (just a snip):
ip,wildcard.ip,Network,IP,8.1.0.0.1.0.0.8.0 ipx,wildcard.ipx,Network,IPX,8.1.0.0.1.0.0.129.55 decnet,wildcard.decnet,Network,DecNet,? netbeui,wildcard-llc.netbeui,Network,NetBEUI,8.1.0.0.2.0.0.0.240 tcp,wildcard.ip.tcp,Transport,TCP,12.1.0.0.1.0.0.8.0.0.0.0.6 udp,wildcard.ip.udp,Transport,UDP,12.1.0.0.1.0.0.8.0.0.0.0.17 ftp,wildcard.ip.tcp.ftp,Application,File Serving,x
Good luck, Mark
Martin Cordova S. wrote:
Can someone please post a link to a sample data file formatted for the DATALOAD command (using a field separator - if possible).
I looked into the Loader docs, but could not find a data file format sample (only the command file samples).
Thanks a lot! Martin
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
