The attribute detail page displays attributes and its values in editable text boxes. The page also displays Search, Insert, Update, Delete, and Clear All buttons. You can enter data into the text boxes and choose to search, update, or insert an attribute. You can also perform impact analysis and text processing on selected rows.
All data modification actions are performed from the detail page only. However, the data being changes may or may not require prior approval by steward. A steward is a workstation associated with a privilege assigned to a list of users having approval rights. There are two possibilities regarding data modifications:
The attribute detail page stores the data entered through the text boxes in the form of XML stream. In addition to the actual data, the XML stream also contains the steward name (If a steward is associated with the data being changed). If the data is already associated with a steward, that steward name is highlighted. There can be be more than one stewards assigned for one repository object.
The approval requirement procedure checks whether approval is required for the current action.
The procedure call results in one of the following three actions depending on the input data:
In this case, steward needs to approve the request to populate actual tables in repository. The procedure will return a success code and saves the XML data into the approval table.
In this case, a message is displayed to contact the system administrator.
The procedure is called again with the selected steward details.
In this case, the actual tables will be populated and corresponding messages will be displayed to the user. In this case, no data is saved in the approval table.
The attribute detail page has a Breadcrumb feature for easy navigation. It appears on the upper left corner of the details page, allowing you to see your current location as well as previous locations as a path. You can use this feature to go back to any previous location. The browser back button is disabled for navigation.
From the attribute detail page you can perform the following actions:
You can specify criteria for search.
If more than one row meets the criteria then the result set will be displayed as a list. When you select a row from the result set, a detail page is displayed.
You can perform a search for the required entity and update the attribute values of entities, relationship, or set.
Note: You need to perform a search for the required entity before updating a row.
Note: You need to perform a search for the required entity before deleting a row.
The following query fetches a list of stewards:
SELECT * FROM DBX_WORKSTATION_D W, DBX_XREF X WHERE X.ENT_TYPE = 25123 AND X.ENT_ID = W.ENT_ID
The following query fetches a list of stewards for a particular repository row:
SELECT NAME FROM DBX_WORKSTATION_D D, DBX_WKSN_XREF WX WHERE WX.ENT_ID = :Input entity id AND WX.WKSN_ID = D.ENT_ID;
CA Repository Webstation Option executes the following query to get a list of objects for a specified dialog:
SELECT DISTINCT X.ENT_NAME, X.ENT_TYPE,
CASE
WHEN X.TYPE2 = 'SET' THEN X.TYPE2
ELSE X.TYPE1
END AS TYPE
FROM
TABLE( SELECT DISTINCT Z.ENT_NAME, Z.ENT_TYPE, Z.TYPE1, Y.TYPE2
FROM
TABLE(
SELECT DISTINCT E.ENT_NAME, E.ENT_TYPE,
CASE
WHEN E.ASSOCIATION = 'Y' THEN 'ASSOCIATION'
WHEN E.ASSOCIATION = 'N'
AND E.SOURCE_ENT_TYPE <> 0
AND E.TARGET_ENT_TYPE <> 0
THEN 'RELATIONSHIP'
ELSE 'ENTITY'
END AS TYPE1
FROM DBX_DIALOG D, DBX_ENT_TYPE_DESC E
WHERE D.ENT_TYPE = E.ENT_TYPE
AND D.DIALOG = :Input dialog name
) AS Z
LEFT OUTER JOIN
TABLE(
SELECT DISTINCT E.ENT_NAME, E.ENT_TYPE, 'SET' AS TYPE2
FROM DBX_DIALOG D, DBX_ENT_TYPE_DESC E,
DBX_SET_TYPE S
WHERE D.ENT_TYPE = E.ENT_TYPE
AND E.ENT_TYPE = S.SET_ENT_TYPE
AND D.DIALOG = :Input dialog name
) AS Y
ON Z.ENT_TYPE = Y.ENT_TYPE
) AS X
When this query executes, the output is displayed as follows:
---------+--------------------+--------------+--
ENT_NAME ENT_TYPE TYPE
---------+--------------------+--------------+--
PROGRAM 151 ENTITY
RECORD 200 ENTITY
GROUP 201 ENTITY
ALIAS 202 ENTITY
EL VALUE 203 RELATIONSHIP
ELEMENT 204 ENTITY
ELEMENTS 205 SET
FIELD 207 RELATIONSHIP
FIELDS 208 SET
VALUE 209 ENTITY
FUNCTION 210 RELATIONSHIP
LOGIC AL 212 ASSOCIATION
PHY AL 213 ASSOCIATION
RECSEGS 214 SET
The following query displays a list of dialogs that a particular user is authorized to use:
SELECT DISTINCT (D.DIALOG)
FROM DBX_PRIV_USER U, DBX_DIALOG_PRIV D
WHERE TSO_LOGON = :input name AND
D.PRIV_NAME = U.PRIV_NAME
| Copyright © 2009 CA. All rights reserved. | Email CA about this topic |