Sorry, but still a little question.
Is it possible that "temp" "tab_share" Locks
result from:
- Joined-Selects on several Tables
- DELETE FROM Table WHERE A1=...
- SELECT FROM Table WHERE A1=... AND A2 IN (1,2,3,...)
(perhaps in combination with Lock Escalation?)
In other words:
- The questio
Florian Rieffel wrote:
> I'm using the latest Version of MaxDB 7.5.0.14.
>
> To demonstrate the problem, I've created this tables with content:
>
> -
>
> CREATE TABLE test_1 (
> id int,
> primary key (id)
> )
>
> CREATE TABLE test_2 (
> id int,
> primary
Simple trigger calling a store procedure to do the work
This two scripts new obviously two tables named "companias" and other
named "periodos_contables"
create trigger companias_trigger for companias after insert execute (
Call dba.sp_conta_addPeriodoContable(:NEW.ID_Compania, 'blah blah');
)
hello community,
I'm using the latest Version of MaxDB 7.5.0.14.
To demonstrate the problem, I've created this tables with content:
-
CREATE TABLE test_1 (
id int,
primary key (id)
)
CREATE TABLE test_2 (
id int,
primary key (id)
)
CREATE TABLE test_3 (
id in
Hello everybody,
I desperately need documentation on MaxDB Triggers.
I have the reference manual, I need something more basic with
examples.
I have to translate Oracle PL/SQL and PostgreSQL PL/PGSQL Triggers to
MaxDB.
Here is a PL/PGSQL Trigger, if anyone has the skill and time to
translate this
Sorry, sending my question again:
Scenario:
- We use Isolationlevel 1
- We *do not* use any explicit LOCKS
Questions:
- are the "tab_share" locks caused only by the
Lock Escalation strategy of sapdb, or is there
an other possible cause?
- Does the Dump show a real DEADLOCK?
- Why is the DE
Hi,
can I alter the pasword of SYSDBA with dbmcli?
dbmcli sql_execute ALTER PASSWORD dba newpassword
returns ok, but has no result(?): anyway I have to login with the old
password:
dbmcli -d dbname -u dba,newpassword
-> user authorization failed
dbmcli -d dbname -u dba,oldpassword
-> ok
Thanks,
C
