Re: Why Doesn't An Index Download In The Correct Order?

What I usually do is to create a temporary file with the data I need and,
if it is a small table, I use easy400.net 's routines to convert it
directly to Excel. If the result set is big, I convert it to .CSV .

I don't know if you are aware of the CREATE table statement. Instead of
using an insert, you can create a table directly from your SELECT
statement. Using your example:

DROP TABLE MYLIB/MYFILE;

CREATE TABLE MYLIB/MYFILE AS(
select
f1file,f1mbr,f1mbrname,f1lib,f2file,f2mbr,f2mbrname,f2lib
from qgpl/viewAB
order by coalesce (f1lib,f2lib), coalesce(f1file,f2file),
coalesce(f1mbrname,f2mbrname)

) WITH DATA ;

Most of the time, as my queries can be sometimes a little bit complex, I
encapsulate them writing CREATE TABLE statements from inside a
SQLRPGLEprogram, using Dynamic
SQL.

HTH,


Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries