How to insert records into tables residents?

[#1]

I need to insert records into a table resident, as I can do?

The resident table is created from a query to SQL

[Carlos_Reyes · Accepted solution]

Do you mean you want to append new records at the end of the table? If so, you can use CONCATENATE to do it.

For example:

SQL_TABLE:

LOAD

          A,

          B,

          C

FROM SQL TABLE;

CONCATENATE (SQL_TABLE)

LOAD

          A,

          B,

          C

FROM ANOTHER SOURCE;