Hi Eric, Eric Jain wrote: > > Thanks, I was reading the wrong version of the documentation... > > What I wanted was actually more like: > > DATAEXTRACT * FROM taxa OUTFILE 'taxa.csv' FORMATTED > > I am using 7.4.3.7, does the patch need to be applied for > this version? > Hmm, yes. It is a 7.4.3 patch that should substitute any loader with a build number smaller than the one the patch has (I guess it is 10).
> (I assume yes, after a few thousand rows have been exported I get a > 'received a garbled packet' error.) > If this problem persists send a description of the table structure for reproduction. > Incidently, is there an option to export to TAB separated files? > Something like: > > SET COMPRESSED /\t// > Yes there is. Although the semantics is not yet fully the way it should - means you need to type tab instead of escaped t :-(. We'll change that immediately. So your command would look like this SET COMPRESSED /<tab>// // DATAEXTRACT * FROM <table name> OUTFILE <file name> which would produce output like data1<tab>data2<tab>... Alternatively you could reset the separator in a single command using the separator spec like this DATAEXTRACT * FROM <table name> OUTFILE <file name> SEPARATOR '<tab>' which would produce output like "data1"<tab>"data2"<tab>... because the default delimiter spec was used (not changed in command). And last but not least you need to specify the format COMPRESSED instead of FORMATTED or you omit the format specification in the command (the format defaults to COMPRESSED). The formats apply as follows COMPRESSED = CSV (comma separated values) FORMATTED = FWV (fixed width, columnar values). Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
