Elke Schmidtke wrote :
>
>Hi Elke,
>
>I receive the message during creation of the trigger.
>The table does not exist in the moment of creation.
>
>The original code I want to use in the trigger is
>TRY
> DELETE FROM TEMP.ATZ_VIEW;
>CATCH
> CREATE TABLE TEMP.ATZ_VIEW (...);
>
>Procedur
Hi Elke,
I receive the message during creation of the trigger.
The table does not exist in the moment of creation.
The original code I want to use in the trigger is
TRY
DELETE FROM TEMP.ATZ_VIEW;
CATCH
CREATE TABLE TEMP.ATZ_VIEW (...);
Procedures work perfect with code like this,
Elke Schmidtke wrote:
>
> Hi,
> I try to create a temp table in a trigger:
> CREATE TRIGGER TR_INSUPD_ATZ_WB FOR DBA.T_ATZ_WB
> AFTER INSERT, UPDATE EXECUTE (
> CREATE TABLE TEMP.ATZ_VIEW (
> BEGINN DATE,
> ENDE DATE,
> BESETZTE_STD FIXED(5,2),
> FREIE_STD FIXED(5,2),
>
