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


Chapter 2 The Table Definer : Selecting Global Fields

Selecting Global Fields
The use of global fields in your environment is determined by your application administrator. This implementation is enforced at a table-type level.
Global fields are not supported in the graphical Table Definer supplied with the TIBCO Object Service Broker UI. You must use the text-based definer if you are going to use global fields.
Types of Implementation
The following implementations are available for the @GLOBALFIELDS table. Check with your application administrator for the implementation used in your development environment.
Each field must be linked to a global field or you are not able to save the definition.
The attributes of the field must match the attributes of the global field to which you are linked or you are not able to save the definition.
You are warned if a field is not linked to any field in the global field dictionary.
You are warned if the field attributes do not match the attributes of the global field to which you are linked.
The fields are not linked to the global field dictionary.
Types of Information Stored with a Global Field
The following types of information are stored with a global field:
Global Fields Selector Illustrated
When you press PF14 from within the Table Definer screen, a screen similar to the following appears:

 
Globalfields Scroll: P
COMMAND ==> Select All: N
Location: Deselect All: N
Show selection specs: Y
========================== Selection Specification ============================
Selection: NAME LIKE ’*’
AND Op Value
---- ---------------------------------------------------------
NAME
BUSINESSNAME
UNIT
CREATED
AUTHOR
===============================================================================
Name Businessname Unit Created Aut
---------------- ------------------------------------ -------- ---------- ---
_ ACCESSTYPE ACCESS FOR DBMS EXT 2000-03-15 AMD
_ DATE CURRENT DATE USR40 1995-03-01 USR
_ DEPTNO DEPARTMENT NUMBER 1992-01-22 MGR
S MANAGER MANAGER NAME EMP 1989-03-01 WEA
_ TIME CURRENT TIME
S USERID USERID OF EMPLOYEE
PFKEYS: ENTER=UPDATE 3=SAVE 12=CANCEL

 
Using the Global Fields Selector
To select global fields to copy from the Global Field dictionary, complete the following tasks:
1.
2.
The Selection Specification section of the screen can be used to narrow the selection list by using specified selection criteria. The list of fields appears in the lower portion of the screen. You can use more than one type of selection criteria. For a list of valid values for each of these fields, position your cursor on the field and press PF1. To narrow your selection, beside the appropriate selections specify an operator in the Op field and appropriate values in the Value field.
3.
Press PF3 to save or copy. The Table Definer screen appears with the global fields appended to the table, one per line in the order in which they are stored in the @GLOBALFIELDS table.

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