Display various filler values in CA Repository for z/OS WebStation Option

Products

• Repository

Issue/Introduction

Question:

When importing a copybook into the CA Repository for z/OS using the Copybook Scanner that contains fillers with values, each filler is stored in the REC MAP relationship with a unique sequence number and filler value.   Is there a way to display each unique filler sequence number and filler value in the CA Repository for z/OS WebStation Option as a subordinate search object off of the source record?

 

Answer:

The following SQL can be used to create a subordinate search object in WSO to display the various filler values ordering by sequence number where RECORD is the source search object

SELECT E.ENT_ID, E.ELEMENT_NAME, RECMAP.VALUE,

DIGITS(RECMAP.SEQ_NUM) AS SEQUENCE

FROM repowner.DBX_DDL_ELEMENTS E,

repowner.DBX_PRI_STR_MAPS RECMAP,

repowner.DBX_XREF X1

WHERE X1.SOURCE_ID = ? AND

X1.ENT_TYPE = 25434 AND

X1.TARGET_ID = E.ENT_ID AND

X1.ENT_ID = RECMAP.ENT_ID

ORDER BY 4

 

Note:

 

Change repowner to your repository creator

 

<Please see attached file for image>

 

 

Environment

Release: DATASH00200-7.1-Repository-Webstation Option
Component: