SELECT LEFT(CREATOR, 8),LEFT(NAME, 12), LEFT(TSNAME, 8), LEFT(DBNAME, 8)
FROM SYSIBM.SYSTABLES
WHERE TYPE = 'T'
AND DBNAME IN (
'BP01A1L',
'BS01A1L',
'CD01A1L',
'CE01A1L',
'ED02A1L',
'ED05A1L',
'ED06A1L',
'EV01A1L',
'FA01A1L',
'FF01A1L',
'GE01A1L',
'GE02A1L',
'GE03A1L',
'GE04A1L',
'GM01A1L',
'HP04A1L',
'KS01A1L',
'KS03A1L',
'KS05A1L',
'KS06A1L',
'KS07A1L',
'KS08A1L',
'NF01A1L',
'NF02A1L',
'NF03A1L',
'NH01A1L',
'NP01A1L',
'OE01A1L',
'OS01A1L',
'OS58A1L',
'OS59A1L',
'OS70A1L',
'PT02A1L',
'PX01A1L',
'PX02A1L',
'PX06A1L',
'PX99A1L',
'RE01A1L',
'RP01A1L',
'RP02A1L',
'RP03A1L',
'RP04A1L',
'RP09A1L',
'RR01A1L',
'RT01A1L',
'RT03A1L',
'RT04A1L',
'SA02A1L',
'SA03A1L',
'SA04A1L',
'SE02A1L',
'SF01A1L',
'SI01A1L',
'SM10A1L',
'SY01A1L',
'TA01A1L',
'UD01A1L',
'UF01A1L',
'VT01A1L',
'VT03A1L',
'WB01A1L',
'WB02A1L',
'WB03A1L',
'WB04A1L',
'WL06A1L',
'ZV01')
ORDER BY NAME, DBNAME