Search all columns in Informix table for a value

[Bulldog13]

I am new to Informix, but remember doing this with SQL Server. Basically I want to query all columns in a given table for a specified value (I am learning how a new program works and, as always, documentation is lacking).

Everything I googled references doing it in SQL server.

Also, what flavor of SQL does Informix use? For example, MS uses T-SQL, Oracle uses PL-SQL....

Thanks

 

[Evadman]

I have used informix for a few years, but never to do what you are asking. I would use separate statements on each column. In mql, I would use a temp table to house the columns, and search that way. That way would also work in informix, but the syntax would need to be changed somewhat.

Try one of the free IBM ebooks on informix here or here. You can also try the IIUG. By the way, you can download the full featured developer version of informix from here for free. then you can try whatever instead of running on prod.

 

[Bulldog13]

Thanks Evadman for the ebooks.

Got the answer here, similar to what you described.

http://stackoverflow.com/questions/4328331/search-all-columns-in-informix-table-for-a-value

It was selecting on each column and then combining the results with a UNION.

Not as easy as the T-SQL solution I found once, but it'll do.