Hi Alan, Alan Graham [mailto:[EMAIL PROTECTED] wrote: > > A few days ago I asked how to use xsql, as I have a large > number of SQL > statements to create the database schema and then insert the data > values. I was pointed to the db loader. > Good advice ;-)
> This is all well and good as sapdb to sapdb transfers, migrations, etc > go. But I (and a fair few others, judging by the traffic on the list) > need to convert a few Access databases, or SQLserver databases, or... > To get the import into SAPdb working with the loader would > demand that I > write my own version of the unload tool. This is a nontrivial task. > SQL is a well understood tool, and there are plenty of tested SQL > routines around for me to use to download the data. I am amazed that > SAP should consider SQL an inappropriate tool to input into an RDBMS. > It does. Do I understand you right - you have lots of CREATE TABLE, INSERT, CREATE INDEX statements in a text file and would like to get it executed. And the statements are separated by semicolons (this is the REAL problem)? Feed the Loader with the file and there you are. The Loader is able to execute SQL as well as special load commands. I must confess that the only problem might be the semicolon which must be replaced by a // in a new line. That shouldn't be a big problem. Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
