Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Try:
noconcatenate
DataNew:
LOAD
*
RESIDENT BSTATUSDATA
ORDER BY RPA,RPB,RPC;
DROP TABLE BSTATUSDATA;
Try:
noconcatenate
DataNew:
LOAD
*
RESIDENT BSTATUSDATA
ORDER BY RPA,RPB,RPC;
DROP TABLE BSTATUSDATA;