Clarion ODBC Driver Supported Attributes


ODBC:Supported Commands and Attributes

 

File Attributes

CREATE

DRIVER(filetype [,driver string])

NAME

ENCRYPT

OWNER(password)

RECLAIM

PRE(prefix)

BINDABLE

THREAD

EXTERNAL(member)

DLL([flag])

OEM

Supported

Y

Y

Y

N

Y2

N

Y

Y

Y6

Y

Y

N3


File Structures

INDEX

KEY

MEMO

BLOB N

RECORD



Supported

Y3

Y3

N


Y


Index, Key, Memo Attributes

BINARY

DUP

NOCASE

Y OPT

PRIMARY

NAME

Ascending Components

Descending Components

Mixed Component

Supported

N7

Y

Y

N

Y

Y

Y

Y

Y

Y

Field Attributes

DIM

OVER

NAME



Supported

N

Y

Y



File Procedures

BOF(file)

BUFFER(file)

BUILD(file)

BUILD(key)

BUILD(index)

BUILD(index, components)

BUILD(index, components, filter)

BYTES(file)

CLOSE(file)

COPY(file, new file)

CREATE(file)

DUPLICATE(file)

DUPLICATE(key)

EMPTY(file)

EOF(file)

FLUSH(file)

LOCK(file)

NAME(label)

OPEN(file, access mode)

PACK(file)

POINTER(file)

POINTER(key)

POSITION(file)

POSITION(key)

RECORDS(file)

RECORDS(key)

REMOVE(file)

RENAME(file, new file)

SEND(file, message)

SHARE(file, access mode)

STATUS(file)

STREAM(file)

UNLOCK(file)



Supported

N

Y

Y

Y

Y8

Y8

N

Y

Y

N

Y

Y

Y

Y

N

N

N

Y


N

N

N

N

Y

Y

Y

Y

N

Y

Y

Y

N

N


Record Access

ADD(file)

ADD(file, length)

APPEND(file)

APPEND(file, length)

DELETE(file)

GET(file,key)

GET(file, filepointer)

GET(file, filepointer, length)

GET(key, keypointer)

HOLD(file)

NEXT(file)

NOMEMO(file)

PREVIOUS(file)

PUT(file)

PUT(file, filepointer)


Supported

Y

N

Y

N

Y

Y

N

N

N

N

Y

N

Y4

Y

N



Record Access

PUT(file, filepointer, length)

RELEASE(file)

REGET(file,string)

REGET(key,string)

RESET(file,string)

RESET(key,string)

SET(file)

SET(file, key)

SET(file, filepointer)

SET(key)

SET(key, key)

SET(key, keypointer)

SET(key, key, filepointer)

SKIP(file, count)

WATCH(file)



Supported

N

N

N

Y

N

Y

Y4

N

N

Y

Y

N

N

Y

Y


Transaction Processing

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

COMMIT

ROLLBACK


Supported

Y9

Y

Y


Null Data Processing

NULL(field)

SETNULL(field)

SETNONNULL(field)


Supported

Y

Y

Y



Notes

  • The Clarion ODBC file driver supports the listed items, however, the underlying file system may not support all of these items.
  • 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.
  • International sorting is assumed to be done by the underlying file system. As such the OEM attribute and the .ENV file are ignored.
  • PREVIOUS is not supported in file order.
  • See also PROP:Logout in the Language Reference.
  • THREADed files do not consume additional file handles for each thread that accesses the file.
  • BUILD(index) sets internal driver flags to guarantee the driver generates the correct ORDER BY clause. The driver does not call the backend server.
  • Whether LOGOUT also LOCKs the table depends on the server's configuration for transaction processing. See your server documentation..