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


Chapter 13 Management of Promotion Rights : Managing Promotion Rights to Tables

Managing Promotion Rights to Tables
Manage Rights to Tables Screen
This example illustrates the promotion rights management screen specific to tables:

 
Manage Rights on Tables
Command ==> Scroll P
NAME BORROWER UNIT TYPE EXT PARMS*
---------------- ---------------- -------- ---- --- ----------------------
_ CUST USR40 USR IMS D
_ CUST_TITLE USR40 USR SCR D
_ CUSTBODY USR40 USR SCR D
_ CUSTCOOP USR30 USR DAT D
_ CUSTD USR50 USR DAT D
_ CUSTDATA USR30 USR DAT D
_ CUSTDS USR30 USR TDS D
_ CUSTDS USR50 USR TDS O
_ CUSTFOOT USR20 USR SCR D
_ CUSTHEAD USR40 USR SCR D
_ CUSTOMER_BODY USR30 USR SCR D
_ CUSTOMER_TA USR40 USR TDS D
_ CUSTOMER_TA USR500 USR TDS O
_ CUSTOMER_TA1 USR50 USR TDS D
_ CUSTOMER_TITLE USR20 USR SCR D
_ CUSTOMERS USR40 USR TDS D
O-Obtain R-Release T-Transfer X-Expand
PFKEYS: 12=EXIT 13=PRINT 3=END 5=FIND NEXT 9=RECALL

 
TYPE, EXT, and PARMS Fields
In addition to the NAME, BORROWER, UNIT, and SUMMARY fields described in Managing Promotion Rights to Objects, this screen has the following fields:
The value of this field indicates whether the entry pertains to a table’s definition (D) or a set of occurrences (O).
For most objects, promotion rights are associated only with the object’s definition. In addition to their definitions, some tables also have data associated with them. Specifically for TDS tables, promotion rights are maintained for the definition as well as for their occurrences. A table of type TDS can, therefore, appear more than once on the promotion rights management screen. One entry shows the promotion right to its definition; the other entries pertain to promotion rights to table instances.
In a parameterized table, a table instance is the set of rows that have a common set of parameter values. A non-parameterized table has only one table instance that includes all its data rows.
The EXPAND Line Command
Available occurrence promotion rights to instances of a parameterized table appear as only a single entry on the Manage Rights screen for tables. To obtain rights to specific instances, use the X line command to show the individual instances of the table.
Example
In the following illustration, the Manage Rights on Tables screen shows that rights are currently available for the first instances of the displayed tables. Rights are also held on other instances. Before the available rights can be obtained, the instances of the table must be identified.

 
Manage Rights on Tables
Command ==> Scroll P
NAME BORROWER UNIT TYPE EXT PARMS*
---------------- ---------------- -------- ---- --- ----------------------
_ #ED_DEPARTMENTS EDUC TDS O
_ #ED_DEPARTMENTS EDUC TDS D
_ #ED_EMPLOYEES EDUC TDS O
#ED_EMPLOYEES EDUC TDS D
_ @#TABLENAMES UNLOADUI TDS D
X @@SERVERPARMS DIC TDS O
_ @@SERVERPARMS DIC TDS D
O-Obtain R-Release T-Transfer X-Expand
PFKEYS: 12=EXIT 13=PRINT 3=END 5=FIND NEXT 9=RECALL

 
Values in the PARM Field
Entries indicating a borrower show table instances in the PARM field of the screen. Entries that do not indicate a borrower do not show the table (parameter) instances unless expanded.
Issuing the X (Expand) Line Command
When you issue the X line command, a subsequent screen displays the available data rights for the selected table instance.
When concatenated parameters exceed the display width, an asterisk (*) indicates that the rest of the field display is truncated. If this occurs, you can issue the S line command to display the full view of the parameters, up to 127 characters.

 
Available Data Rights
Command ==> Scroll P
NAME PARMS
---------------- -----------------------------------------------------
S LONGPARMS AAAAAAAAAAA*,BBBBBBBBBBB*,CCCCCCCCCCC*,DDDDDDDDDDD*
_ LONGPARMS AAAAAAAAAAA*,BBBBBBBBBBB*,CCCCCCCCCCC*,DDDDDDDDDDD*
_ LONGPARMS AAAAAAAAAAA*,BBBBBBBBBBB*,CCCCCCCCCCC*,DDDDDDDDDDD*
_ LONGPARMS AAAAAAAAAAA*,BBBBBBBBBBB*,CCCCCCCCCCC*,DDDDDDDDDDD*
_ LONGPARMS AAAAAAAAAAA*,BBBBBBBBBBB*,CCCCCCCCCCC*,DDDDDDDDDDD*
O-Obtain S-See Parm Values
PFKEYS: 12=EXIT 13=PRINT 3=END 5=FIND NEXT 9=RECALL
10:05:19 OK

 
Line Commands
You can use the following line commands on this screen:
The See Parm Values Line Command
When you issue the S line command from the Available Data Rights screen, an Expanded Parameter Values screen appears, similar to the following:

 
Expanded parameter instances of table: LONGPARMS
Summary: This is an example of a table with long parameters
PARM1: AAAAAAAAAAAAAAAAAAAA
PARM2: BBBBBBBBBBBBBBBBBBBB
PARM3: CCCCCCCCCCCCCCCCCCCC
PARM4: DDDDDDDDDDDDDDDDDD01
 
PFKEYS: 3=EXIT 12=EXIT

 
This screen can display up to 127 characters for each parameter.

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