> Defining Flex SQL Procedures

Follow these steps to define Flex SQL procedures.

1. Open the Flex SQL statement definition form (YMFLXS).

2. Table—Click to select the Datastream 7i table that initiates the event.

3. Trigger—Click to select the database operation that initiates the event. Datastream 7i supports postinsert and postupdate triggers.

4. Sequence number—Enter the order of Flex SQL processing.

5. Comment—Enter a description of the purpose of the Flex SQL statement.

6. SQL statement—Enter the SQL statement to be executed when the specified operation takes place for a table.

7. Failure message—Enter the message to display when the Flex SQL statement fails. A Flex SQL statement is successful when one or more rows in a table are processed by the statement. A Flex SQL statement fails when no rows are processed. To make the failure message active, select Abort on failure.

8. Must exist—Select to make the Flex SQL processor stop processing consecutive Flex SQL statements when no rows are processed by the current statement.

9. Abort on failure—Select to stop the current operation when it fails and issue an error. Specify a failure message if you select this option.

10. Reverse return code—Select to reverse the return status code for the current Flex SQL statement. If selected and the statement processes one or more rows, then the processor returns with a failure status. If the statement processes no rows, then the processor returns a success status.

11. Active—Select to enable the Flex SQL statement.

12. Click Test SQL to ensure that the current Flex SQL statement is valid. If the statement contains errors (invalid syntax, for example), Datastream 7i displays a message.

13. Choose File | Save from the menu bar. Datastream 7i saves the information to the database.