AW: ¿ How to create a Job in Max DB ?

[EMAIL PROTECTED] wrote: > > Hi, I am Jorge Castro and we are using Max DB for an aplication that we > are developing in JAVA. > > We need to execute some procedures monthly for filling a table with the > information at the last day of each month of other tables (Something like > Historical Info

RE: ¿ How to create a Job in Max DB ?

Hello Luis, no, there isn't any tool with MaxDB that does "application work" on a regular base. Write a Java command-line application and use the Windows Scheduler or the 'cron' Program on Unix/Linux to have your Program executed exactly at the time you want it. Regards Alexander Schröder SAP D

changing username/password on the fly for a jdbc connection

Hi, If I have a jdbc connection with username A. Is it possible to “on the fly” switch the connection to another username B.(And then later switch back to username A) I want to avoid creating an extra connection in this scenario. Regards, Ajit P.S. I know one solution would be would be to grant A

Re: Query optimization problem

Euke Castellano schrieb: Hi all, I have the following table definition: CREATE TABLE "CONSUM"( ... I also have an UNIQUE INDEX created on column INVOICEDATE. The table has ~25.000.000 rows. Normal Index OK, I read the second Message... When I try a query like:SELECT * FROM consum WHERE invoice

¿ How to create a Job in Max DB ?

Hi, I am Jorge Castro and we are using Max DB for an aplication that we are developing in JAVA. We need to execute some procedures monthly for filling a table with the information at the last day of each month of other tables (Something like Historical Info Tables). For that, we thought to run

MaxDB applications and client don't quote identifiers

Hi, in a discussion with Thomas Simenec he told me, that in some cases, the applications like the DBMGUI don't quote identifiers correctly. If you create a user for example, the DBMGUI will send the statement CREATE USER myuser PASSWORD mypass You should notice, that there are no "" around the u

RE: problem with starting SAPDB instance

>When I am trying to start my SAPDB instance I get message : >-24994 runtime enviroment error;kernel start failed. >I've checked knldiagerr file. Here's two error messages I've found : > >2005-01-02 16:01:54 0xA1C ERR 18177 DEVIO No devspace on >compressed file 'knltrace' You are not allowed to c

RE: [BUG?] unable to connect with PHP

Hi, To summarize an internal discussion: The password string in maxdb_connect() is case sensitive. If you create a new user with MaxDB, as long as the username and password are not enclosed within quotation marks, the username and password are set to uppercase by the database kernel. For a case

problem with starting SAPDB instance

When I am trying to start my SAPDB instance I get message : -24994 runtime enviroment error;kernel start failed. I've checked knldiagerr file. Here's two error messages I've found : 2005-01-02 16:01:54 0xA1C ERR 18177 DEVIO No devspace on compressed file 'knltrace' 2005-01-02 16:01:54 0xA1C ERR

RE: [BUG?] unable to connect with PHP

Hi, As I can not reproduce your connect problem using a UNICODE database, please send me a SQLDBC SQL trace. You can switch on this trace by sqldbc_cons config trace sql on You get the location of the trace file by sqldbc_cons show all Regards, Thomas Simenec SAP Labs Berlin -Origin

Re: [BUG] sources of php-extension also contains windows linefeed

Thank you for reporting the linefeed problem. It will be fixed with the next release on http://www.mysql.com and http://pecl.php.net. In the meantime you can download the sources for the PHP extension without Windows linefeeds from the PHP CVS: http://cvs.php.net/pecl/maxdb. Is the version in the

RE: [BUG] sources of php-extension also contains windows linefeed

Hi, Thank you for reporting the linefeed problem. It will be fixed with the next release on http://www.mysql.com and http://pecl.php.net. In the meantime you can download the sources for the PHP extension without Windows linefeeds from the PHP CVS: http://cvs.php.net/pecl/maxdb. Regards, Thom

[BUG?] unable to connect with PHP

Hi, the following PHP-code won't connect to my database: Username and Databasename are given in uppercase. The error message is: Warning: maxdb_connect(): -4008 POS(1) Unknown user name/password combination [08004] in ... The same access data works with DBD::MaxDB, SQLStudio and the JDBC-driver.

[BUG] sources of php-extension also contains windows linefeed

Hi, it's just a glitch, but the source for the PHP-extension, that can be downloaded, contains windows linefeed. It therefor may confuse linux/uni-admins to see "command not found" when executing the configure-script (the 0x0D is seens a seperate command by the shell, kind of ridiculous, but th

AW: 7.5.0.23 & 7.6.00.00.3264 JDBC

Kevin Wilson wrote: > > According to the change log for 7.5.0.23 you fixed the problem (quoted > below) where unclosed cursors chew up temp space...well it still happens > with apps even when using the latest jdbc driver. > Do you use many CALL-statements to call dbprocedures? Then PTS 1133463 f

AW: Instance_type changed after Upgrade

Dirk Zugenmaier wrote: > > Hi, > > after upgrading from SapDB 7.3.0.24 to MaxDB 7.5.0.16 we experienced > some troubles with Indexes not beeing used. So we upgraded to MaxDB > 7.5.0.23. > > But now the Instance_type of the Database has suddenly changed. > Previously we used the BW-Type AFAIK (No

CVS problems - 'cannot close CVS/Entries'

While trying to checkout I'm getting this: [...] ? maxdb-7500/sys/src/install56/perl/SAPDB/Install/Diagnose/.nbattrs ? maxdb-7500/sys/src/install56/perl/SAPDB/Install/Diagnose/I386_SVR4_32 ? maxdb-7500/sys/src/install56/perl/SAPDB/Install/Diagnose/I386_SVR4_32 cannot close CVS/Entries No space lef

RE: 7.5.0.23 & 7.6.00.00.3264 JDBC

Hello Kevin, do you have something more specific on your error? The -904 is unfortunately a relatively generic error, which only indicates that - ehm - the temporary space is exhausted. What we have fixed may be one case, but it is of course possibly that you've a problem that slipped through.