PDM Macros

You can use predefined macros in trigger templates, template items, triggers, and procedures. Macros perform specific functions.

• AKCOLN
  Repeats a statement for each alternate key in a table
• ALLCOL
  Repeats a statement for each column in a table
• DEFINE
  Defines a variable and initializes its value
• DEFINEIF
  Defines a variable and initializes its value if the test value is not null
• ERROR
  Handles errors.
• FKCOLN
  Repeats a statement for each foreign key column in a table.
• FOREACH_CHILD
  Repeats a statement for each parent-to-child reference in the current table fulfilling a condition.
• FOREACH_COLUMN
  Repeats a statement for each column in the current table fulfilling a condition.
• FOREACH_PARENT
  Repeats a statement for each child-to-parent reference in the current table fulfilling a condition.
• INCOLN
  Repeats a statement for each primary key column, foreign key column, alternate key column, or non-modifiable column in a table.
• JOIN
  Repeats a statement for column couple in a join.
• NMFCOL
  Repeats a statement for each non-modifiable column in a table. Non-modifiable columns have Cannot Modify selected as a check parameter.
• PKCOLN
  Repeats a statement for each primary key column in a table.
• CLIENTEXPRESSION and SERVEREXPRESSION
  Uses the client and/or server expression of a business rule in the trigger template, template item, trigger, and procedure script.
• SQLXML
  Avoids typing a SQL/XML query in the definition of a trigger, a procedure or a function. Use one of the following tools:

---

Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com