Hi
I am aware of the simple drop solution however it does not serve the purpose.
The DROP method is not really a solution as the sequence is unavailable for a (short)
time.
Doesn't SAPDB have an equivalent like the following
In Oracle
Update sequencename set next_value=xxxx
In PostgreSQL
Select setval('sequencename',xxxx) <--Yes it's a select !!!! :-)
Regards,
Ajit
-----Original Message-----
From: Zabach, Elke [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 18, 2002 5:45 PM
To: ajit_cus; [EMAIL PROTECTED]
Subject: RE: setting SEQUENCE values -urgent
ajit_cus wrote:
>
> Hi,
> I need to set the current/next value of a sequence in
> SAPDB.I could'nt figure out the syntax for a setval() under SAPDB.
> How do I do this? (Preferably a solution that works in
> SQLMODE ORACLE also)
for internal mode:
drop the sequence
recreate it using START WITH <integer>
for SQLMODE ORACLE it should work, too
Elke
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
