EXECUTE STATEMENT 구문이 있었군요!!!


SET TERM ^ ;

CREATE PROCEDURE ttttt
AS
BEGIN
  EXECUTE STATEMENT 'SET GENERATOR S_SID TO 0';
  DELETE FROM DAILY;
  DELETE FROM SESSION;
END^

SET TERM ; ^


허진 님이 쓰신 글 :
: 그냥 테이블 초기화하려고 간단히 만들었는데...
: 도무지 프로시져에서 제네레이터 초기화하는 방법을 모르겠네요!
: 어떻게 해야 할까요???
:
:
: SET TERM ^ ;
:
: CREATE PROCEDURE TEST111
: AS
: BEGIN
:   SET GENERATOR S_SID TO 0;//여기서 에러...
:   DELETE FROM DAILY;
:   DELETE FROM SESSION;
: END^
:
: SET TERM ; ^
:
:
: **************************
: Engine Code    : 335544569
: Engine Message :
: Dynamic SQL Error
: SQL error code = -104
: Token unknown - line 10, column 3
: SET