Réduire
Brouillon
0
24/03/2013
0
Sybase - Cursor example
Mots-clés:
Sybase SQL
CREATE PROCEDURE ps_purge @for varchar(10), @typeRun varchar(10), @int nbDays
DECLARE cursorPurge CURSOR FOR
SELECT RunIndex FROM tbRun
WHERE For = @for AND TypeRun = @typeRun AND DateRun < dateadd(dd, -nbDays, getDate())
DECLARE @runIndex numeric(18,0)
OPEN cursorPurge
WHILE @@sqlstatus = 0
   BEGIN
      FETCH cursorPurge INTO @runIndex
      exec ps_purge_run @runIndex
   END
CLOSE cursorPurge
DEALLOCATE CURSOR cursorPurge