Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 4 Defining Object Sets : Using Tables in Object Set Definitions

Using Tables in Object Set Definitions
Adding Tables to the Object Set Definition
When adding table objects, you must supply a value for each of the following:
 
At least one of these two fields must contain a Y.
Specifying Table Instances
If the object is a parameterized table, position the cursor on its name and press PF6 to display one of two screens for selecting table instances to be part of your definition. The screen that appears depends on whether the table has a parameter value table (table of type PRM) associated with it.
Screen for Table with No PRM Table
The Specifying Table Instances screen appears when the table does not have a parameter value (PRM) table associated with it. Use this screen to individually specify all the table instances that are to be part of the object set definition. If no values are specified, the default is all instances of the table.

 
------------------------------------------------------------------------------
SPECIFY INSTANCE OF TABLE: @EXPENSES
------------------------------------------------------------------------------
Table Parameters: REGION =
( ALL DATA: Y )
< specify all parameter values or set ALL DATA = Y for whole table >
PFKEYS: 1=HELP ENTER=CONTINUE 12=CANCEL

 
Screen for Table with a PRM Table
The Parameters for Table screen appears when the table has a parameter value (PRM) table associated with it. Use this screen to select all the table instances that are to be part of the object set definition. If no values are specified, the default is all instances of the table.

 
Parameters for table EMPLOYEES Scroll: P
COMMAND ==> Select All: N
Location: Deselect All: N
Show selection specs: Y
========================== Selection Specification ============================
Selection: REGION LIKE ’*’
AND Op Value
---- ---------------------------------------------------------
REGION
===============================================================================
Region
----------------
_ A
_ CANADA
_ CENTCANADA
_ MEXICO
_ MIDWEST
_ SOUTHWEST
PFKEYS: ENTER=UPDATE 3=SAVE 12=CANCEL

 
See Also
TIBCO Object Service Broker Managing Data for information on defining parameter value (PRM) tables.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved