Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.