Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Posts
    1

    Unanswered: search value could be any table/column

    how can i search a field value without specifying the tables and the columns where i can find it? it could be in any tables or field of the db: i know it would take a long time to run, but i think is that useful that it's worth the wait!

  2. #2
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    Hi,

    such functionality has never been implemented ( at my knowlege), in an RDBMS ...
    As you say, it would take a long time to run and also incomodate other users due to performance loss.

    In any case, you can try to write some perl script, using DBI::Informix, read the systables and sycolumns tables to get the column names, do a huge foreach and all those names, then PREPARE and EXECUTE each query with the your where clause.

    But again, a RDBMS is not designed and built for such a query. RDBMS is for organized data, not for unorganized data. The performance loss will severely impact all the other users connected.

    unless you Informix engine is SE, where you can egrep the .dat files ...

    Google desktop could also be a good solution if using .dat files ...

    No other idea from here :-(

    Eric

Posting Permissions

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