Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Read DBTABLOG table

Former Member

‎02-27-2009 7:14 AM

0 Kudos

Hi Folks,

I want to read DBTABLOG table, basically want to extract data of field LOGDATA.

So please let me know how I can read this field.

Regards,

Amey

5 REPLIES 5

Former Member

‎02-27-2009 7:17 AM

0 Kudos

hi,

do as follows:

select logdata from DBTABLOG where logdata = sy-datum

and TABNAME = give the table name.

thanks,

anupama.

Former Member

‎02-27-2009 7:18 AM

0 Kudos

I guess there is FM for this check with APPlog* in SE37, my system is not working so sorry for asking you to check

Former Member

‎02-27-2009 7:21 AM

0 Kudos

Hi,

READ table DBTABLOG with key LOGDATE.

Regards,

jaya

Former Member

‎02-27-2009 7:29 AM

0 Kudos

USE FM : DBLOG_READ ...

for more info search SCN ...

Former Member

‎02-27-2009 7:33 AM

0 Kudos

Hi,

By using this...

db2 "select SUBSTR(TBSPACE,1,10) AS TABLESPACE, sum(CARD) as CARD, sum(NPAGES) as NPAGES, sum(FPAGES) as FPAGES from syscat.tables where TBSPACEID = 14 group by TBSPACE"

Thanks,

Neelima.