Understanding SQL*Loader
When using either type of loading method SQL*Loader is called to perform the actual load. There is therefore a requirement that the executable called 'sqlldr' be in the path.
Under UNIX this means that the UNIX user must be able to execute 'sqlldr' from the command prompt under a normal log on.
Under Windows 'sqlldr' must execute when the command is issued from a DOS prompt.
In both the Windows and UNIX environments sqlldr returns a result code indicating if the load worked fully, partially or failed. QAD Data Warehouse Designer makes use of this returned code to report on the results of the load.
File Load
When a file based load table is created a different tab is displayed on the properties screen. This is the
File Attributes tab (see "Load Table File Attributes Screen" on page 268). The fields are described below:
TIP: If the file has been
dragged and dropped (see "
Flat File Loads" on page
260) into the load table (middle pane) then some of the fields on this tab are automatically populated.