To get the column information from SELECT Query.
Posted in 2006
SW — — source: Usenet: comp.databases.informix
I want to find out the Column Information from an SELECT Query. Above operation is possible in the SQL SERVER. U can see the code for that on the link, "http://groups.google.co.in/group/microsoft.public.sqlserver.programming/ browse_thread/thread/c4b4be733a6b4cba/37c68c72b00996b%2337c68c7 2b00996b?sa=X&oi=groupsr&start=1&num=3" Stored procedure written in above link does a wonderful job. Given any SQL SELECT Query as parameter it will get the column informations about all the rows which are returned by this SELECT query. I can not figure out what they are doing actually in that procedure. Does anybody know how to accomplish the same thing in Informix 4GL? Thanks in advance, Shirish Wagh