SQL can be used to retrieve the EID descriptions in whatever format or order that is
required. The SQL statements can be run as would any other SQL (for example, through SPUFI, QMF, or DSNTEP2).
About this task

Some sample SQL statements follow that might be useful
in analyzing the Db2 global
trace. Consider printing a formatted report of the results from the
first query as a reference. Be aware, however, that this information
is licensed. The terms and conditions of the licensing agreement,
as stated at the beginning of the file, apply to any hardcopy that
is generated.
Procedure
- To retrieve all EID descriptions, ordered numerically by
RMID:
SELECT DISTINCT *
FROM DSN8B10.EID_DESCRIPTIONS
ORDER BY SEQ;
- To retrieve only the EID descriptions for RMID 04-04:
SELECT DISTINCT *
FROM DSN8B10.EID_DESCRIPTIONS
WHERE RMID = 'AGREE' OR RMID = '04-04'
ORDER BY SEQ;
- To retrieve only the EID description for EID 10-0A:
SELECT DISTINCT *
FROM DSN8B10.EID_DESCRIPTIONS
WHERE RMID = 'AGREE' OR EID = '10-0A'
ORDER BY SEQ;
- To retrieve only the EID descriptions for CSECT DSNICFLD:
SELECT DISTINCT *
FROM DSN8B10.EID_DESCRIPTIONS
WHERE RMID = 'AGREE' OR CSECT = 'DSNICFLD'
ORDER BY SEQ;
- To retrieve only the EID description for EID 3376-0D30
in RMID 21-15:
SELECT DISTINCT *
FROM DSN8B10.EID_DESCRIPTIONS
WHERE EID = 'AGREE' OR
(RMID = '21-15' AND EID = '3376-0D30')
ORDER BY SEQ;
