SQL Catalog View SYSINDEXES does not show DDS Logicals?

[Vectorspace]

On the one hand it makes sense becuase they aren't SQL indexes, but on the other the SQL query engine uses them like indexes.

Is there a catalog view that does list all logicals? (Short of coding my own based on DSPDBR?)

I'm on 7.2, but still interested if there is a 7.3+ - only solution

[B.Hauser]

Logical Files can be found within the SYSTABLES catalog view with TABLE_TYPE L

Birgitta

[Vectorspace]

Thanks. However I forgot to mention, I was specifically looking for a way to get the logicals over a particular physical. Sorry about that.

Is there an SQL catalog view/function/service to do that?