Hi, Dropping the tables first has no effect. Find the zipped trace appended. Unfortunately, it contains the trace of multiple runs, since I don't know yet how to get the trace for only one run with my trace script. Find my trace script appended.
Regards,
CTB
P.S.: Thank you for the quick answer.
"Paskamp, Marco" schrieb:
>
> Hello,
> I cannot confirm this error in my environment. Are you shure the tables doesn't
>exist before you execute the program? I've got this error if I run the program twice,
>because in the second run the tables already exist. To be sure add a DROP TABLE to
>the main function of the test.
>
> int main (int argc, char *argv[])
> {
> ...
> if (Connect(argv[1],argv[2],argv[3],argv[4])) { exit(1);}
>
> EXEC SQL DROP TABLE X;
> EXEC SQL DROP TABLE Y;
>
> if (Update("create table X(f integer)")) { RollBack(); goto disconn;}
> if (Update("create table Y(f integer)")) { RollBack(); goto disconn;}
>
> ...
> }
>
> When the error still occurs please send me vtrace
>(http://sapdb.2scale.net/moin.cgi/VTrace) and/or Precompilertrace (environment
>variable SQLOPT=-X) if possible.
>
> Regards,
> Marco
> ----------------------------------------------
> Marco PASKAMP
> SAP DB, SAP Labs Berlin
>
> > -----Original Message-----
> > From: Claus-Thomas Buhl [mailto:[EMAIL PROTECTED]]
> > Sent: Donnerstag, 28. November 2002 14:33
> > To: [EMAIL PROTECTED]
> > Subject: Problems creating more than one table in ESQL program
> >
> >
> > I am hereby reposting what I submitted to this list 3 weeks ago.
> >
> > The appended ESQL program creates 2 tables X and Y.
> > During creation of the second table the following error occurs:
> >
> > Duplicate table name:Y(22) Errorcode = -6000, ISAM = 0
> >
> > This is strange since the table Y does not exist.
> >
> > Furthermore, dropping multiple tables or creating/dropping
> > multiple synonyms also doesn't work.
> >
> > We are using SAP DB 7.3.00.24 on Debian Linux 3.0 (woody).
> >
> > Any glues?
> >
> > Regards,
> >
> > CTB
> > --
> > _______
> > \o/|\o/ Claus-Thomas Buhl
> > | Diplom-Informatiker
> > \_____/ mailto:[EMAIL PROTECTED]
> >
> > H.E.I. GmbH | Wimpfener Strasse 23 | D-68259 Mannheim
> > Fon: +49-(0)621-795141 | Fax: +49-(0)621-795161 | mailto:[EMAIL PROTECTED]
> > http://www.h-e-i.de && http://www.hei.biz && http://www.radpage.com
> >
> _______________________________________________
> sapdb.general mailing list
> [EMAIL PROTECTED]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
--
_______
\o/|\o/ Claus-Thomas Buhl
| Diplom-Informatiker
\_____/ mailto:[EMAIL PROTECTED]
H.E.I. GmbH | Wimpfener Strasse 23 | D-68259 Mannheim
Fon: +49-(0)621-795141 | Fax: +49-(0)621-795161 | mailto:[EMAIL PROTECTED]
http://www.h-e-i.de && http://www.hei.biz && http://www.radpage.com
testcr2.trace.gz
Description: GNU Zip compressed data
#!/bin/sh
SAPDB_INSTANCE=PRODDB
SAPDB_USER=HEIDEMO
SAPDB_PASSWORD=DEMO
TRACEFILE=./testcr2.trace
make clean
export SQLOPT=-X
make
# Start the trace
dbmcli -d ${SAPDB_INSTANCE} -u dbm,dbm util_execute diagnose vtrace default on
# Execute some SQL
./testcr2 localhost ${SAPDB_INSTANCE} ${SAPDB_USER} ${SAPDB_PASSWORD}
# Flush the trace
dbmcli -d ${SAPDB_INSTANCE} -u dbm,dbm sql_execute vtrace
# Create the text representation
dbmcli -d ${SAPDB_INSTANCE} -u dbm,dbm trace_prot akb
# Copy the text representation to a local file
dbmgetf -d ${SAPDB_INSTANCE} -u dbm,dbm -k KNLTRCPRT -f ${TRACEFILE}
# Stop writing of the trace
dbmcli -d ${SAPDB_INSTANCE} -u dbm,dbm util_execute diagnose vtrace default off
