Master Index

Home

Index Key

[ A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Symbols ]

F

Feature icons, sqlr, Intro-10, sqls, Intro-11, sqlt, Intro-10

Features, product, sqlr, Intro-6, sqls, Intro-7, sqlt, Intro-7

FET_BUF_SIZE environment variable, instll32, 29, sqlr, 3-43

FETCH statement, sqls, 1-411 to , sqlt, 5-22

ABSOLUTE keyword, sqlt, 5-24

checking results with SQLCA, sqls, 1-424

CLOSE with, sqls, 1-94

collection derived table with, sqls, 1-833

collection variables with, sqls, 1-833

collection with, sqls, 1-422

fetching a row for update, sqls, 1-421

INTO clause, sqls, 1-418

INTO clause location, sqlt, 5-23

locking considerations, sqls, 1-421

NEXT keyword, sqls, 1-414

program arrays with, sqls, 1-418

row numbers, sqls, 1-416

sequential cursor with, sqls, 1-414

syntax error, bad cursor name, sqls, 1-980

USING DESCRIPTOR clause, sqls, 1-420

USING SQL DESCRIPTOR clause, sqls, 1-437, 1-419

with,

scroll cursor, sqls, 1-415

X/Open mode, sqls, 1-414

Field, sqlr, Glossary-8, sqlt, 10-5

Field delimiter (DBDELIMITER), sqlr, 3-26

Field projection, sqls, 1-888, sqlt, 12-9

File,

compared to database, sqlt, 1-3

loading data into database, sqls, 1-515

.lok extension, explanation of, sqls, 1-729

OUTPUT statement with, sqls, 1-539

sqexplain.out, sqls, 1-714

temporary, sorting, sqlr, 3-60

temporary,

dbspace (DBSPACETEMP), sqlr, 3-36

directory for (DBTEMP), sqlr, 3-38

directory for sorting (PSORT_DBTEMP), sqlr, 3-60

termcap, terminfo, sqlr, 3-63, 3-52

unloading data from database, sqls, 1-769

File extension, .iem, instll32, 27

FILETOBLOB function, sqlr, 2-33, sqls, 1-926

FILETOCLOB function, sqlr, 2-38, sqls, 1-923, 1-924, 1-926

FILLFACTOR clause in CREATE INDEX, sqls, 1-156

Filter, sqlr, Glossary-9

Filtering data in queries, vis_ug, 3-24

Filtering object mode, sqls, 1-658

benefits of, sqls, 1-671

defined, sqlt, 4-25

Find command, vis_ug, 12-8

Finding objects, vis_ug, 7-10, 7-3, 7-8

First normal form, sqlt, 8-32

Fixed point, sqlr, 2-45

Fixed-length data type,

opaque data type, sqls, 1-169

Fixed-point data types, sqlt, 9-13

FLOAT data type, sqlr, 2-47, sqls, 1-868, sqlt, 9-11

casts for, sqlr, 2-27

syscolumns coltype code for, sqlr, 1-24

unloading, sqls, 1-771

Floating point, sqlr, 2-44

single-precision (FLOAT), sqlr, 2-47

Floating-point data types, sqlt, 9-12

FLUSH statement, sqls, 1-426

count of rows inserted, sqlt, 6-11

writing rows to buffer, sqlt, 6-10

Folders, in the Scenes panel, vis_ug, 7-6

Font objects, vis_ug, 7-10, 5-34

Modifying,

character fonts, vis_ug, 7-10

properties of, vis_ug, A-30

FOR statement, sqls, 2-22

IN keyword, sqls, 2-26

TO keyword, sqls, 2-24, 2-25

FOREACH statement, sqls, 2-27

collection derived table with, sqls, 1-833

collection variables with, sqls, 1-833

Foreign key, sqlr, Glossary-9, sqlt, 4-21, 8-27

Foreign key constraint, sqls, 1-233

Format,

DATE, specifying (DBDATE), sqlr, 3-24

DATETIME, specifying (DBTIME), sqlr, 3-38

MONEY, specifying with DBMONEY, sqlr, 3-29

Formats. See Layouts.,

Formatting symbols, vis_ug, 7-12

Formatting values, vis_ug, B-8, 7-14

Forms. See Simple forms.,

Fragment,

privileges,

duration of, sqls, 1-484

granting with GRANT FRAGMENT, sqls, 1-480

revoking with REVOKE FRAGMENT, sqls, 1-589

sysfragauth information, sqlr, 1-34

Fragmentation, sqlt, 9-45 to

accessing table data, sqlt, 9-52

adding fragments, sqls, 1-46

altering, sqls, 1-29

arbitrary rule, sqls, 1-249

attaching tables, sqls, 1-32

CREATE INDEX..BY EXPRESSION, sqls, 1-158

CREATE TABLE..FRAGMENT BY, sqls, 1-247

dbspace for round-robin, sqls, 1-44

defining and initializing, sqls, 1-38

detaching fragments, sqls, 1-37

disk space, sqls, 1-31

dropping fragments, sqls, 1-48

expression-based, sqls, 1-44

fragment expressions, sqls, 1-159, 1-45

information (INFO statement), sqls, 1-492

initializing, sqlt, 9-50

log space, sqls, 1-31

modifying, sqls, 1-49, sqlt, 9-49

PDQ priority, setting (PDQPRIORITY), sqlr, 3-58

PDQ with SET EXPLAIN, sqls, 1-719

PDQPRIORITY, sqls, 1-735

remainder fragment, sqls, 1-48

round robin distribution, sqls, 1-44

row space, sqls, 1-31

rowid column, sqlt, 9-53

rowid columns, sqls, 1-44

rowid columns with, sqls, 1-244, 1-88

skipping an unavailable dbspace, sqls, 1-692

strategy,

arbitrary rule, sqls, 1-45

by expression, sqls, 1-158, 1-249

hash rule, sqls, 1-249, 1-45

range rule, sqls, 1-249, 1-45

round robin, sqls, 1-248

sysfragments information, sqlr, 1-36

Fragmentation initialize, sqls, 1-38

Frame object properties, vis_ug, A-31

FREE statement, sqls, 1-429

cursors with, sqls, 1-538

freeing prepared statements, sqlt, 5-33

implicit, sqls, 1-677

statement identifier in, sqls, 1-431

with AUTOFREE feature, sqls, 1-677

Frequently Asked Questions (FAQ), vis_ug, Intro-8

Function, sqls, 1-903 to

aggregate, sqls, 1-946 to

EXISTS subquery with, sqls, 1-851

algebraic, sqls, 1-905 to

as column name, sqls, 1-973

casting, sqls, 1-116

creating indirectly from a stored file, sqls, 1-135

creating with CREATE FUNCTION, sqls, 1-125 to

creating with CREATE FUNCTION FROM, sqls, 1-134

definition of, sqlr, Glossary-9

dropping with DROP FUNCTION, sqls, 1-354

dropping with DROP ROUTINE, sqls, 1-368

exponential, sqls, 1-918

expression with, sqls, 1-903 to

length, sqls, 1-920

logarithmic, sqls, 1-918

name, sqls, 1-399, 1-964

fully qualified, sqls, 1-965

privileges, sqls, 1-129

procedure contrasted with, sqls, 1-182

See also each function listed under its own name.,

SELECT with, sqlt, 2-50

shared library, sqls, 1-922

smart large object, sqls, 1-925

system catalog tables for, sqls, 1-127

time, sqls, 1-932 to

trigonometric, sqls, 1-937 to

used with BLOB columns, sqlr, 2-33

user-defined, sqls, 1-942 to

Function cursor, sqls, 1-401, 1-308

closing, sqls, 1-94

default mode, sqls, 1-309

opening, sqls, 1-531, 1-537

reopening, sqls, 1-537

Function Modifier, sqls, 1-1027

Function Name segment, sqls, 1-964

Function Parameter List, sqls, 1-1033

Functional dependency, sqlt, 8-33

Functional index,

description, sqls, 1-138

in composite index, sqls, 1-153

specifying name of, sqls, 1-144

Functions,

allowed in property expressions, vis_ug, 7-12

built-in, vis_ug, C-4, 7-12

cast, vis_ug, B-7, 7-14

color, vis_ug, 7-14

defining queries with aggregate, vis_ug, 3-7

in location property, vis_ug, 7-14

in object properties, vis_ug, 7-12

in queries, vis_ug, 3-7, 3-9

numeric, vis_ug, 7-14

See also Property functions.,

sequence, vis_ug, 7-14

StockImage, vis_ug, 11-7

syntax conventions, vis_ug, Intro-7

tree, vis_ug, 7-14

user-defined, vis_ug, C-16, 7-12

using aggregate, vis_ug, 3-7, 3-12