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


Chapter 8 Painting the Report Tables : Global Fields

Global Fields
Global fields are predefined fields that standardize the position, name, and use of data across your reports. They are also used to create standard definitions across the database. The use of global fields in your environment is determined by your application administrator. This implementation is enforced at a table-type level.
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:
Using Global Fields
The following illustration shows an example of the Global Field Dictionary screen:

 
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 Author
---------------- ------------------------------------ -------- ---------- --------
_ DLWFLD2 NONE ACC 1994-11-08 USR01
_ DLWTEST DFJKLDFH ACC 1995-06-27 USR01
_ EMPLOYEE EMPLOYEE PER 1993-05-04 USR02
s EMPLOYEE# EMPLOYEE NUMBER PER 1992-07-16 USR03
s EMPNO EMPLOYEE NUMBER-UNIQUE FOR EACH EMP PER 1991-01-14 USR04
 
PFKEYS: ENTER=UPDATE 3=SAVE 12=CANCEL

 
Selecting Global Fields
To select a global fields to copy, complete the following tasks:
1.
This displays a listing of the Global Field Dictionary excluding fields that have a syntax of RD (raw data) or UN (Unicode).
2.
To narrow your selection list, beside the appropriate selections, specify an operator in the Op field and appropriate values in the Value field.
You can use the middle section of the screen to narrow down 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.
3.
Type S in the line command field of the fields you want to copy.
4.
The Report Table Painter screen appears with the global fields appended to the report table, one per line in the order in which they are stored in the table. The display lengths of the global fields are used as the lengths of the report fields.
Example
The following illustration shows an example of the EMPLOYEE# and EMPNO_1 fields added to your report table definition from the Global Field Dictionary:

 
COMMAND ==> Scroll: P
....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+.
_ 1 ¬99999999 Employee Expense Totals
_ 2
_ 3 Employee Last Name Id # Monthly_exp
_ 4 ---------------------- ------ -----------
_ 5 ¬AAAAAAAAAAAAAAAAAAAAA ¬99999 ¬999999.99
_ 6
_ 7
_ 8
_ 9
Table: DEPT_EXPENSE Unit: DOCEXMPL
Field Name Row Col Type Syntax Len Dec Just Blank Derived Display Mask
---------------- --- --- - - ---- --- - - - --------------
_ DATE 1 1 D B 9 0 L N N MMM/DD/YYYY
_ LNAME 5 2 S C 22 0 L N N
_ EMPNO 5 25 I P 6 0 L N N
_ MONTHLY_EXP 5 32 Q P 10 2 R N N -$ZZZ9V.AB
_ EMPLOYEE# 0 0 I C 11 0 N N
_ EMPNO_1 0 0 I P 6 0 N N
 
PFKEYS: 6=+FLD 18=-FLD 5=CUT 17=PASTE 16=CNTL 15=EXPAND 4=TITLE/HEAD 19=SHIFT

 

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