Dusan Kolesar wrote :
>Hello,
>When I Try:
> CREATE TRIGGER logfileupdete FOR logfile AFTER INSERT EXECUTE
> (
> IF NOT EXISTS TABLE iud THEN
> CREATE TABLE iud
> (
> id Integer NOT NULL DEFAULT SERIAL (1),
> tb_name Char (30) ASCII,
> operation Char (30) ASCII,
> row_id Integer,
> PRIMARY KEY ("id")
> );
> INSERT INTO admin.iud (tbname, operation, row_id) VALUES ('logfile',
>'append', :new.id);
> )
>SAP DB gives me next message:
> Syntax error or access violation;-3008 POS(82) Invalid keyword or missing
>delimiter.
>and there is highlighted "TABLE" in expresion "IF NOT EXIST TABLE uid
>THEN".
>It is not posible to use this statement in the trigger, or what I do
>incorrect?
For sql statements available in a trigger please have a look into the documentation
http://www.sapdb.org/htmhelp/e0/ed9036dfe4b903e10000009b38f889/frameset.htm
There you will find that neither the <exists table statement> nor the <create table
statement>
are allowed.
Regards,
Thomas
--
Thomas Anhaus
SAP DB, SAP Labs Berlin
[EMAIL PROTECTED]
http://www.sapdb.org/
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
