home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 10 Tools
/
10-Tools.zip
/
datatl25.zip
/
DCTDSGN.Z
/
ewsqis4g.qry
< prev
next >
Wrap
Text File
|
1997-09-12
|
2KB
|
79 lines
#NAME#
DA_HISAMsegmentData
#DESCRIPTION#
This query collects information about segments in HISAM DBDs.
DBD and DATASET information is found through the HISAM DBD sample query, ewsqid6g.qry.
FIELD information is in the IMS FIELD sample query, ewsqifg.qry.
Modifications:
Change the search criteria of the dbd name in the SQL WHERE clause.
View type: DAQhisamDBD
#MODIFIED#
#VERSION#
#SQL STATEMENT#
--DA_HISAMsegmentData
SELECT DISTINCT
d.segmentName,
ms.dataStructure,
d.maximumLength,
d.minimumLength,
d.frequency,
d.rules,
d.deleteFlag,
d.insertFlag,
d.replaceFlag,
d.parentSegmName,
d.dataOnly,
d.initialization,
d.routine,
d.exitFlag,
d.segmCaptureRoutine,
d.segmExitData,
d.segmExitKey,
d.segmExitPath,
d.segmCascade,
d.segmCascadeData,
d.segmCascadeKey,
d.segmCascadePath,
d.xdfldName,
d.indexSegmName,
d.indexDBDname,
d.ddataFieldName,
d.searchFieldName,
d.subseqFieldName,
d.sourceSegmName,
d.exitRoutine,
d.constant,
d.nullValue,
d.symbolic,
d.lchildSegmName,
d.lchildDBDname,
d.lchildPairSegmName,
d.lchildPairDBDname,
d.lcPointer,
d.rules1 as lcrules,
d.lparentSegmName,
d.lparentDBDname,
d.virtualParent,
d.counter,
d.lparent,
d.ltwin,
d.pairSegmName,
d.pairDBDname,
d.logSegmName,
d.logDBDname,
d.segmLabel,
d.segmDescription
FROM OUTER
DAQhisamDBD d,
(d.mappingStruct) ms
WHERE
d.accessMethod = 'HISAM'
AND
d.dbdName LIKE '<>%'
ORDER BY 1 ASC