Explaination of the subtle differences of the "Load" & "From" statements

[#1]

Hi All,

At the moment, I haven't got my head around when to use the following syntax:

"Load" & "from"

vs

"Load" & "SQL Select *" & "From"

vs

"Load" & "Resident"

Could someone kindly explain the subtle differences between the above, and when to use which (ie loading an xl file, vs inline load etc...)

Kind regards,

Rich

[#2 · Accepted solution]

Hi,

Depends of the source.
xls file or txt or qvd file you will use Load * from file.qvd;

From a databse (fe SAP erp) you will need to use a connector (ODBC or other). For Sap it gives:

Select * from Table;

Resident is when reading internal table.

first load external table:

MyTable:

Load * from data.txt;

//then read in a second time from internal table:

SecondLoad:

Load * resident MyTable;

hope its clear.