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:

No.	Field Name	Description
Files Tab:	The files tab is where you define the location of the XML files from which you want to read.
1	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.
2	Connection	This defined the connection to the database.
3	Schema Name	The name of the Schema to retrieve tables.
4	Get Schema from field	Enable checkbox to get schema name from field.
5	Schema Name Field	Enter the fieldname to get schema name.
	Settings:
6 Include catalogs	Enable checkbox to see catalogs.
7	Include schemas	Enable checkbox to see schemas.
8	Include tables	Enable checkbox to see tables.
9	Include views	Enable checkbox to see views.
10	Include procedures	Enable checkbox to see procedures.
11	Include synonyms	Enable checkbox to see synonyms.
12	Add schema in object	Enable checkbox to prefix schema name to ‘Tablename Fieldname’.
	Output Fields:
13	Table name Fieldname	Specify an output fieldname to contain Table/Object name.
14	Object type fieldname	Specify an output fieldname to contain Database Object Type.
15	Is system object fieldname	Specify an output fieldname to contain a Boolean value: Is it a system object(Y/N).
16	Creation SQL fieldname	Specify an output fieldname to contain the SQL script for the object creation.