User Tools

Site Tools


b2j48dn.htm
Navigation:  SQL Drivers > Pervasive SQL Accelerator Driver >====== Pervasive SQL:Supported Commands and Attributes ====== Previous pageReturn to chapter overviewNext 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 Supported2
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

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.

b2j48dn.htm.txt · Last modified: 2021/04/15 15:56 by 127.0.0.1