Hi Ricardo, Ricardo Crestoni [mailto:[EMAIL PROTECTED] wrote:
> Subject: Dump to TXT > > I have to dump really big tables to txt format. The tables have a few > millions of entries. > > We have Sapdb 7.3.0.25, and no loadercli, only repmcli (is > that pertinent?) > It's not only pertinent it is pretty much the same ;-). Both are the same program only renamed in 7.4 to make the function more clearly. To get you data you could run a dataextract command like this DATAEXTRACT * FROM <table name> OUTFILE '<path\file name>'. If you'd like to import it later on again to SAP DB you could run DATAEXTRACT FOR DATALOAD TABLE <table name> OUTFILE '<path\file name for generated commands>' OUTFILE '<path\data file name>' Running this command the RepMan/Loader will generate CREATE TABLE and DATALOAD commands for later recreating/loading the table. Additionally the data will be exported, too. Ok, no need to mention that the commands must be put into a batch file that must be given to repmcli for execution, right ;-) Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
