Professional Web Applications Themes

Search many tables - IBM DB2

Hi, I need to search all tables and all records in a large database (v. 7.2) for at text string. Are there any _easy_ ways of doing this? TIA! Jakob...

  1. #1

    Default Search many tables

    Hi,

    I need to search all tables and all records in a large database (v. 7.2) for
    at text string.

    Are there any _easy_ ways of doing this?

    TIA!

    Jakob


    Teknik Guest

  2. #2

    Default Re: Search many tables

    "Teknik & System" <dk> wrote in message
    news:3f94fcef$0$27460$news.tele.dk... 
    for 

    How easy do you want?

    SELECT 'SELECT * FROM ' || TABSCHEMA || '.' || TABNAME
    || ' WHERE ' || COLNAME || ' LIKE ''%your_search_value%'';'
    FROM SYSCAT.VIEWS
    WHERE TYPENAME IN ('CHAR','VARCHAR','CLOB','LONG VARCHAR','CHARACTER')

    Regards
    Paul Vernon
    Business Intelligence, IBM Global Services


    Paul Guest

  3. #3

    Default Re: Search many tables

    Paul Vernon schrieb:
     
    >
    > for

    >
    >
    > How easy do you want?
    >
    > SELECT 'SELECT * FROM ' || TABSCHEMA || '.' || TABNAME
    > || ' WHERE ' || COLNAME || ' LIKE ''%your_search_value%'';'
    > FROM SYSCAT.VIEWS[/ref]

    FROM SYSCAT.COLUMNS :-)
     

    .... and you get tons of select statements!

    Regards,
    --
    Burkhard Schultheis
    Tele Data Electronic, Wagnerstr. 10, D-76448 Durmersheim
    Email: de
    Phone: +49-7245-9287-21, Fax: +49-7245-9287-30
    Burkhard Guest

Similar Threads

  1. ANN: InterAKT Site Search - search in multiple tables
    By Alexandro Colorado in forum Macromedia Dynamic HTML
    Replies: 0
    Last Post: November 29th, 04:23 PM
  2. #25786 [NEW]: PHP website uses cookies to remember last search phrase in search box
    By tipsen at imada dot sdu dot dk in forum PHP Development
    Replies: 0
    Last Post: October 8th, 08:24 AM
  3. Search within Search Results
    By Maria Kovacs in forum ASP Database
    Replies: 1
    Last Post: October 7th, 04:45 PM
  4. XP Search - how to not search inside .ZIP files
    By Tom D. in forum Windows XP/2000/ME
    Replies: 1
    Last Post: July 16th, 08:54 PM
  5. Search for string in all tables in one schema
    By TurkBear in forum Oracle Server
    Replies: 4
    Last Post: July 9th, 01:14 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139