Converter entities have two blocks, a standard block and an executable block. The standard block executes a query against the database table from which the data is obtained, while the executable block takes that data and converts it into the new database table.
The Standard Block must have a Z order of 1.
The Executable Block must have a Z order of 2.
This section includes:
In the Explorer Tree, locate the object for which you wish to modify a block.
Expand the Template Information object and select the template converter for which you wish to modify a block.
Expand the Group Information object and any sub-groups until you can select the converter for which you wish to modify a block.
Expand the converter and select the block that you wish to modify.
Display the block properties. These will either be displayed in Alphabetical or Logically, depending on the setting of the [Sort Alphabetically/Logically] button. The following instructions are assuming that the properties are sorted logically.
In the Name property, the name entered during block creation is displayed, and can be changed, if desired.
In the Description property, enter the user-defined description for the block.
In the Parent property, the name of the parent block of this block is displayed. If this is the top level block in the hierarchy, the property will display (entity root).
In the Type pop-list, Standard Block or Executable Block will be displayed.
In the Mutability pop-list, select whether this block can be modified on converters that are created from this template. This option is ONLY available for template converters.
When set to Fully Mutable, the block is placed on all converters that inherit from this template and can be modified or deleted.
When set to Positionally Mutable, the block is placed on all converters that inherit from this template and can only be moved.
When set the Not Mutable, the block is placed on all converters that inherit from this template and cannot be modified in anyway.
In the Query Type property, select
the type of query that this block will execute against the database. Choices
are Simple Query, Complex Query, Xephr Service, and Xephr Interconnect.
Xephr Service indicates that the query for this block will be from
a xephr service. When Xephr Service is selected,
the Datasource and Table properties are displayed. These
properties are used to construct the information returned by the Xephr
service.
In the Datasource pop-list, the original value from block
creation is displayed, but can be changed, if desired.
The datasource for a Xephr Service block must be a Xephr service datasource.
Only Xephr service datasources will be displayed
for selection for this property.
In the Table property, the original value from block creation is displayed, but can be changed if desired. Select the Xephr service method from which the data will be displayed on this block. Choices are determined by the datasource selected.
Depending on the Table selected, one or more parameter (PARAM) properties will be displayed. Enter the appropriate values for the parameters. The parameters assigned to each service type are used to restrict the values returned from the Xephr service.
In the Z Order property, enter a number to define the order in which the block will be generated on the entity. The higher the number, the later the block will be generated. The Z order is specific to the indention level in the entity tree.
The Created on property displays the date and time on which this block was created, and cannot be changed.
The Modified on property displays the date and time on which this block was last changed, but cannot be modified.
When all changes have been made, press the [Save] button in the Main Toolbar.
In the Explorer Tree, locate the object for which you wish to modify a block.
Expand the Template Information object and select the template converter for which you wish to modify a block.
Expand the Group Information object and any sub-groups until you can select the converter for which you wish to modify a block.
Expand the converter and select the block that you wish to modify.
Display the block properties. These will either be displayed in Alphabetical or Logically, depending on the setting of the [Sort Alphabetically/Logically] button. The following instructions are assuming that the properties are sorted logically.
In the Name property, the name entered during block creation is displayed, and can be changed, if desired.
In the Description property, enter the user-defined description for the block.
In the Parent property, the name of the parent block of this block is displayed. If this is the top level block in the hierarchy, the property will display (entity root).
In the Type pop-list, Standard Block or Executable Block will be displayed.
In the Mutability pop-list, select whether this block can be modified on converters that are created from this template. This option is ONLY available for template converters.
When set to Fully Mutable, the block is placed on all converters that inherit from this template and can be modified or deleted.
When set to Positionally Mutable, the block is placed on all converters that inherit from this template and can only be moved.
When set the Not Mutable, the block is placed on all converters that inherit from this template and cannot be modified in anyway.
In the Query Type property, select
the type of query that this block will execute against the database. Choices
are Simple Query, Complex Query, Xephr Service, and Xephr Interconnect.
Simple Query indicates that the block is taken from a simple query
to a database table/view.
The Simple Query option will be chosen most often for database blocks.
The database query will be constructed from the entries in the additional
properties.
In
the Datasource pop-list, the original value from block creation is displayed,
but can be changed, if desired.
Selecting (use default) will allow the converter or template to be
used with any datasource, and data brought in will be determined by the
converter's or template's datasource.
In the Table property, the original value from block creation is displayed, but can be changed if desired. Select the desired table/view from which the data will be displayed on this block.
In the Select Statement property,
enter the select statement for your database query, beginning with the
word SELECT. The select statement lists the columns
in the table or view from which the data will be returned.
Simple Query blocks will have the data in this property generated automatically.
All columns selected from the database need to
be explicitly named.
Format: SELECT column, column, column,
column FROM view
For example: SELECT item_no, description, stock_um, qty_on_hand FROM
item_master_uvw
In the Filters property, enter the
additional or overriding filters to restrict the information returned
by the select statement for this block, if appropriate. This
is also referred to as the where clause. The statement
begins with the word WHERE.
Format: WHERE column (comparison)
value AND column (comparison)
value
For example: WHERE qty_on_hand > 0 AND stock_um in ('FT','IN')
If the block needs to be further restricted, such as by a global variable, this is where you would enter the additional filters for that restriction.
In the Ordering and Grouping property, enter any code to
be executed after the filters, such as the order by or group by.
Format: ORDER BY column, column,
column
Format: GROUP BY column, column,
column
For example: ORDER BY description, stock_um, qty_on_hand desc
In the Execute Before property, enter any SQL statements that should be executed before the query for this block is executed.
SQL statements entered here must be fully formed and call a procedure (not a function).
SQL statements entered here are only applicable to queries, and not to updates, deletes, or inserts.
In the Execute After property, enter any SQL statements that should be executed after all rows are returned for this block.
SQL statements entered here must be fully formed and call a procedure (not a function).
SQL statements entered here are only applicable to queries, and not to updates, deletes, or inserts.
In the Z Order property, enter a number to define the order in which the block will be generated on the entity. The higher the number, the later the block will be generated. The Z order is specific to the indention level in the entity tree.
The Created on property displays the date and time on which this block was created, and cannot be changed.
The Modified on property displays the date and time on which this block was last changed, but cannot be modified.
When all changes have been made, press the [Save] button in the Main Toolbar.
In the Explorer Tree, locate the object for which you wish to modify a block.
Expand the Template Information object and select the template converter for which you wish to modify a block.
Expand the Group Information object and any sub-groups until you can select the converter for which you wish to modify a block.
Expand the converter and select the block that you wish to modify.
Display the block properties. These will either be displayed in Alphabetical or Logically, depending on the setting of the [Sort Alphabetically/Logically] button. The following instructions are assuming that the properties are sorted logically.
In the Name property, the name entered during block creation is displayed, and can be changed, if desired.
In the Description property, enter the user-defined description for the block.
In the Parent property, the name of the parent block of this block is displayed. If this is the top level block in the hierarchy, the property will display (entity root).
In the Type pop-list, Standard Block or Executable Block will be displayed.
In the Mutability pop-list, select whether this block can be modified on converters that are created from this template. This option is ONLY available for template converters.
When set to Fully Mutable, the block is placed on all converters that inherit from this template and can be modified or deleted.
When set to Positionally Mutable, the block is placed on all converters that inherit from this template and can only be moved.
When set the Not Mutable, the block is placed on all converters that inherit from this template and cannot be modified in anyway.
In the Query Type property, select
the type of query that this block will execute against the database. Choices
are Simple Query, Complex Query, Xephr Service, and Xephr Interconnect.
Complex Query indicates that the database query will be constructed
in its entirety by the user, such as when multiple tables must be referenced
for the data. When Complex Query is selected, the
Pre Where, Where Clause, Post Where, Execute Before, and Execute After
properties will be displayed. The user will construct
the database query using these properties.
In
the Datasource pop-list, the original value from block creation is displayed,
but can be changed, if desired.
Selecting (use default) will allow the converter or template to be
used with any datasource, and data brought in will be determined by the
converter's or template's datasource.
In the Select Statement property,
enter the select statement for your database query, beginning with the
word SELECT. The select statement lists the columns
in the table or view from which the data will be returned.
Complex Query blocks require that the user enter the select statement.
All columns selected from the database need to
be explicitly named.
Format: SELECT column, column, column,
column FROM view
For example: SELECT item_no, description, stock_um, qty_on_hand FROM
item_master_uvw
In the Filters property, enter the
additional or overriding filters to restrict the information returned
by the select statement for this block, if appropriate. This
is also referred to as the where clause. The statement
begins with the word WHERE.
Format: WHERE column (comparison)
value AND column (comparison)
value
For example: WHERE qty_on_hand > 0 AND stock_um in ('FT','IN')
If the block needs to be further restricted, such as by a global variable, this is where you would enter the additional filters for that restriction.
The filters for your complex query are entered here.
In the Ordering and Grouping property,
enter any code to be executed after the filters, such as the order by
or group by.
Format: ORDER BY column, column,
column
Format: GROUP BY column, column,
column
For example: ORDER BY description, stock_um, qty_on_hand desc
In the Execute Before property, enter any SQL statements that should be executed before the query for this block is executed. Not from Query blocks will not have this property.
SQL statements entered here must be fully formed and call a procedure (not a function).
SQL statements entered here are only applicable to queries, and not to updates, deletes, or inserts.
In the Execute After property, enter any SQL statements that should be executed after all rows are returned for this block. Not from Query blocks will not have this property.
SQL statements entered here must be fully formed and call a procedure (not a function).
SQL statements entered here are only applicable to queries, and not to updates, deletes, or inserts.
In the Z Order property, enter a number to define the order in which the block will be generated on the entity. The higher the number, the later the block will be generated. The Z order is specific to the indention level in the entity tree.
The Created on property displays the date and time on which this block was created, and cannot be changed.
The Modified on property displays the date and time on which this block was last changed, but cannot be modified.
When all changes have been made, press the [Save] button in the Main Toolbar.
In the Explorer Tree, locate the object for which you wish to modify a block.
Expand the Template Information object and select the template converter for which you wish to modify a block.
Expand the Group Information object and any sub-groups until you can select the converter for which you wish to modify a block.
Expand the converter and select the block that you wish to modify.
Display the block properties. These will either be displayed in Alphabetical or Logically, depending on the setting of the [Sort Alphabetically/Logically] button. The following instructions are assuming that the properties are sorted logically.
In the Name property, the name entered during block creation is displayed, and can be changed, if desired.
In the Description property, enter the user-defined description for the block.
In the Parent property, the name of the parent block of this block is displayed. If this is the top level block in the hierarchy, the property will display (entity root).
In the Type pop-list, Standard Block or Executable Block will be displayed.
In the Mutability pop-list, select whether this block can be modified on converters that are created from this template. This option is ONLY available for template converters.
When set to Fully Mutable, the block is placed on all converters that inherit from this template and can be modified or deleted.
When set to Positionally Mutable, the block is placed on all converters that inherit from this template and can only be moved.
When set the Not Mutable, the block is placed on all converters that inherit from this template and cannot be modified in anyway.
In the Query Type property, select
the type of query that this block will execute against the database. Choices
are Simple Query, Complex Query, Xephr Service, and Xephr Interconnect.
Xephr Interconnect indicates that the values will come from a published
entity on a Xephr host. This option is only available
if a Xephr Interconnect datasource exists.
In the Target Login property, the user ID that will be used to access the published entity is displayed and can be changed.
In the Target Password property, e password that will be used to access the published entity is displayed and can be changed.
In the Datasource pop-list, the original value from block creation is displayed, but can be changed, if desired. Only Xephr Interconnect datasources are displayed here for selection.
In the Interconnect Entity property, the original value from block creation is displayed, but can be changed if desired. Select the desired published entity from which the data will be displayed on this block.
Depending on the Interconnect Entity selected, one or more parameter (PARAM) properties will be displayed. Enter the appropriate values for the parameters. The parameters are used to restrict the values returned from the published entity.
In the Z Order property, enter a number to define the order in which the block will be generated on the entity. The higher the number, the later the block will be generated. The Z order is specific to the indention level in the entity tree.
The Created on property displays the date and time on which this block was created, and cannot be changed.
The Modified on property displays the date and time on which this block was last changed, but cannot be modified.
When all changes have been made, press the [Save] button in the Main Toolbar.
Xephr is a registered trademark of NDS Systems, LC.
Copyright