Checking For an Object Using SQL Queries
The second check is to verify the existence of the 'DB2AUTH.USERS' table. It's actually very similar to the first check that we did. The differences are highlighted in yellow on the right.
Steps:
- Copy or enter the text from the right into the file
- Don't forget the closing action and task tags at the end of the page!
We give our new action (not actionScript this time) a new name. Then, we define our new parameters:
- This time our action is to check for an object (a table), so the value is set to 'checkForObject'
- We want to look for a table, so the object type is 'table'
- The table's schema is 'DB2AUTH'
- The table name is 'USERS'