Get Table Names
Description:
Get table names is a step in the Input Plugin for Process Studio Workflows. The Get Table Names step retrieves only table names when the 'Include Tables' option is checked. Secondly, when both 'Include Tables' and 'Include Views' are checked, both types of names are retrieved. Thirdly however, when only 'Include views' is checked, nothing is returned. In order to handle the third scenario when you need on View names you may 'Include Tables' and 'Include Views' and add a filter rows step to get rid of the unwanted table names.
Configurations:
| Field Name | Description |
|---|---|
| The files tab is where you define the location of the XML files from which you want to read. | |
| Step Name | Specify the name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow. |
| Connection | This defined the connection to the database. |
| Schema Name | The name of the Schema to retrieve tables. |
| Get Schema from field | Enable checkbox to get schema name from field. |
| Schema Name Field | Enter the fieldname to get schema name. |
| Settings: | |
| Include catalogs | Enable checkbox to see catalogs. |
| Include schemas | Enable checkbox to see schemas. |
| Include tables | Enable checkbox to see tables. |
| Include views | Enable checkbox to see views. |
| Include procedures | Enable checkbox to see procedures. |
| Include synonyms | Enable checkbox to see synonyms. |
| Add schema in object | Enable checkbox to prefix schema name to ‘Tablename Fieldname’. |
| Output Fields: | |
| Table name Fieldname | Specify an output fieldname to contain Table/Object name. |
| Object type fieldname | Specify an output fieldname to contain Database Object Type. |
| Is system object fieldname | Specify an output fieldname to contain a Boolean value: Is it a system object(Y/N). |
| Creation SQL fieldname | Specify an output fieldname to contain the SQL script for the object creation. |