Resident is used if data should be loaded from a previously loaded table. Table label is a label preceding the load or select statement(s) that created the original table. The label should be given with a colon at the end.
This really isn't helpful. If all you can suggest is researching other knowledge sources then you shouldn't bother. I've asked this question because I haven't been able to find an answer I fully understand. I did look it up in the Reference Manual but my general ignorance of QV was insufficient to comprehend the definition.
If we all did what you suggest then there'd really be no point of a Community forum. Remember, not all of us are techies.
A good example where resident is used is when using interval match
OrderLog will be your 1st table name, it contains Start and End times (Range) EventLog will be the 2nd table, it contains actual event times (Actuals)
Now to match the event times in the 2nd table with the start and end times in the 1st table we use the intervalmatch function, but instead of reloading the data from the source again, we point to the existing data in the OrderLog table using the Resident command instead