Wednesday, February 24, 2016

iSeries SQL to Query QSYS2 for Table Size?



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)


from JDELIST - JD Edwards® EnterpriseOne Technical http://ift.tt/21s3D0q
via IFTTT

No comments:

Post a Comment