Funtion module to 'Determine table and index size online' for DB400

[Former Member]

hi ,

i am using the a custom program for getting the table details,

in this i am using the function module 'DB_TABLE_DATA_READ'.

This is working fine if the DataBase is ORACLE,

But not working for the database DB400,

Please Provide with the alternative function module or any other way

Regards,

Kumar

[christian_bartels]

Kumar,

in what "table details" are you interested? Maybe function module DB4_FILE_INFO could provide you with the information that you need. If you are primarily looking at table sizes, you can also try to query the tables DB4TABLE_STAT and DB4INDEX_STAT directly (in older SAP releases: DBSTATTDB4 and DBSTATIDB4). Please note that the function module and the table structures are no official interfaces, so they may change in future releases.

Kind regards,

Christian Bartels.