ODBC - keyed file commands¶

Keyed file commands used with ODBC

The following keyed file commands work in a similar way on tables in an ODBC database as they do on Sculptor keyed files:

delete	Delete a record from a file.
find[u]	Find and read a record by full or partial key value.
match[u]	Read next record matching current search data.
next[u]	Read the next record in a file.
nextkey	Read key data only from the next record in a file.
prev[u]	Read the previous record in a file.
prevkey	Read key data only from the previous record in a file.
read[u]	Read a record using exact key data.
readkey	Read key data only from a record using exact key data.
rewind	Reposition a file or secondary index at its start.
testkey	Test for a record with a specified key.
wind	Position a file or secondary index at the end.
write[kl]	Write a record back to a file. On some SQL databases, using writekl (not write) can substantially improve performance.

If an ODBC file has the property file_id->batch = ON, a forward-only cursor is used for file access commands that do not lock the data file. See Reading records in batches.

RELATED TOPICS

ODBC