Results 1 to 4 of 4

Thread: Glob tables

  1. #1
    Join Date
    May 2002
    Posts
    43

    Unanswered: Glob tables

    What query can I run to find all Glob Tables in my database?

    Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    What are "Glob Tables"? By the way, all table are listed in SYSCAT.TABLES

  3. #3
    Join Date
    May 2002
    Posts
    43
    Sorry..... Typo..... They call them LOB or BLOB.......

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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

    HTH
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •