How to get column information from db logs

[Ruslan]

I made updating of one field and got log record appropriate to the updating. I have pre-image and after-image data in my log but I need columns type of updated field. how can I figure it out from log?

[kleach]

You can get column type information from the system catalogs. Columns typename, length and scale are most useful.

select * from syscat.columns where tabschema='YOURSCHEMA' and tabname='YOURTABLE' and COLNAME='YOURCOLUMN';

[Ruslan]

Thanks! That is what I`ve already done.