I have a large compressed csv file, 450MB, that I want to import into SapDB.
The csv file contains 16 char() fields and one long() field. I've read the
Replication Manager Doc and it says I need to separate the long columns into
a separate file and figure out the start and stop position of each long
record. Example from docs:

DATALOAD TABLE hotel
   cno 1
   name 2
   info 3
INFILE 'hotel.data'
LONGFILE info 'HOTEL.LNG'

Contents of the source table:
   10,Excelsior,1-880
   30,Flora,881-1046
   60,Bellevue,1047-1360

Two questions:
1. Is there an easier way to import longs that are interspersed in a
compressed csv file?
2. What parsing tools are available that can extract the longs from the csv
file, write them to another file, and record their position?

Thanks,
Charlie

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to