Kbase P17875: How to modify the initial value of MS SQL Server sequence from Procedure editor?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/21/2008 |
|
Status: Verified
GOAL:
How to modify the initial value of MS SQL Server sequence from Procedure editor?
GOAL:
How to modify the initial value of MS SQL Server sequence from Progress?
FACT(s) (Environment):
MS SQL DataServer
MS SQL DataServer
Windows 32 Intel
Windows NT 32 Intel/Windows 2000
FIX:
RUN a STORED-PROCEDURE statement with the send-sql-statetement option and update the sequence value through Transact-SQL;
RUN STORED-PROC send-sql-statement NO-ERROR
UPDATE _SEQT_<sequence name> SET initial_value = 1, increment_value = 1, upper_limit=500, current_value=1