SCRIPT
BEGIN
   DECLARE TableCheckCursor CURSOR for TableCheck;
   DECLARE LastJobNumber Integer DEFAULT 3;

  PREPARE TableCheck FROM '
     Select * From information.TemporaryTables Where Name = ?
  ';
 
  BEGIN
    OPEN TableCheckCursor using 'zzTest1';
    IF RowCount(TableCheckCursor) > 0 then
      EXECUTE IMMEDIATE 'Drop Table zzTest1';
    END IF;
    CLOSE TableCheckCursor;
   EXCEPTION
  END;

  BEGIN
    OPEN TableCheckCursor using 'zzTest2';
    IF RowCount(TableCheckCursor) > 0 then
      EXECUTE IMMEDIATE 'Drop Table zzTest2';
    END IF;
    CLOSE TableCheckCursor;
   EXCEPTION
  END;

  EXECUTE IMMEDIATE '
      Create Temporary Table zzTest1 (
      "Number" INTEGER DEFAULT 0 
      )';

  EXECUTE IMMEDIATE '
      Insert Into zzTest1 (Number) Values (1), (2), (3), (4), (5)
   ';

  EXECUTE IMMEDIATE '
      Create Temporary Table zzTest2 as (
         Select Number
         From zzTest1
         Where Number >= ?
      ) with data
   ' Using LastJobNumber;
END