The following section describes the use of the SQL proc statement in conjunction with the UD8 driver.
There are two types of DML string supported:
If the DML string begins with a colon ":" it specifies the filename for a table.
If the DML string does not begin with a colon it specifies a single driver parameter.
Before calling sql with the ud8 driver you should always close the path.
close "$ud8" sql ":CUSTOMER:create:c:\cus.csv","$ud8"
Specify a filename for a table
The filename string is divided into 3 parts, separated by the colon ":".
If the openmode is ‘create’, then when the file is opened any existing contents of the file will be deleted.
Specify a new setting for a parameter
All parameters described in the parameters help page are supported, however most will have undesirable site effects if the path is not closed first.
sql "heading disable","$ud8"
|$Revision: 1.10 $ $Date: 2011/02/28 02:56:33 $||[go to top]|