Sorting on Data Load Editor - error

[jerryr125]

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 ?

[Arthur_Fong · Accepted solution]

Try:

noconcatenate

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


DROP TABLE BSTATUSDATA;