iSeries to excel Order of PF changes
when I use a DTF to download directly to excel the order of my data changes. The PF is NOT keyed and I am NOT selecting any order on the DTF. It is intermitten. any suggestions?
Software/Hardware used:
Software/Hardware used:
ASKED:
February 19, 2008 6:31 PM
UPDATED:
March 12, 2010 9:37 AM
Answer Wiki:
Try to specify a sort inside your DTF or build a Macro (VB Script) to Sort your data after download or build a LF sorted upon your PF and download that instead of PF.
There are numerous possibilities.
==========================================================
The rule has always been if you don't specify an ORDER BY, the order isn't guaranteed. So the obvious suggestion is to specify an ORDER BY.
Tom
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
