Sorting on Data Load Editor - error

jerryr125 — Wed, 15 Jan 2020 19:08:30 GMT

Hi - I am trying to sort a table in the data load editor

I authored the following:

TempTable:
LOAD BSTATUSDATA
*;
DataNew:
LOAD
*
RESIDENT TempTable
ORDER BY RPA,RPB,RPC;

DROP TABLE TempTable;

The original Table is BSTATUSDATA

Any thoughts ?

Re: Sorting on Data Load Editor - error

Arthur_Fong — Thu, 16 Jan 2020 00:56:33 GMT

Try:

noconcatenate DataNew: LOAD * RESIDENT BSTATUSDATA ORDER BY RPA,RPB,RPC; DROP TABLE BSTATUSDATA;