Statistics timestamp & 'under-the-hood' column names

--openmail-part-090bd2f3-00000001

Content-Type: text/plain; charset=US-ASCII; name="BDY.TXT"
Content-Disposition: inline; filename="BDY.TXT"
Content-Transfer-Encoding: 7bit

'gals' || 'guys',

Am I right in assuming that the SYS.HIST_HEAD$ (column TIMESTAMP in V7.3.4 and column TIMESTAMP# in 8.0.x and 8.1.x) is the _only_ place where I can find out when the statistics for a particular table was last generated? (among other nuggets of information :)

Just digging thru SQL.BSQ of the 8.x versions and note that a number of equivalent columns have a '#' appended to them - causes a lot of grief on porting home grown managament scripts and utilities that look for some additional details 'under the hood'...... (e.g. HIST_HEAD$.TIMESTAMP, OBJ$.TYPE and USER$.TYPE)

TIA,
John Kanagaraj
Brunei Shell Petroleum
http://www.geocities.com/john_sharmila

God so loved the world that He didn't send a committee! (See John 3:16 for details)
** Opinions expressed here are solely mine and not necessarily those of my employer **

--openmail-part-090bd2f3-00000001

Content-Type: application/ms-tnef; name="WINMAIL.DAT"
Content-Disposition: attachment; filename="WINMAIL.DAT"
Content-Transfer-Encoding: base64

eJ8+IociAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5N aWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEDkAYADAAAAAEAAAADABcAAQAA ABwAAQOQBgAMAAAAAQAAAAMANgAAAAAAOgABBIABADUAAABTdGF0aXN0aWNzIHRpbWVzdGFt cCAmICd1bmRlci10aGUtaG9vZCcgY29sdW1uIG5hbWVzABgTAQOQBgAMAAAAAQAAAAsAAgAB AAAADwABA5AGAAwAAAABAAAACwArAAAAAAA3AAEDkAYADAAAAAEAAAADAC4AAAAAADIAAQOQ BgAUAAAAAQAAAAIBMQABAAAAAQAAAAAAAAA3AAEDkAYAEAAAAAEAAABAADkAMGKCOJy0vwHW AwEDkAYAJAAAAAEAAAAeAEIAAQAAABIAAABKb2huIEouIEthbmFnYXJhagAAADsGAQOQBgAQ AAAAAQAAAEAASAAA9c05nLS/AZQEAQOQBgBIAAAAAQAAAB4AcAABAAAANQAAAFN0YXRpc3Rp Y3MgdGltZXN0YW1wICYgJ3VuZGVyLXRoZS1ob29kJyBjb2x1bW4gbmFtZXMAAAAA3RMBA5AG ACgAAAABAAAAAgFxAAEAAAAWAAAAAb+0nDh9K6TPziCBEdSTNgBgl5kRswAAYAoBA5AGAAwA AAABAAAAAwAGEEr50bbkAgEDkAYADAAAAAEAAAADAAcQngIAALsAAQOQBgB4AAAAAQAAAB4A CBABAAAAZQAAAEdBTFNHVVlTLEFNSVJJR0hUSU5BU1NVTUlOR1RIQVRUSEVTWVNISVNUSEVB RCQoQ09MVU1OVElNRVNUQU1QSU5WNzM0QU5EQ09MVU1OVElNRVNUQU1QI0lOODBYQU5EODFY KUkAAAAAFB0BA5AGAAwAAAABAAAAAwAQEAEAAAAlAAEDkAYADAAAAAEAAAADABEQAAAAACUA AQOQBgAUAAAAAQAAAB4AQhABAAAAAQAAAAAAAABzAAEDkAYAEAAAAAEAAABAAAcwUNK/N5i0 vwGcBAEDkAYAEAAAAAEAAABAAAgwAKLrHpy0vwE0BAEDkAYAIAAAAAEAAAACAQswAQAAABAA AADKz6QrgSDUEZM2AGCXmRGzWwcBA5AGAAwAAAABAAAAAwDeP69vAAA/AgEDkAYAJAAAAAEA AAADADulCCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAK0CAQOQBgAkAAAAAQAAAAMAPKUI IAYAAAAAAMAAAAAAAABGAAAAAAGFAAAAAAAAnwIBA5AGACQAAAABAAAAAwA9pQggBgAAAAAA wAAAAAAAAEYAAAAAEYUAAAAAAACwAgEDkAYAJAAAAAEAAAADAD6lCCAGAAAAAADAAAAAAAAA RgAAAABShQAA4xUAAOoDAQOQBgAsAAAAAQAAAB4AP6UIIAYAAAAAAMAAAAAAAABGAAAAAFSF AAABAAAABAAAADguNQCwAwEDkAYAJAAAAAEAAAALAEClCCAGAAAAAADAAAAAAAAARgAAAAAG hQAAAAAAALACAQOQBgAkAAAAAQAAAAsAQaUIIAYAAAAAAMAAAAAAAABGAAAAAA6FAAAAAAAA uQIBA5AGACQAAAABAAAAAwBCpQggBgAAAAAAwAAAAAAAAEYAAAAAGIUAAAAAAAC8AgEDkAYA LAAAAAEAAAAeAEOlCCAGAAAAAADAAAAAAAAARgAAAAA2hQAAAQAAAAEAAAAAAAAA+AIBA5AG ACwAAAABAAAAHgBEpQggBgAAAAAAwAAAAAAAAEYAAAAAN4UAAAEAAAABAAAAAAAAAPoCAQOQ BgAsAAAAAQAAAB4ARaUIIAYAAAAAAMAAAAAAAABGAAAAADiFAAABAAAAAQAAAAAAAAD8AgED kAYAJAAAAAEAAAALAEalCyAGAAAAAADAAAAAAAAARgAAAAAAiAAAAAAAALYCAQOQBgAkAAAA AQAAAAsAR6ULIAYAAAAAAMAAAAAAAABGAAAAAAWIAAAAAAAAvAIBA5AGABQAAAABAAAAHgA9 AAEAAAABAAAAAAAAAF4AAQOQBgAMAAAAAQAAAAMAgBD/////kAQBCQAEAAIAAAAAAAAAAQOQ BgAMAAAAAQAAAAsAIwAAAAAALwABA5AGAAwAAAABAAAACwApAAAAAAA1AAEEkAYALAQAAAIA AAASAAAAAwAAMAMAAAALAA8OAAAAAAIB/w8BAAAATwAAAAAAAACBKx+kvqMQGZ1uAN0BD1QC AAABAG9yYWNsZWRiYUBxdWlja2RvYy5jby51awBTTVRQAG9yYWNsZWRiYUBxdWlja2RvYy5j by51awAAHgACMAEAAAAFAAAAU01UUAAAAAAeAAMwAQAAABkAAABvcmFjbGVkYmFAcXVpY2tk b2MuY28udWsAAAAAAwAVDAEAAAACAfkPAQAAAE8AAAAAAAAAgSsfpL6jEBmdbgDdAQ9UAgAA ARBvcmFjbGVkYmFAcXVpY2tkb2MuY28udWsAU01UUABvcmFjbGVkYmFAcXVpY2tkb2MuY28u dWsAAAMA/g8GAAAAHgABMAEAAAAbAAAAJ29yYWNsZWRiYUBxdWlja2RvYy5jby51aycAAAIB CzABAAAAHgAAAFNNVFA6T1JBQ0xFREJBQFFVSUNLRE9DLkNPLlVLAAAAAwAAOQAAAAALAEA6 AAAAAAMAcToAAAAAHgD2XwEAAAAZAAAAb3JhY2xlZGJhQHF1aWNrZG9jLmNvLnVrAAAAAAIB 918BAAAATwAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAABAG9yYWNsZWRiYUBxdWlja2RvYy5j by51awBTTVRQAG9yYWNsZWRiYUBxdWlja2RvYy5jby51awAAAwD9XwEAAAADAP9fAAAAAAIB 9g8BAAAABAAAAAAAAAMSAAAAAwAAMAQAAAALAA8OAAAAAAIB/w8BAAAARwAAAAAAAACBKx+k vqMQGZ1uAN0BD1QCAAABAG9yYWNsZS1sQGZhdGNpdHkuY29tAFNNVFAAb3JhY2xlLWxAZmF0 Y2l0eS5jb20AAB4AAjABAAAABQAAAFNNVFAAAAAAHgADMAEAAAAVAAAAb3JhY2xlLWxAZmF0 Y2l0eS5jb20AAAAAAwAVDAEAAAACAfkPAQAAAEcAAAAAAAAAgSsfpL6jEBmdbgDdAQ9UAgAA ARBvcmFjbGUtbEBmYXRjaXR5LmNvbQBTTVRQAG9yYWNsZS1sQGZhdGNpdHkuY29tAAADAP4P BgAAAB4AATABAAAAFwAAACdvcmFjbGUtbEBmYXRjaXR5LmNvbScAAAIBCzABAAAAGgAAAFNN VFA6T1JBQ0xFLUxARkFUQ0lUWS5DT00AAAADAAA5AAAAAAsAQDoAAAAAAwBxOgAAAAAeAPZf AQAAABUAAABvcmFjbGUtbEBmYXRjaXR5LmNvbQAAAAACAfdfAQAAAEcAAAAAAAAAgSsfpL6j EBmdbgDdAQ9UAgAAAQBvcmFjbGUtbEBmYXRjaXR5LmNvbQBTTVRQAG9yYWNsZS1sQGZhdGNp dHkuY29tAAADAP1fAQAAAAMA/18AAAAAAgH2DwEAAAAEAAAAAAAABLzu Received on Tue May 02 2000 - 20:09:26 CDT