Re: Setting loadercli COMPRESSED format, question

Arne Gehlhaar <[email protected]>
Newsgroups gmane.comp.db.sapdb.general
Organization ISL Bremen
Message-ID <[email protected]>
>>My data (one row) looks like this:
>>'19','user','user','0','0'

try:

sed 's/'/"/g' mydata.dat > mydata_corrected.dat

and:

SET COMPRESSED '/"/,/'
//
DATALOAD TABLE PM_USER
INSTREAM FILE 'mydata_corrected.dat' COMPRESSED

Arne

-- 
Institute of Shipping Economics and Logistics    http://www.isl.org/
Arne Gehlhaar                                mailto:[email protected]
Universitaetsallee GW1 Block A                phone:+49.421.22096.49
D-28359 Bremen, Germany                         fax:+49.421.22096.55
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.