Quick ways to load into a resident table

[tinkerz1]

Can you wildcard from a load table like the below script and it will use the aliases?

.

tab1:

Select * from transtable;

Load * resident tab1 order by C desc, B asc, 1 desc;

Will that work?

Thanks,

Neil.

[alexandros17]

tab1:

Select * from transtable;

Load * resident tab1 order by C desc, B asc, 1 desc;

it works and concatenates the 2 tables result, but why you do not order in the select?

[MK_QSL]

tab1:

Select * from transtable;

Noconcatenate

Load * resident tab1 order by C desc, B asc, 1 desc;

Drop Table tab1;

[tinkerz1]

Can tab1 be empty?

I mean never be loaded into? So 'tab1:' initiates a blank table?

My problem is I use autonumber on a concatenated string to make it unique.

But I lose the order of the 2 elements in the sort order, ie name and location

So then I need to sort those 2 elements as sort by text does not work in a expression, I need to sort in the load order.