zOs/SQL/CATTBPA
select storName, length(storName), hex(storName),
stortype, length(stortype), hex(stortype), p.*
from sysibm.sysTablePart p
where length(storName) > length(strip(storName))
and dbName like 'VV%'
and tsName in (
'VDPS004'
,'VDPS078'
,'VDPS121'
,'VDPS168'
,'VDPS169'
,'VDPS185'
,'VDPS295'
,'VDPS296'
,'VDPS298'
,'VDPS321'
,'VDPS393'
)
;
x
select storName, length(storName), hex(storName), p.*
from sysibm.sysTablePart p
where (dbName = 'DGDB0125' and tsName = 'A012A')
or (dbName = 'DGDB9998' and tsName = 'A937A')
;
x
select storName, length(storName), hex(storName), p.*
from sysibm.sysTablePart p
where (dbName = 'TP01A1T' and tsName = 'A012A')
or (dbName = 'DA540769' and tsName = 'A937A')