SQL Transform to XML Schema inputs - Portlet Factory v6.1.2

Portlet Factory, Version 6.1.2

SQL Transform to XML Schema inputs

This topic describes the inputs for the SQL Transform to XML Schema builder.

Table 1. SQL Transform to XML Schema inputs
Input Name Description
Name Name for this builder call. The WebSphere Portlet Factory Designer displays this name in the builder call list.
Generate Schema Select a radio button to determine when the schema is to be created.

On Designer Regen

Schema is created every time the model is regenerated within IBM® WebSphere Portlet Factory Designer.

On Every Regen

Schema is created every time the model is generated within WebSphere Portlet Factory Designer and the application server.

Only When SQL Builder Changes Are Detected

Select this option to generate a schema and preserve it (unchanged) on subsequent model generations. If a subsequent change is made to this builder, a new schema is generated.

Generation Input Settings

Statement Type Select the type of SQL statement is to be used in generating the XML schema.

Individual SQL Statement

To generate a schema based on a manually selected combination of the SQL DataSource, SQL Statement, and the SQL Transform to XML builder.

Step Within a SQL transaction

To generate a schema based on the combination of the SQL DataSource, SQL Statement, and the SQL Transform to XML builder defined as a specific step in an SQL Transaction builder.

SQL DataSource Select a previously defined data source that will provide the JDBC connection on which to execute the selected SQL statement.
Note: This input is only displayed if Individual SQL Statement is selected for the Statement Type input.
SQL Statement Select a previously defined SQL Statement whose result set is to be used for generating the XML schema.
Note: This input is only displayed if Individual SQL Statement is selected for the Statement Type input.
SQL Transform Select a previously defined SQL Transform that will generate sample XML data from the result set obtained from the executed SQL statement.
Note: This input is only displayed if Individual SQL Statement is selected for the Statement Type input.
SQL Transaction Step Select a transaction step from a previously defined SQL Transaction that defines the SQL DataSource, SQL Statement, and SQL Transform to be used in generating the schema.
Note: This input is only displayed if Step Within a SQL transaction is selected for the Statement Type input.

Parent topic: SQL Transform to XML Schema builder

Library | Support |

Input Name	Description
Name	Name for this builder call. The WebSphere Portlet Factory Designer displays this name in the builder call list.
Generate Schema	Select a radio button to determine when the schema is to be created. On Designer Regen Schema is created every time the model is regenerated within IBM® WebSphere Portlet Factory Designer. On Every Regen Schema is created every time the model is generated within WebSphere Portlet Factory Designer and the application server. Only When SQL Builder Changes Are Detected Select this option to generate a schema and preserve it (unchanged) on subsequent model generations. If a subsequent change is made to this builder, a new schema is generated.
Generation Input Settings
Statement Type	Select the type of SQL statement is to be used in generating the XML schema. Individual SQL Statement To generate a schema based on a manually selected combination of the SQL DataSource, SQL Statement, and the SQL Transform to XML builder. Step Within a SQL transaction To generate a schema based on the combination of the SQL DataSource, SQL Statement, and the SQL Transform to XML builder defined as a specific step in an SQL Transaction builder.
SQL DataSource	Select a previously defined data source that will provide the JDBC connection on which to execute the selected SQL statement. Note: This input is only displayed if Individual SQL Statement is selected for the Statement Type input.
SQL Statement	Select a previously defined SQL Statement whose result set is to be used for generating the XML schema. Note: This input is only displayed if Individual SQL Statement is selected for the Statement Type input.
SQL Transform	Select a previously defined SQL Transform that will generate sample XML data from the result set obtained from the executed SQL statement. Note: This input is only displayed if Individual SQL Statement is selected for the Statement Type input.
SQL Transaction Step	Select a transaction step from a previously defined SQL Transaction that defines the SQL DataSource, SQL Statement, and SQL Transform to be used in generating the schema. Note: This input is only displayed if Step Within a SQL transaction is selected for the Statement Type input.