Imoprt Batch SQL Statements

"Suraj Panicker" <[email protected]>
Newsgroups gmane.comp.db.sapdb.general
Message-ID <[email protected]>
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.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.