Query Definition SET210QRY
Query . . . . . . . . . . . . . . . . . SET210QRY
Query text . . . . . . . . . . . . . . Report on Level Check Errors
Selected files
ID File Library Member Record Format
T01 S210PGMREF QTEMP *FIRST QWHDRPPR
T02 S210RFID QTEMP *FIRST QWHFDFMT
Join tests
Type of join . . . . . . . . . . . . . Matched records
Field Test Field
T01.WHFNAM EQ T02.RFFILE
Select record tests
AND/OR Field Test Value (Field, Numbers, or 'Characters')
T01.WHOTYP EQ '*FILE'
AND T01.WHRFSN NE ' '
AND T01.WHSNAM EQ T01.WHFNAM
AND T01.WHRFSN NE T02.RFID
Report column formatting
Field Summary Column
Name Functions Spacing Column Headings Len
T01.WHPNAM 0 Program that 10
references
the file
T01.WHLIB 2 Library 10
T01.WHTEXT 2 TEXT 50
Text
'Description'
T01.WHFNAM 2 PF or LF 11
Referenced
T02.RFLIB 2 Library 10
T01.WHRFSN 2 Format Level 13
Identifier
in IO Module
T02.RFID 2 Format Level 13
Identifier
in PF or LF
Cover Page
Print cover page . . . . . . . . . . . Yes
Cover page title
Report on file IO Modules and *DBOPTIMIZE functions
where the record format in the program does not
match the record format of the physical file
or logical file referenced
Query . . . . . . . . . . . . . . . . . SET210QRY
Query text . . . . . . . . . . . . . . Report on Level Check Errors
Selected files
ID File Library Member Record Format
T01 S210PGMREF QTEMP *FIRST QWHDRPPR
T02 S210RFID QTEMP *FIRST QWHFDFMT
Join tests
Type of join . . . . . . . . . . . . . Matched records
Field Test Field
T01.WHFNAM EQ T02.RFFILE
Select record tests
AND/OR Field Test Value (Field, Numbers, or 'Characters')
T01.WHOTYP EQ '*FILE'
AND T01.WHRFSN NE ' '
AND T01.WHSNAM EQ T01.WHFNAM
AND T01.WHRFSN NE T02.RFID
Report column formatting
Field Summary Column
Name Functions Spacing Column Headings Len
T01.WHPNAM 0 Program that 10
references
the file
T01.WHLIB 2 Library 10
T01.WHTEXT 2 TEXT 50
Text
'Description'
T01.WHFNAM 2 PF or LF 11
Referenced
T02.RFLIB 2 Library 10
T01.WHRFSN 2 Format Level 13
Identifier
in IO Module
T02.RFID 2 Format Level 13
Identifier
in PF or LF
Cover Page
Print cover page . . . . . . . . . . . Yes
Cover page title
Report on file IO Modules and *DBOPTIMIZE functions
where the record format in the program does not
match the record format of the physical file
or logical file referenced