Re: show tables / describe table

2005-02-08 Thread Dusan Kolesar
Hello, Try next (use SQL studio): SELECT * FROM DOMAIN.TABLES WHERE TYPE = 'TABLE' // SELECT * FROM DOMAIN.COLUMNS WHERE TABLETYPE = 'TABLE' The results are similar to MySql show and describe statements. Dusan On Tue, 8 Feb 2005 14:04:38 +, MaxDB SAP <[EMAIL PROTECTED]> wrote: Hi List, I am new

[ANN] Gentoo ebuild for DBD::MaxDB

2005-02-08 Thread Sven Köhler
Hi, at http://bugs.gentoo.org/show_bug.cgi?id=81321 you'll find a Gentoo ebuild for DBD::MaxDB. Note: It does not depend on the server or SQLDBC being installed. Instead it downloads and uses the precompiled version of libSQLDBC_C.so and installs it along with DBD::MaxDB. Therefor it depends on

Re: Bug for using MaxDB with UnixODBC

2005-02-08 Thread Sven Köhler
DBI connect('DATABASE','ADMIN',...) failed: [unixODBC][MySQL MaxDB][LIBSQLOD SO][MaxDB] Unable to connect to data source;-709 CONNECT: (unknown host dbsrv (see /etc/hosts)) (SQL-08001)(DBD: db_login/SQLConnect err=-1) at /root/perltest/connect_maxdb.pl line 10 I see you're using Perl and DBD

RE: An Enterprise Portal backup question..

2005-02-08 Thread Döhr, Markus ICC-H
> We have EP install on HP-UX 64-bit, and Oracle 9.0.2 64-bit. > The backup tool is EMC's EDM (which uses backint) > > What do I need to download to have MaxDB work in this ebnvironment? SAPDB/MaxDB is a database itself. If you'd like to use backint to backup check the Oracle library (and/or use

An Enterprise Portal backup question..

2005-02-08 Thread Joseph Eustace
Greetings, The SAP library is a little confusing. I hope you can clear this up for me. We have EP install on HP-UX 64-bit, and Oracle 9.0.2 64-bit. The backup tool is EMC's EDM (which uses backint) What do I need to download to have MaxDB work in this ebnvironment? Regards, Joe Eustace S

RE: phpmysqladmin == phpmaxdbadmin ?

2005-02-08 Thread Simenec, Thomas
Hi, Currently there is no PHP tool like phpmysqladmin to administer MaxDB. Regards, Thomas Simenec SAP Labs Berlin -Original Message- From: MaxDB SAP [mailto:[EMAIL PROTECTED] Sent: Dienstag, 8. Februar 2005 18:27 To: maxdb@lists.mysql.com Subject: phpmysqladmin == phpmaxdbadmin ? Is

ANN: MaxDB Debian packages for 64bit

2005-02-08 Thread Martin Kittel
Hi, as of today there are Debian packages of MaxDB available for ia64 in unstable. Due to lack of hardware I could not verify that the packages are actually working and therefore would welcome any positive and negative feedback. Although there are no official binary packages available for othe

phpmysqladmin == phpmaxdbadmin ?

2005-02-08 Thread MaxDB SAP
Is there any web based tool to administer maxdb similar to phpmysqladmin to run with php? -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: show tables / describe table

2005-02-08 Thread MaxDB SAP
Thanks friends. On Tue, 8 Feb 2005 17:44:30 +0100, Jean-Michel OLTRA <[EMAIL PROTECTED]> wrote: > >bonjour, > > Le mardi 08 février 2005, Jean-Michel OLTRA a écrit... > > > > Use ireport, nice tool indeed. > > Oops, `ireport` is an alias of mine. Sorry. > > Use /bin/ireport.py > > --

Re: show tables / describe table

2005-02-08 Thread Jean-Michel OLTRA
bonjour, Le mardi 08 février 2005, Jean-Michel OLTRA a écrit... > Use ireport, nice tool indeed. Oops, `ireport` is an alias of mine. Sorry. Use /bin/ireport.py -- jm -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.my

AW: Error assigning a string to a date type in a DBPROC

2005-02-08 Thread Anhaus, Thomas
Luis Jorge Castro wrote : >I am trying in a DBPROC to assign a char variable to a date >variable but >there is a message "Datetime field overflow;-3048 POS(1) >Invalid date format:ISO". ¿How can I convert the string to a >date variable? > >The procedure is the next: >**

Re: show tables / describe table

2005-02-08 Thread Jean-Michel OLTRA
bonjour, Le mardi 08 février 2005, MaxDB SAP a écrit... > Mysql> show tables; > Mysql> describe table. Use ireport, nice tool indeed. ireport -d database -u user,passwd then enter the `help` command, and you will see available commands try `help table`, `table`, `table pattern` (pattern

AW: show tables / describe table

2005-02-08 Thread Zabach, Elke
MaxDB SAP wrote: > > Hi List, > > I am new to MAXDB and want to know is there any function in MAXDB like > MySQL to show all tables in a database and describe table in a > database. > > Mysql> show tables; > Mysql> describe table. Please have a look into the description of systemtables, where f

show tables / describe table

2005-02-08 Thread MaxDB SAP
Hi List, I am new to MAXDB and want to know is there any function in MAXDB like MySQL to show all tables in a database and describe table in a database. Mysql> show tables; Mysql> describe table. Thanks in Advance. MAXDB PHP -- MaxDB Discussion Mailing List For list archives: http://lists.mysq

AW: AW: catalogload said talbe is readonly

2005-02-08 Thread Schildberg, Steffen
Hi Gu Lei, Gu Lei [mailto:[EMAIL PROTECTED] wrote: > There's another question. > I used only_fk to create foreign keys after TABLELOAD USER finished. > Loadercli would show me an error about integrity if I created foreign keys before TABLELOAD USER. > It seems that TABLELOAD doesn't take into acc

RE: How to remove "DEFAULT SERIAL (1)" from column with SQL Studio

2005-02-08 Thread Auer, Wolfgang
Hello Claus, try in the SQL Dialog the statement ALTER TABLE "TESTUSER"."TEST" COLUMN "ID" DROP DEFAULT Regards Wolfgang -Original Message- From: Claus Windeler [mailto:[EMAIL PROTECTED] Sent: Dienstag, 8. Februar 2005 11:46 To: maxdb@lists.mysql.com Subject: How to remove "DEFAULT S

How to remove "DEFAULT SERIAL (1)" from column with SQL Studio

2005-02-08 Thread Claus Windeler
Hello! I set "DEFAULT SERIAL (1)" on an integer column and now I want to remove or modify it with "Alter Table" in SQL Studio. But I always get an error message like General error;-4018 POS(39) Unknown default ALTER TABLE "TESTUSER"."TEST" COLUMN "ID" ALTER DEFAULT NULL General error;-4018 POS(

AW: AW: question about ALPHA and SOUNDEX function

2005-02-08 Thread Josu
Hallo, > -Ursprüngliche Nachricht- > Von: Josu [mailto:[EMAIL PROTECTED] > Gesendet: Montag, 7. Februar 2005 16:52 > An: Zabach, Elke > Betreff: Re: AW: question about ALPHA and SOUNDEX function > > ALPHA issue: > > We have an unicode database but the columns where we apply the ALPHA > fun