| Navigation: SQL Drivers > ODBC Accelerator Driver >====== ODBC:Supported Commands and Attributes ====== |    |
| File Attributes | Supported | |
| CREATE | Y | |
| DRIVER(filetype [,driver string]) | Y | |
| NAME | Y | |
| ENCRYPT | N | |
| OWNER(password) | Y2 | |
| RECLAIM | N | |
| PRE(prefix) | Y | |
| BINDABLE | Y | |
| THREAD | Y6 | |
| EXTERNAL(member) | Y | |
| DLL([flag]) | Y | |
| OEM | N3 | |
| File Structures | Supported | |
| INDEX | Y3 | |
| KEY | Y3 | |
| MEMO | N | |
| BLOB | Y | |
| RECORD | Y | |
| Index, Key, Memo Attributes | Supported | |
| BINARY | N7 | |
| 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) | Y8 | |
| BUILD(index, components) | Y8 | |
| 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) | Y4 | |
| 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) | Y4 | |
| 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) | Y9 | |
| COMMIT | Y | |
| ROLLBACK | Y | |
| Null Data Processing | Supported | |
| NULL(field) | Y | |
| SETNULL(field) | Y | |
| SETNULL(file,field) | Y | |
| SETNONNULL(field) | Y |
Notes
1 The Clarion ODBC file driver supports the listed items, however, the underlying file system may not support all of these items.
2 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.
3 International sorting is assumed to be done by the underlying file system. As such the OEM attribute and the .ENV file are ignored.
4 PREVIOUS is not supported in file order.
5 See also PROP:Logout in the Language Reference.
6 THREADed files do not consume additional file handles for each thread that accesses the file.
7 BUILD(index) sets internal driver flags to guarantee the driver generates the correct ORDER BY clause. The driver does not call the backend server.
8 Whether LOGOUT also LOCKs the table depends on the server's configuration for transaction processing. See your server documentation..