home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 10 Tools
/
10-Tools.zip
/
datatl25.zip
/
DCTDSGN.Z
/
ewsqid1g.qry
< prev
next >
Wrap
Text File
|
1997-09-12
|
663b
|
40 lines
#NAME#
DA_GSAMdbdData
#DESCRIPTION#
This query collects information about GSAM DBDs.
Modifications:
Change the search criteria of the dbd name in the SQL WHERE clause.
View type: DAQgsamDBD
#MODIFIED#
#VERSION#
#SQL STATEMENT#
SELECT DISTINCT
d.dbdName,
d.accessMethod,
d.osAccess,
d.passwordFlag,
d.versionString,
d.ddName1,
d.ddName2,
d.recordFormat,
d.inputRecordLength,
d.outputRecordLength,
d.size1,
d.primaryBlockingFactor,
d.pcbName,
d.psbName,
d.dbdLabel,
d.dbdDescription
FROM OUTER
DAQgsamDBD d
WHERE
d.accessMethod = 'GSAM'
AND
d.dbdName LIKE '<>%'
ORDER BY 1 ASC