Hello,

Please, I need to do an explain of a SQL, as I can make this in the informix (7,3).

Thank you very much

Do you want to do an explain of the access path of an sql-qry?

just use the sql statement:
SET EXPLAIN ON;
and
SET EXPLAIN OFF;

Informix will show exactly what the access path/joins/sorts/costs are

On WinNT/W2K, you find the result in %INFORMIXDIR%\sqexpl
On Unix, it's the directory where you executed dbaccess, or if you go via odbc, it's the homedirectory of the user.

I hope I understood your question correctly.

I am bit confused about the question but I think this could be one answere.

Using dbaccess or telnet do the following when writing quiries.

-----------------------------------------

set explain on;
select * from from table_name

-------------------------------------------

This will create a file name sqexplain.out at the root

editing this file will have the required results.