problem with overwriting the default delete procedure

[katherine]

Hi,

I would like to overwrite the default delete procedure.

Here is my procedure:

FOR EACH ROW

BEGIN ATOMIC

DELETE FROM NativeModel.FIELD WHERE ("NEW".field_name = NativeModel.FIELD.NAME) AND ("NEW".project_name = NativeModel.FIELD.PROJECT_ID);

END

However, I got the following build error:

ERROR: TEIID31119 Symbol "NEW".field_name is specified with an unknown group context

What is wrong? Please help.

Thank you.

Katherine

[shawkins]

Delete does not have a concept of "new" (that's only for insert/update). Delete and update have access to "old".

Steve

[katherine]

Steven,

Thank you so much. I make it works now.

Katherine