I just want to close this thread.
We upgraded our server to SAPDB V7.3.0.32 and it's now possible
to create/drop multiple tables/views in an ESQL program.
Regards,
CTB
Claus-Thomas Buhl schrieb:
>
> Hi,
>
> Yesterday we found that creating and dropping a view in an ESQL program
> also does not work.
> Could you find anything in the vtrace I sent you end of November?
>
> Regards,
>
> CTB
>
> Claus-Thomas Buhl schrieb:
> >
> > 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
> >
> > ------------------------------------------------------------------------
> > Name: testcr2.trace.gz
> > testcr2.trace.gz Type: application/x-gzip
> > Encoding: base64
> >
> > ------------------------------------------------------------------------
> > #!/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
>
> --
> _______
> \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
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
