Re: ? about SQL Long table names and funky member names

You can list all your partitions that do not match their table name this
way:
with t1 as (
SELECT SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME,
count(system_table_member) as Partition_count
from qsys2.syspartitionstat
WHERE system_table_member<>system_table_name
group by
SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME
having count(system_table_member)=1)
SELECT SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME, SYSTEM_TABLE_MEMBER,
TABLE_SCHEMA, TABLE_NAME, TABLE_PARTITION
FROM qsys2.syspartitionstat
WHERE (SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME, SYSTEM_TABLE_MEMBER)
in (select
SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME, SYSTEM_TABLE_MEMBER
from t1)

The above excludes multi partition tables like QRPGLESRC


Rob Berendt