bonjour,
Le mardi 04 janvier 2005, Fabrice Bourdel a écrit...
> ># NOT WORKING param_put MAXDATAVOLUMES 1
param_put MAXDATADEVSPACES 1
> ># NOT WORKING param_put MAXLOGVOLUMES 1
param_put MAXARCHIVELOGS 1
> >db_admin
util_connect
util_execute SET LOG AUTO OVERWRITE ON
util_release
[EMAIL PROTECTED] wrote:
>
> For old sql queries in version 7.3 like:
>
> select a.*,b.*,c.*,d.* from a,b,c,d where
> a.id1 = b.id1 and a.id2 = c.id2 <...> on so on.
>
> if you alter this same query to use JOIN syntax instead of the equals
> conditions then the query runs in 7.5.0.18 &.19. If yo
For old sql queries in version 7.3 like:
select a.*,b.*,c.*,d.* from a,b,c,d where
a.id1 = b.id1 and a.id2 = c.id2 <...> on so on.
if you alter this same query to use JOIN syntax instead of the equals
conditions then the query runs in 7.5.0.18 &.19. If you add the old style
join syntax (+) then
Hello,
I wish to include in my database creation script
a commande for activating the log automatic
overwrite (just for developement).
Could you please tell me witch is the command (and
where in the script) ?
Another question, MAXDATAVOLUMES, MAXLOGVOLUMES and
MAXSERVERTASKS haven't their initial
A error occur while compile MAXDB 7.7.1... the error "Duplicate case labels" in
gsp00 ,many erros of dependency and assingment errors whith array of char
defined in gsp00. what i do to solve this problem?
-
Yahoo! Acesso Grátis - Internet rápida
Hi all,
I try to install a Python 2.3.4 based MaxDB Client with use of
maxdb-scriptif-7.5.0.19-1.i386.rpm
I did export PYTHONPATH="/opt/sdb/interfaces/python/misc:/usr/lib/python2.3"
and did a simple import of sapdb.sql. Below is the resulting ImportError:
client:/opt/sdb/interfaces/python # pyt
> hello,
>
> I wanted to set the transaction isolation level of a jdbc connection to
> java.sql.Connection.TRANSACTION_READ_UNCOMMITTED.
> As I discovered some error-messages like "too many lock requests" I
> wondered, why there are any lock-requests when I use this isolation-level
(dirty
> read
I'm sorry Elke, I had click in reply, and forgot to change
subject, I´m so sorry.
Well, my knldiag.err its paste at end. current version:
Sapdb: 7.3.0.40
MaxDb version: 7.5.0.19
The original question is:
>Hi! forgives the question that must be a little tiring to all, but I
>can´t had success on
Hi Daniel,
The JDBC driver already does this translation. For details please have a
look at com.sap.dbtech.jdbc.DriverSapDB:
static String
isolevelJdbc2native (
int isolevel)
throws SQLException
{
String result;
switch (isolevel) {
case Connection
hello,
I wanted to set the transaction isolation level of a jdbc connection to
java.sql.Connection.TRANSACTION_READ_UNCOMMITTED.
As I discovered some error-messages like "too many lock requests" I wondered,
why there are any lock-requests when I use this isolation-level (dirty reads
are ok fo
hello,
I wanted to set the transaction isolation level of a jdbc connection to
java.sql.Connection.TRANSACTION_READ_UNCOMMITTED.
As I discovered some error-messages like "too many lock requests" I wondered,
why there are any lock-requests when I use this isolation-level (dirty reads
are ok for
Fabiano Rech wrote:
>
> Hi! forgives the question that must be a little tiring to all, but I
> can´t had success on migration of SapDB 7.3 to MaxDB 7.5.
> I followed all the steps in the message:
> http://lists.mysql.com/maxdb/23792 , but when in restore the
> backup I get the following error:
>
Elbertus Lochtenberg wrote:
>
> Dear reader,
>
> I tried to attach the vtrace output file of the MaxDB crash using
> embedded SQL statements in ORACLE mode to the list mail message.
>
> Because of the original vtrace file size, that in plain text format
> overrides the maximum size of the list m
Implication as explained(YES:.../NO:...). Therefore we save time for detection
of execution plan. The optimizer works a little bit like a rule based optimizer
(unlike our cost based optimizer). If an access path is good for a query use it
for every query with same query template (query w/o param
14 matches
Mail list logo
