David Barcelo wrote: > > The below line is straight from the sap documentaion but it doesn't > work. It chokes on keyword outfile: > > TABLEEXTRACT TABLE PAGEVIEWS OUTFILE pageviews.data > > Here is the reply: > [EMAIL PROTECTED] mfoulk]# /opt/sapdb/depend/bin/repmcli -u dsa,admin -d > iceburg -b /home/mfoulk/command.dat > Opened connection to Loader SERVER at node local host. > Loader Server Protocol File: > '/var/opt/sapdb/indep_data/wrk/loader.prt' > > User DSA connected to database ICEBURG on local host. > TABLEEXTRACT TABLE PAGEVIEWS OUTFILE pageviews.data' > Error during execution > -->-25281 > Syntax error at position 30 (Unexpected keyword: OUTFILE). > > Defined maximum number of errors (1) reached
If we assume that you are using version 7.4 see the mail of Hans-Georg of 24 January 2003 you can find the right syntax at http://www.sapdb.org/7.4/htmhelp/e2/55683ab81fd846e10000000a11402f/frameset.htm SAP DB Loader: SAP DB 7.4 --> Commands --> TABLEEXTRACT Command change your statement to: TABLEEXTRACT ... OUTSTREAM FILE '...' Elke SAP Labs Berlin > > > 1 error(s) during execution of command file > '/home/mfoulk/command.dat'. > ---> See log file(s) for more information. > > > Some error(s) occurred running command. > ---> See log file(s) for more information. > > > > Does anyone know why this is happening. > > Noah J SILVA wrote: > > >Hi, > > > >What you want is the Replication Manager (7.3.x) or the Data Loader > >(7.4.x). This can export a table or view and also a command > needed to > >re-import it. ( I don't know that it will make a "create > table" statement > >for you though) > > > >Thank you, > > Noah Silva > > IS&T - Programmer Analyst > > (215) 419 - 7916 > > > > > > > > > > > >David Barcelo <[EMAIL PROTECTED]> > >Sent by: [EMAIL PROTECTED] > >03/25/2003 12:39 PM > > > > > > To: [EMAIL PROTECTED] > > cc: > > Subject: Backing up certain tables... > > > > > >My co-worker wants to backup certain tables and keep others > out of the > >backup. We want to retain table structure and data. Is there a > >facility to dump tables. > > > >Thanks in advance, > >Dave > > > > > > > > > > -- > _____ > > James David Barcelo > Network/Systems Administration > > Data Junction Corporation > 2201 Northland Drive > Austin, TX 78756 > tel: 512-459-1308 ext. 349 > fax: 512-469-1309 > www.datajunction.com > * The contents and attachments in this email are confidential. > > _____ > > > > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
