Martin Cordova wrote :
>
> I checked sequence definitions via SQLStudio, "Cached values" is
> disabled, without information.
>
> SEQUENCE_CACHE = 1 according to DBM.
>
> Is there anything else to check?
>
> I created the sequence like: create sequence seq_xxx start with 1
> Did it assume a def
Robert, it was cache indeed. By default sequences assume a cache of
20. I had to recreate the sequence like:
create sequence seq_xxx start with nnn NOCACHE
Otherwise it will jump after the restart.
Thank you for pointing me to the right direction.
Best regards,
Martin
On 7/4/06, Martin Cord
I checked sequence definitions via SQLStudio, "Cached values" is
disabled, without information.
SEQUENCE_CACHE = 1 according to DBM.
Is there anything else to check?
I created the sequence like: create sequence seq_xxx start with 1
Did it assume a default cache of 20 or something?
Regards,
Mar
Hi
I have a small problem, we have Sap install on MaxDB version 7.5.00.35
T933 -1 Utility 864462 Vsuspend (212) ! 0 0
272(s)
The command "dbmcli -d SB1 -u control,compaq db_cons cancel 93" does not
kill it and
My Log file is already at 57%, It does not allow me to backu
H wrote:
>
> version:7.5.00.34
> platform: Windows 32
>
> This is the same problem I am still working on. I found
> that the 'IGNORE TRIGGER' compiles or works in a trigger statement.
>
> Question: Is the IGNORE TRIGGER syntax supposed to work in
> a procedure?
>
No,
Alexey Gaidukov wrote:
>
> Can somebody help me?
>
> select getQuant('155') from dbadmin.dual
> returns correct value without exception
>
> The statement
>
> SELECT *
> FROM invest
> WHERE cartnum=6280 and i.dateres='2006-05-25'
>
>
> returns one record
>
> but why
>
> SELECT getQuant('155
