Hi Steffen, hi joao thank you very much - now it runs.
But I have a litte new problem: I executed the following loadercli-command with the //-separator: C:\Programme\sapdb\export\cmd>loadercli -d gs -u test,test -b books2_ex.txt Loader Server Protocol File: 'c:\programme\sapdb\indep_data\wrk\loader.prt' User TEST connected to database GS on local host. CATALOGEXTRACT TABLE TEST.books2 OUTSTREAM FILE 'c:\programme\sapdb\export\books2_cat.data' PAGES Successfully executed TABLEEXTRACT TABLE TEST.books2 DATA OUTSTREAM FILE 'c:\programme\sapdb\export\books2.data' PAGES Successfully executed As a result I get the following books2_cat.data-file SQLMODE INTERNAL // CREATE TABLE "BOOKS2" ( "ID" Integer, "TITLE" Varchar (100) ASCII, "AUTHOR" Varchar (100) ASCII, "YEAR" Varchar (25) ASCII ) // CREATE TABLE "TEMP_BOOKS" ( "ID" Integer, "TITLE" Varchar (100) ASCII, "AUTHOR" Varchar (100) ASCII, "YEAR" Varchar (25) ASCII ) // As you see, there are 2!!! create table-statements in it - and I don't know, where the second statement comes from. I made an catalogexport for temp_books before, but as you can see in the cmdline-messages, there is no catalogextract-statement for table temp_books in the last command. It's no problem for me to delete the second create table-statement from books2_cat.data - than everthing works fine- but it's an interesting feature. Best regards Georg "Schildberg, Steffen" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > Hi Georg, > > Georg Schoepe [mailto:[EMAIL PROTECTED] wrote: > > > > as it seems it isn't possible to execute more than one statement in a > > loadercli-commandfile, as I tried in the following example: > > > It is. > > > loader.prt: > > > > CATALOGEXTRACT > > TABLE TEST.books2 > > OUTSTREAM FILE 'c:\programme\sapdb\export\books2_cat.data' PAGES > > > > TABLEEXTRACT > > TABLE TEST.books2 > > DATA OUTSTREAM FILE 'c:\programme\sapdb\export\books2.data' PAGES > > // * > > // E -25281: Syntax error at position 110 (Unexpected keyword: > > TABLEEXTRACT). > > > Modify your file to the following form: > > CATALOGEXTRACT > TABLE TEST.books2 > OUTSTREAM FILE 'c:\programme\sapdb\export\books2_cat.data' PAGES > // > TABLEEXTRACT > TABLE TEST.books2 > DATA OUTSTREAM FILE 'c:\programme\sapdb\export\books2.data' PAGES > > and it'll run. Promise. > Steffen > -- > Steffen Schildberg > SAP DB Team > SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
