DBohner-(db)
Legendary Poster
Hi All,
Many years ago I heard the tip, "Fourth and long - PUNT"... . I'm hoping for a better tip than that, today.
You can obtain a lot of table information pulling from the iSeries QSYS2 structures. What I can't figure out - how the heck, via SQL can I pull the Table Size (or last hit-on date) from within SQL.
Yes, I know the table size can be pulled via the dsplib - giving a very concise list of objects and sizes. I'm just hoping for a trick to using the QSYS2 and straight SQL to pull the data.
Any hints (or tips) - greatly appreciated.
(db)
Many years ago I heard the tip, "Fourth and long - PUNT"... . I'm hoping for a better tip than that, today.
You can obtain a lot of table information pulling from the iSeries QSYS2 structures. What I can't figure out - how the heck, via SQL can I pull the Table Size (or last hit-on date) from within SQL.
Yes, I know the table size can be pulled via the dsplib - giving a very concise list of objects and sizes. I'm just hoping for a trick to using the QSYS2 and straight SQL to pull the data.
Any hints (or tips) - greatly appreciated.
(db)