Clarion Community Help

Navigation: SQL Drivers >====== SQL Accelerator Drivers:Supported Commands and Attributes ======

File Attributes	Supported
CREATE	Y5
DRIVER(filetype [,driver string])	Y
NAME	Y
ENCRYPT	N
OWNER(password)	Y1
RECLAIM	N
PRE(prefix)	Y
BINDABLE	Y
THREAD	Y
EXTERNAL(member)	Y
DLL([flag])	Y
OEM	N
File Structures	Supported
INDEX	Y
KEY	Y
MEMO	N
BLOB	Y
RECORD	Y
Index, Key, Memo Attributes	Supported
BINARY	N3
DUP	Y
NOCASE	Y
OPT	N
PRIMARY	Y
NAME	Y
Ascending Components	Y
Descending Components	Y
Mixed Components	Y
Field Attributes	Supported
DIM	N
OVER	Y
NAME	Y
File Procedures	Supported
BOF(file)	N
BUFFER(file)	Y
BUILD(file)	Y
BUILD(key)	Y
BUILD(index)	Y3
BUILD(index, components)	Y3
BUILD(index, components, filter)	N
BYTES(file)	Y
CLOSE(file)	Y
COPY(file, new file)	N
CREATE(file)	Y
DUPLICATE(file)	Y
DUPLICATE(key)	Y
EMPTY(file)	Y
EOF(file)	N
FLUSH(file)	N
LOCK(file)	N
NAME(label)	Y
OPEN(file, access mode)	Y
PACK(file)	N
POINTER(file)	N
POINTER(key)	N
POSITION(file)	N
POSITION(key)	Y
RECORDS(file)	Y
RECORDS(key)	Y
REMOVE(file)	Y
RENAME(file, new file)	N
SEND(file, message)	Y
SHARE(file, access mode)	Y
STATUS(file)	Y
STREAM(file)	N
UNLOCK(file)	N
Record Access	Supported
ADD(file)	Y
ADD(file, length)	N
APPEND(file)	Y
APPEND(file, length)	N
DELETE(file)	Y
GET(file,key)	Y
GET(file, filepointer)	N
GET(file, filepointer, length)	N
GET(key, keypointer)	N
HOLD(file)	N
NEXT(file)	Y
NOMEMO(file)	N
PREVIOUS(file)	Y
PUT(file)	Y
PUT(file, filepointer)	N
PUT(file, filepointer, length)	N
RELEASE(file)	N
REGET(file,string)	N
REGET(key,string)	Y
RESET(file,string)	N
RESET(key,string)	Y
SET(file)	Y
SET(file, key)	N
SET(file, filepointer)	N
SET(key)	Y
SET(key, key)	Y
SET(key, keypointer)	N
SET(key, key, filepointer)	N
SKIP(file, count)	Y
WATCH(file)	Y
Transaction Processing	Supported 2
LOGOUT(timeout, file, …, file)	Y4
COMMIT	Y
ROLLBACK	Y
Null Data Processing	Supported
NULL(field)	Y
SETNULL(field)	Y
SETNULL(file,field)	Y
SETNONNULL(field)	Y

Notes

1	We recommend using a variable password that is lengthy and contains special characters because this more effectively hides the password value from anyone looking for it. For example, a password like “dd….#$…*&” is much more difficult to “find” than a password like “SALARY.”

To specify a variable instead of the actual password in the Owner Name field of the File Properties dialog, type an exclamation point (!) followed by the variable name. For example: !MyPassword.

2	See also PROP:Logout in the Language Reference.
3	BUILD(index) sets internal driver flags to guarantee the driver generates the correct ORDER BY clause. The driver does not call the backend server.
4	Whether LOGOUT also LOCKs the table depends on the server's configuration for transaction processing. See your server documentation.
5	Although CREATE is supported, only basic use is recommended, because it cannot handle all of the features (i.e., constraints and relationships) that an actual SQL CREATE TABLE statement can support. Use of PROP:SQL is preferred in this case.