Basic:Supported Commands and Attributes

Top  Previous  Next

 

 

File Attributes

Supported

 

CREATE

Y

 

DRIVER(filetype [,driver string])

Y

 

NAME

Y

 

ENCRYPT

N

 

OWNER(password)

N

 

RECLAIM

N

 

PRE(prefix)

Y

 

BINDABLE

Y

 

THREAD

Y4

 

EXTERNAL(member)

Y

 

DLL([flag])

Y

 

OEM

Y

 

 

File Structures

Supported

 

INDEX

N

 

KEY

N

 

MEMO

N

 

BLOB

N

 

RECORD

Y

 

 

Index, Key, Memo, Attributes

Supported

 

BINARY

N

 

DUP

N

 

NOCASE

N

 

OPT

N

 

PRIMARY

N

 

NAME

N

 

Ascending Components

N

 

Descending Components

N

 

Mixed Components

N

 

 

Field Attributes

Supported

 

DIM

Y

 

OVER

Y

 

NAME

Y

 

 

File Procedures

Supported

 

BOF(file)

N

 

BUFFER(file)

N

 

BUILD(file)

N

 

BUILD(key)

N

 

BUILD(index)

N

 

BUILD(index, components)

N

 

BUILD(index, components, filter)

N

 

BYTES(file)

Y5

 

CLOSE(file)

Y

 

COPY(file, new file)

Y

 

CREATE(file)

Y

 

DUPLICATE(file)

N

 

DUPLICATE(key)

N

 

EMPTY(file)

Y

 

EOF(file)

Y

 

FLUSH(file)

N

 

LOCK(file)

Y

 

NAME(label)

Y

 

OPEN(file, access mode)

Y

 

PACK(file)

N

 

POINTER(file)

Y2

 

POINTER(key)

N

 

POSITION(file)

Y3

 

POSITION(key)

N

 

RECORDS(file)

N

 

RECORDS(key)

N

 

REMOVE(file)

Y

 

RENAME(file, new file)

Y

 

SEND(file, message)

Y

 

SHARE(file, access mode)

Y

 

STATUS(file)

Y

 

STREAM(file)

N

 

UNLOCK(file)

Y

 

 

Record Access

Supported

 

ADD(file)

Y

 

ADD(file, length)

N

 

APPEND(file)

Y

 

APPEND(file, length)

N

 

DELETE(file)

N

 

GET(file,key)

N

 

GET(file, filepointer)

Y

 

GET(file, filepointer, length)

N

 

GET(key, keypointer)

N

 

HOLD(file)

N

 

NEXT(file)

Y

 

NOMEMO(file)

N

 

PREVIOUS(file)

N

 

PUT(file)

Y1

 

PUT(file, filepointer)

Y1

 

PUT(file, filepointer, length)

N

 

RELEASE(file)

N

 

REGET(file,string)

Y

 

REGET(key,string)

N

 

RESET(file,string)

Y

 

RESET(key,string)

N

 

SET(file)

Y

 

SET(file, key)

N

 

SET(file, filepointer)

Y

 

SET(key)

N

 

SET(key, key)

N

 

SET(key, keypointer)

N

 

SET(key, key, filepointer)

N

 

SKIP(file, count)

N

 

WATCH(file)

N

 

 

Transaction Processing

Supported

 

LOGOUT(timeout, file, ..., file)

N

 

COMMIT

N

 

ROLLBACK

N

 

 

Null Data Processing

Supported

 

NULL(field)

N

 

SETNULL(field)

N

 

SETNULL(file, field)

N

 

SETNONNULL(field)

N

Notes

1.

When using PUT() with this driver you should take care to PUT back the same number of characters that were read. If you PUT back more characters than were read, then the "extra" characters will overwrite the first part of the subsequent record. If you PUT back fewer characters than were read, then only the first part of the retrieved record is overwritten, while the last part of the retrieved record remains as it was prior to the PUT().

2.

POINTER() returns the relative byte position within the file.

3.

POSITION(file) returns a STRING(4).

4.

THREADed files consume additional file handles for each thread that accesses the file.

5.

BYTES() returns the actual bytes read from the file. The size of the clipped RECORD may be different depending on the file driver and it's DRIVER() strings. With the ASCII or BASIC file drivers BYTES will include the ENDOFRECORD (typically 13,10) byte count, but these bytes are not in the RECORD. With the ASCII driver the /TAB driver string can affect (expand, change or remove) the tab (9) characters in the record buffer resulting in a different length.