| **Navigation:**  SQL Drivers > Pervasive SQL Accelerator Driver >====== Pervasive SQL:Supported Commands and Attributes ====== | [[pervasive sql connection information and driver configuration file properties.htm|{{btn_prev_n.gif|Previous page}}]][[coming future.htm|{{btn_home_n.gif|Return to chapter overview}}]][[sqlanywhere accelerator.htm|{{btn_next_n.gif|Next page}}]] |
|  ||

|  | **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 | 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."

{{tipbox.jpg|TipBox.jpg}}

**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.