jueves, 8 de marzo de 2018

Prop:sql

DummyFile{PROP:SQL} = 'DROP PROCEDURE MyTempProc'
IF ERRORCODE()
   ...
END

DummyFile{PROP:SQL} = 'CREATE PROCEDURE MyTempProc AS
                       <SQL Statements to execute separated
                         by ;>'
IF ERRORCODE()
   ...
END

DummyFile{PROP:SQL} = 'CALL MyTempProc'
IF ERRORCODE()
   ...
ELSE
   LOOP
      NEXT(DummyFile)

      IF ERRORCODE() THEN BREAK.

      ... your processing ...
   END
END

No hay comentarios.:

Publicar un comentario