Navigation: SQL Drivers > MSSQL Accelerator >====== MSSQL Accelerator Supported File Commands and Functions ====== | |
File Attributes | Supported | |
CREATE | Y | |
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 | N | |
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 | |
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.