var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Glob tables
What query can I run to find all Glob Tables in my database?
What are "Glob Tables"? By the way, all table are listed in SYSCAT.TABLES
Sorry..... Typo..... They call them LOB or BLOB.......
I generally use
SELECT distinct rtrim(tabschema)||'.'||rtrim(TABNAME) from syscat.columns where typename like ('%LOB%')
The query may get more complicated if you have LOB UDTs, in which case, you will have to join syscat.columns with SYSCAT.DATATYPES
Visit the new-look IDUG Website
, register to gain access to the excellent content.