Configuring Metadata of SQL statements manually

SQL statements that end with a semicolon(;) are auto parsed and the metadata is populated in the table field. If schema retrieval fails due to some reason, and the query is correct, then you can manually configure the metadata (by setting the Manually Configure Metadata option to true).

When Manually Configure Metadata is true, you can enter a simplified query in the text box and click Fetch .

Modifying Table Schema

When Manually Configure Metadata is set to true, the Table Schema is editable. You can modify the Table Schema by adding or deleting rows or changing the selections.

Note: When modifying the Table Schema, ensure that the changes made are supported by a valid SQL statement entered in the text area.

Manually configuring metadata for insert, update, delete, query activities

Procedure

Set the Manually Configure Metadata option to true.
Make the modifications as required:
- To modify a Table Schema, add or delete rows as required and change the selections by selecting or clearing checkboxes.
  - The selected table fields are displayed on the Output tab of the activity.
  - The fields selected in the Parameter column are displayed on the Input tab of the activity.
- To clear the metadata information in the table, click Clear Table.
Click Save.

Manually Configuring metadata for Call Procedure activity

Set the Manually Configure Metadata option to true.
Make the modifications as required:
- To modify Table Schema, edit the data type and add the expected data type. Edit the direction based on the direction of the parameter mentioned in the procedure definition.
  - OUT: The table fields are displayed on the Output tab.
  - IN: The table fields are displayed on the Input tab.
  - INOUT: The table fields are displayed on both the Input and Output tabs.
  - For output parameters with the cursor type, set the data type as REFCURSOR.
- To clear the metadata information in the table, click Clear Table.
Click Save.