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
