RE: Imoprt Batch SQL Statements

Hey Gustav,

Thanks a lot!! This worked. But, isn't this a bug in the documentation ????

Suraj.

-----Original Message-----
From: Gustav Brock [mailto:[email protected]]
Sent: Saturday, August 23, 2003 4:27 PM
To: [email protected]
Subject: Re: Imoprt Batch SQL Statements


Hi Suraj

Try with double-slashes:

create table test(name varchar(30), age integer)
//
create table test1(name varchar(10))

/gustav


> Date: 2003-08-23 12:46

> 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

_______________________________________________
sapdb.general mailing list
[email protected]
http://listserv.sap.com/mailman/listinfo/sapdb.general