Pervasive SQL:Supported Commands and Attributes

Top  Previous  Next

 

 

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

 

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.