Hello, I'm using the latest version of SapDB(version 7.4), and I'm facing the following problem while importing batch sql statements using repmcli :
I used the following command ; prompt> repmcli -d sampledb -u suraj,suraj -b createtables.sql >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Here's my createtbles.sql file : -------------------------------- create table test(name varchar(30), age integer) / create table test1(name varchar(10)) >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Here's the output from the command : ---------------------------------- D:\Program Files\sapdb\programs>repmcli -d sampledb -u suraj,suraj -b createtables.sql Loader Server Protocol File: 'd:\program files\sapdb\indep_data\wrk\loader.prt' User SURAJ connected to database SAMPLEDB on local host. create table test(name varchar(30), age integer) / create table test1(name varchar(10)) Error during execution -->-25010 SQL error -3014 = Invalid end of SQL statement (error position: 51) Defined maximum number of errors (1) reached 1 error(s) during execution of command file 'createtables.sql'. ---> See log file(s) for more information. Some error(s) occurred running command. ---> See log file(s) for more information. >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> > It seems like, I cannot enter multiple sql commands in the command file, separated by the delimiter "/", as mentioned in the replication manager docs. This works fine, if I have only one command in the command file. Do I need to start any other program, like lserver.exe, or anything else, for repmcli to run ? Please help me out, with the necessary steps, if possible, in order to get this done, because this is an important feature which I require to execute batch DDL and DML statements. Thanks in advance, Suraj. _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
