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


Chapter 3 Defining Screen Tables : Using Predefined Fields

Using Predefined Fields
You can use predefined fields to create definitions for your screen fields, unless these fields have a syntax of RD (raw data) or UN (Unicode). There are two types of predefined fields:
Using Table Field Definitions
You can use a field(s) and its definition from a predefined table to simplify the assignment of data and promote the shareability of data definitions. To use a field in a table, use one of the following primary commands:
Copying Fields
To copy a field(s) and its definition from a predefined table, use the COPY command. The field is copied into the current screen table (the image area is cleared for you when you invoke the command). If there is not sufficient room, only the fields that fit in the screen table are copied. Specify one of the following:
A list of fields appears. Place an alphanumeric character, to specify order, in the line command field beside the fields you want to select. They are re-ordered in the order (0-9, A-Z), when you press PF3>.
From this table, all fields that do not have a syntax of RD (raw data) or UN (Unicode) are copied into the current screen table.
You can also specify the option NONAMES. If the NONAMES option is not used, the field name is copied as a literal with the field added beside it. If the NONAMES option is specified, the field name is not copied as a literal.
Appending Fields
To append a field(s) and its definition from a named table into the current screen table, use the APPEND command. The field is added at the line below the cursor position, if there is sufficient room. If there is insufficient room, only the fields that fit in the screen table are appended. If the cursor is not positioned in the image area, the fields are added after the existing fields. Specify one of the following:
A list of fields appears. Place an alphanumeric character, to specify order, in the line command field beside the fields you want to select. They are re-ordered in the order (0-9, A-Z), when you press PF3.
From this table, all fields that do not have a syntax of RD (raw data) or UN (Unicode) are appended into the current screen table.
You can also specify the option NONAMES. If the NONAMES option is not used, the field name is copied as a literal with the field added beside it. If the NONAMES option is specified, the field name is not copied as a literal.
Using Global Fields
Global fields standardize the position, name, and how your fields use data across your screens. They are used to create standard definitions across the database. The following example illustrates 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 Aut
---------------- ------------------------------------ -------- ---------- ---
_ @ACCESSTYPE ACCESS FOR IMS, IDMS, ... XYZ 1987-01-01 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

 
Selecting a Global Field
To select a global field(s) to copy from the Global Field Dictionary, 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 Screen Table Painter screen appears with the global fields appended to the screen 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 screen fields.
Example
The following example illustrates the MANAGER and USERID fields added to your screen table definition from the Global Field Dictionary:

 
SCREEN PAINTER COMMAND ==> Scroll: P
....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....
¬999999 Expenses for Department #¬99
Manager #¬99999
EMPLOYEE NAME EMPLOYEE# EXPENSE
¬AAAAAAAAAAAAAAAAAAAAAA ¬99999 ¬99999.99
¬AAAAAAAAAAAAAAAA
¬AAAAAAAA
Table: EXPENSE_DATA Unit: USR40
ROW COL FIELD NAME Type Syn Len Dec Just Fill Prot Show Rqd Hi Skip Null
--- --- --------------- - - ---- --- - - - - - - - -
1 16 MONTH D B 8 0 L . Y Y N N Y Y
1 49 DEPTNO I P 2 0 L Y Y N N Y Y
2 49 MANAGER_NUM I P 5 0 L Y Y N N Y Y
6 1 LNAME S C 22 0 C Y Y N N Y Y
6 32 EMPNO I P 5 0 L Y Y N N Y Y
6 45 MONTHLY_EXP Q P 8 2 R _ N Y N N Y Y
7 1 MANAGER I C 16 0 L N Y N N Y Y
8 1 USERID I C 8 0 L N Y N N Y Y
PFKEYS: 6=+FLD 18=-FLD 4=+LINE 5=CUT 19=FLD_HELP 17=PASTE 16=-LINE 13=PRINT
Copied 2 field(s) from the field dictionary

 

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