Index_O

O

OCTET_LENGTH() scalar function, 248

ODBC. See Advantage ODBC Driver; ODBC SQL Utility

ODBC SQL Utility

Native SQL Utility versus, 266

using, 265–267

OEM character set, determining, 13

OLE DB providers, 372–373

See also Advantage OLE DB Provider

ON reserved keyword, 239, 273

one-to-many relationship, 136–145

open index statistics, 12

open indexes

setting maximum number, 14

statistics about, 12

open tables

setting maximum number, 14

statistics about, 12

opening indexes for free tables, 40

opening tables, 39–41

operator precedence, 243–244

operators in SQL, 243–246

optimized filters, 79–80, 253–254

See also Advantage Optimized Filters (AOFs)

OR reserved keyword, 239, 244

ORDER BY clause, 255, 283–284

ORDER reserved keyword, 239

OUTER reserved keyword, 239, 292

OUTPUT reserved keyword, 239