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 ]

R

-r processor option, esqlc, 1-80, 1-89

R-tree access method, dbdkug, 2-20

R-tree access method, example of, overview, B-3

R-tree index, sqlr, Glossary-15, extend, 4-5

creating, sqls, 1-152

default operator class, sqls, 1-179, extend, 4-18, 4-9

extending, extend, 4-18, 4-24

rtree_ops operator class, sqls, 1-179

strategy functions, extend, 4-10

support functions, extend, 4-10

uses, sqls, 1-151

R-tree indexing support functions, dbdkug, 5-33, 6-18

Radix character. See Decimal separator.,

RAISE EXCEPTION statement, sqls, 2-49, sqlt, 14-84

RANGE function, sqls, 1-954

Range matches, gls, 3-29

Range rule, sqls, 1-159

Rational operator,

list of, sqlt, 2-28

RawCopy method, dbdkug, 6-26

.rc file extension, esqlc, 1-80, 1-87, 1-89

rdatestr() library function, esqlc, 6-6, gls, 7-8, 1-13, 7-9

rdayofweek() library function, esqlc, 6-8

rdefmtdate() library function, esqlc, 6-10, 6-37, gls, 7-10, 7-8

rdownshift() library function, esqlc, 3-32, gls, 7-23

Read Committed isolation level (ANSI), sqls, 1-745, sqlt, 7-14

Read Uncommitted isolation level (ANSI), sqls, 1-745, sqlt, 7-13

Read-only cursor,

opening, sqls, 1-530

ReadBoolean method, dbdkug, 6-29

ReadChar method, dbdkug, 6-29

ReadDate method, dbdkug, 6-29

ReadDateTime method, dbdkug, 6-29

ReadDecimal method, dbdkug, 6-29

ReadDoublePrecision method, dbdkug, 6-29

ReadGLWChar method, dbdkug, 6-29

ReadGLWString method, dbdkug, 6-30

Reading an input string, dbdkug, 5-20, 6-28

ReadInt1 method, dbdkug, 6-30

ReadInt8 method, dbdkug, 6-30

ReadInteger method, dbdkug, 6-30

ReadInterval method, dbdkug, 6-30

Readme files, dbdkug, A-1, 5-4

ReadMoney method, dbdkug, 6-30

ReadReal method, dbdkug, 6-30

ReadSmallInt method, dbdkug, 6-30

ReadString method, dbdkug, 6-30

ReadUChar1 method, dbdkug, 6-30

ReadUInt8 method, dbdkug, 6-30

ReadUInteger method, dbdkug, 6-31

ReadUSmallInt method, dbdkug, 6-31

ReadWChar method, dbdkug, 6-31

ReadWString method, dbdkug, 6-31

REAL data type, sqls, 1-868

REAL data type. See SMALLFLOAT data type.,

REAL data type. SeeSMALLFLOAT data type.,

REATE TRIGGER statement,

DELETE REFERENCING clause, sqls, 1-268

Receive routine, dbdkug, 6-17

Receive support function, sqls, 1-172

as casting function, extend, 5-17

description of, extend, 6-11, 5-5

locale-sensitive data, extend, 6-25

parameter type, extend, 5-16

return type, extend, 5-16

summary of, extend, 6-4

reconnecting, dapi, 12-445

Recursive relationship, sqlt, 8-30, 8-12

Redirection, sending commands to BladeManager, bldmg_ug, 3-6

Redundant relationship, sqlt, 8-31

Reference count, esqlc, 7-31, 7-89, dapi, 12-350, 3-80, 12-231, 3-81, 3-55, 3-78, 3-14

decrementing, dapi, 12-277, 12-224

Reference files, initializing for testing, dbdkug, 8-14

References, sqls, 1-10

Referencing ActiveX value objects, dbdkug, 7-4

Referential constraint, sqls, 1-70

data type considerations, sqlt, 9-6

definition of, sqlr, Glossary-15

disallowing with REVOKE REFERENCES, sqls, 1-580

enforcing, sqls, 1-228

establishing with CREATE TABLE..REFERENCES, sqls, 1-237

index name, sqls, 1-229

locking, sqls, 1-239

modifying a column with, sqls, 1-78

See alsoConstraint; Cascading deletes.,

sysreferences information, sqlr, 1-49

with other constraints, sqls, 1-83

Referential constraints,

ALTER TABLE...REFERENCES, sqls, 1-68

Referential integrity, sqlt, 4-19, 4-21

defining primary and foreign keys, sqlt, 8-27

See alsoReferential constraint; Constraint.,

regcopy utility, esqlc, 1-6

Regenerating files, dbdkug, 3-55

register command, bldmg_ug, 3-17

Registering DataBlade modules,

about, overview, 2-6

BladeManager command line interface, using, bldmg_ug, 3-9

BladeManager graphical user interface, using, bldmg_ug, 2-7

documentation of, overview, A-8

log file for, bldmg_ug, 2-7, 3-10

preparation, bldmg_ug, 2-6, 3-9

problems with, bldmg_ug, A-3

Registering dynamic thread functions, esqlc, 13-49

Registration, dbdkug, C-1, B-3

Registry,

connection information in, esqlc, 12-8

in-memory copy, esqlc, 1-112

InformixServer, esqlc, 12-95

precedence, esqlc, 1-112

registry file, gls, A-18, A-20

Regular expression, gls, 1-26, 1-5

Related reading, gls_api, Intro-14, gls, Intro-17

Relational database, sqlr, Glossary-15

Relational model,

attribute, sqlt, 8-17

description of, sqlt, 8-3 to

entity, sqlt, 8-5

join, sqlt, 2-8

many-to-many relationship, sqlt, 8-13

normalizing data, sqlt, 8-31

one-to-many relationship, sqlt, 8-13

one-to-one relationship, sqlt, 8-13

projection, sqlt, 2-7

resolving relationships, sqlt, 8-29

rules for defining tables, rows, and columns, sqlt, 8-23

selection, sqlt, 2-6

Relational operation, sqlt, 2-6

Relational operator,

BETWEEN, sqls, 1-842, 1-622, sqlt, 2-31

condition with, sqls, 1-841

description of, extend, 2-6

equals, sqlt, 2-29

EXISTS, sqls, 1-851, 1-625, sqlt, 3-30

for an opaque type, extend, 5-23

IN, sqls, 1-622, 1-843, sqlt, 3-30

LIKE, sqls, 1-623, 1-846

MATCHES, sqls, 1-623, 1-847

NOT, sqlt, 2-31

NULL, sqlt, 2-34

OR, sqlt, 2-32

segment, sqls, 1-1019

SELECT statement with, sqls, 1-621

WHERE clause with, sqlt, 2-28

Relational-operator conditions, gls, 3-24

Relationship,

attribute, sqlt, 8-17

cardinality, sqlt, 8-11, 8-15

complex, sqlt, 8-30

connectivity, sqlt, 8-10, 8-13

defining in data model, sqlt, 8-9

entity, sqlt, 8-6

existence dependency, sqlt, 8-10

mandatory, sqlt, 8-10

many-to-many, sqlt, 8-10, 8-13

many-to-many, resolving, sqlt, 8-29

one-to-many, sqlt, 8-10, 8-13

one-to-one, sqlt, 8-10, 8-13

optional, sqlt, 8-10

recursive, sqlt, 8-30

redundant, sqlt, 8-31

using matrix to discover, sqlt, 8-11

Release notes, sqlr, Intro-15, sqls, Intro-20, esqlc, Intro-14, sqlt, Intro-13, gls_api, Intro-14, dapi, Intro-10, gls, Intro-17, dbdkug, Intro-11, overview, Intro-7, extend, Intro-10, udr, Intro-10, bldmg_ug, Intro-8

ReleaseConnect() library function, esqlc, 12-93, 12-98

RENAME DATABASE statement, sqls, 1-571

RENAME TABLE statement,

ANSI-compliant naming, sqls, 1-572

syntax, sqls, 1-572

Repeatable Read isolation level, sqlt, 7-16

emulating during update, sqls, 1-422

with SET ISOLATION statement, sqls, 1-724

with SET TRANSACTION, sqls, 1-745

Requirements, bldmg_ug, Intro-4

.res file extension, esqlc, 1-80, 1-87, 1-89

Reserved words, sqls, 1-968

delimited identifiers with, sqls, 1-971

identifiers with, sqls, 1-968

Resolution,

in UPDATE STATISTICS, sqls, 1-814

with data distributions, sqls, 1-814

Resource compiler,

default options, esqlc, 1-84

passing arguments to, esqlc, 1-80, 1-89

specifying compiled resource file, esqlc, 1-80

specifying file to compile, esqlc, 1-80

Resource file, esqlc, 1-80, 1-87, gls_api, 1-12

Resource permissions, bldmg_ug, 2-6

Resource privilege, sqlt, 11-6

Resource.h file, dbdkug, B-3

Response file, esqlc, 1-83, 1-56

Restrictions,

on optimized message transfers, esqlc, 12-42

on OPTOFC feature, esqlc, 14-36

Retrieving an error message, esqlc, 11-48

RETURN statement, sqls, 2-51 to

Return types,

aggregate, for, dbdkug, 3-13

user-defined routines, for, dbdkug, 3-23

Return value,

declaring in CREATE FUNCTION, sqls, 1-1025

multiple values, udr, 3-14

RETURN statement for, sqls, 2-51

Return values. See individual function names.,

REVOKE FRAGMENT statement, sqls, 1-589 to , sqlt, 9-55

REVOKE statement,

ALL keyword behavior, sqls, 1-582

CASCADE keyword, sqls, 1-587

column-specific privileges, sqls, 1-581

effect on grantor chain, sqls, 1-587

EXECUTE ON (user-defined routine), sqls, 1-583

Execute privilege, extend, 5-29

in embedded SQL, sqlt, 5-35 to

No record found message, sqls, 1-581

Privilege not revoked message, sqls, 1-582

privileges needed, sqls, 1-576

RESTRICT option, sqls, 1-588

role name and privileges, sqls, 1-586

table-level privileges, sqls, 1-579

Usage privilege, extend, 5-28

Rewind operator, dbdkug, 6-29

rfmtdate() library function, esqlc, 16-62, 6-14, 6-37, gls, 7-10, 7-8

rfmtdec() library function, esqlc, 16-62, 5-37, gls, 7-17

rfmtdouble() library function, esqlc, 5-41, gls, 7-17

rfmtlong() library function, esqlc, 5-44, gls, 7-20, 7-17, 7-18

rgetlmsg() library function, esqlc, 11-48

rgetmsg() library function, esqlc, 11-51

risnull() library function, esqlc, 1-43, 2-24

rjulmdy() library function, esqlc, 6-17

rleapyear() library function, esqlc, 6-19

rmdyjul() library function, esqlc, 6-21

Role, gls, 3-6

creating with CREATE ROLE, sqls, 1-193

dropping with DROP ROLE, sqls, 1-366

enabling with SET ROLE, sqls, 1-738, sqlt, 11-18

establishing with CREATE, GRANT, SET, sqls, 1-476

granting name with GRANT, sqls, 1-476

granting privileges with GRANT, sqls, 1-477, sqlt, 11-17

naming restrictions, sqlt, 11-16

revoking privileges with REVOKE, sqls, 1-586

separation (INF_ROLE_SEP), sqlr, 3-53

sysroleauth information, sqlr, 1-50

sysroleauth system catalog table, sqlt, 11-18

sysusers system catalog table, sqlt, 11-18

using, sqlt, 11-16

ROLLBACK WORK statement, esqlc, 12-30, 15-18

closes cursors, sqlt, 7-23

releases locks, sqlt, 7-10, 7-23

roll back defined, sqlr, Glossary-15

sets SQLCODE, sqlt, 6-5

syntax, sqls, 1-594

use with WHENEVER, sqls, 1-595

WHENEVER with, sqls, 1-92, 1-98

with DROP DATABASE, sqls, 1-353

ROOT function, sqls, 1-909

Root supertype, sqlr, Glossary-15

root() built-in function, extend, 2-8

ROUND function, sqls, 1-909

round() built-in function, extend, 2-8

Routine, sqlr, Glossary-15

creating with CREATE ROUTINE FROM, sqls, 1-195

dropping with DROP ROUTINE, sqls, 1-368

execution plan (sysprocplan), sqlr, 1-48

header, sqls, 2-10

optimization information (sysprocplan), sqlr, 1-48

overloading, sqlr, Glossary-15

parameter list, sqls, 1-1033

privileges, sqls, 1-189

protected, sqlr, 1-48

resolution, sqlr, Glossary-16

restrictions in SQL statements, sqls, 1-1044

security purposes, sqlt, 11-3

See also User-defined routine.,

setting SQLSTATE, sqls, 1-453

signature, sqlr, Glossary-16

specific name, sqls, 1-1040

SQL statements not valid in, sqls, 1-1043

sysprocbody contains source, sqlr, 1-45

sysprocedures information, sqlr, 1-46

SYSTEM statements permission, sqls, 2-55

wildcard argument, udr, 2-16

Routine identifier, extend, 5-16

Routine Modifier, sqls, 1-1027

Routine modifier,

CLASS, sqls, 1-1030

CLIENT, sqls, 1-1030

HANDLESNULLS, sqls, 1-1029

INTERNAL, sqls, 1-1031

ITERATOR, sqls, 1-1032

NOT VARIANT, sqls, 1-1031

PERCALL_COST, sqls, 1-1030

SELFUNC, sqls, 1-1030

STACK, sqls, 1-1031, dapi, 11-5

VARIANT, sqls, 1-1031

Routine name,

ANSI-compliant, udr, 2-5

Routine overloading, sqlt, 10-24, extend, 2-3, 4-11, 2-11

description, udr, 2-3, 3-4

routine signature, udr, 2-4

Routine resolution, sqlt, 10-26, extend, 2-3, 4-11, 2-11

ANSI-compliant database, udr, 2-8

candidate list, udr, 2-8

description of, udr, 2-7

distinct type, udr, 2-12

effect of inheritance, udr, 2-10, 2-11

effect of null value argument, udr, 2-15

internal routines, sqls, 1-1031

order of arguments, udr, 2-11

order of casting, udr, 2-15

precedence list, udr, 2-8

return values, sqls, 1-1025

type hierarchy, udr, 2-10

Routine signature,

ANSI-compliant, udr, 2-5

description, udr, 2-4

See also Routine name.,

use in CREATE statement, udr, 2-5

use in SQL statements, udr, 2-4

Routines,

built-in, overview, 1-22

Compare, dbdkug, 6-18

Concat, dbdkug, 5-34, 6-18

Contains, dbdkug, 6-18

DataBlade API, using, overview, 1-22

defining with BladeSmith, dbdkug, 3-22

definition, overview, 1-22

delete operator, dbdkug, 6-34

Divide, dbdkug, 6-18

documentation of, overview, A-8

Equal, dbdkug, 6-18

ExportBinary, dbdkug, 6-18

ExportText, dbdkug, 6-17

free, dbdkug, 6-34, 4-13

FromString, dbdkug, 6-17

GreaterThan, dbdkug, 6-18

GreaterThanOrEqual, dbdkug, 6-18

Hash, dbdkug, 5-34, 6-19

ImportBinary, dbdkug, 6-18

ImportText, dbdkug, 6-17

Inter, dbdkug, 6-18

LessThan, dbdkug, 6-18

LessThanOrEqual, dbdkug, 6-18

list of categories of, overview, 1-22

malloc, dbdkug, 6-34, 4-6, 4-13

memory management, dbdkug, 6-34

Minus, dbdkug, 6-18

Negate, dbdkug, 6-18

new operator, dbdkug, 6-34

NotEqual, dbdkug, 6-18

operator, overview, 1-22

Overlap, dbdkug, 6-18

overloading, overview, 1-22

Plus, dbdkug, 6-18

Positive, dbdkug, 6-18

QueryInterface, dbdkug, 7-6

Receive, dbdkug, 6-17

See also Methods.,

See also User-defined routines.,

Send, dbdkug, 6-17

Size, dbdkug, 6-18

Stored Procedure Language, using, overview, 1-22

support, overview, 1-23

SYSBldTstSBSpace, dbdkug, C-1

Times, dbdkug, 6-18

ToString, dbdkug, 6-17

Union, dbdkug, 6-18

user-defined, overview, 1-23

Within, dbdkug, 6-18

Row,

checking rows processed in SPL routines, sqlt, 14-89

defining, sqlt, 8-23

deleting, sqlt, 4-4

cascading to child rows, sqlt, 4-23

empty, finding with indicator variable, sqls, 1-958

engine response to locked row, sqls, 1-729

in relational model, sqlt, 8-23

insert cursor, sqls, 1-498

inserting, sqlt, 4-7

inserting multiple, sqlt, 4-10

inserting through a view, sqls, 1-497

inserting values, sqls, 1-499

inserting,

with a stored procedure, sqls, 1-509

with a user-defined function, sqls, 1-509

instance of entity, sqlt, 1-13

loading into database, sqls, 1-516

multirow, fetching with cursor, sqls, 1-413

none selected, finding with COUNT (*), sqls, 1-958

number vs. rowid with FETCH, sqls, 1-416

object-relational model, sqlt, 1-13

order, effect on trigger, sqls, 1-266

phantom, sqls, 1-745, 1-724

sorting with SELECT...ORDER BY, sqlt, 2-12

unloading from database, sqls, 1-770

updating through a view, sqls, 1-781

writing buffered rows with FLUSH, sqls, 1-426

Row constructor, esqlc, 9-70

ROW constructor, sqls, 1-900

Row data type, gls, 4-18

row data type (ESQL/C),

accessing a typed table, esqlc, 9-72

allocating memory for, esqlc, 9-57

client-side, esqlc, 9-56

Collection Derived Table clause, esqlc, 9-59

corresponding SQL data type, esqlc, 2-5, 2-13

deallocating memory for, esqlc, 9-57

declaration, esqlc, 9-49

defined constant, esqlc, 2-11

deleting from, esqlc, 9-68

fetching from, esqlc, 9-64

fetching into, esqlc, 9-62

field names, esqlc, 9-68

field values, esqlc, 9-69

initializing, esqlc, 9-62

inserting into, esqlc, 9-64

literal values, esqlc, 9-69

named row variable, esqlc, 9-53

nested rows, esqlc, 9-66

operating on, esqlc, 9-58

See also Row type (SQL).,

typed row variable, esqlc, 9-50

untyped row variable, esqlc, 9-52

updating, esqlc, 9-66

Row data type(ESQL/C),

with a collection, esqlc, 9-26

Row data types, dbdkug, 2-6

defined, overview, 1-20

defining in BladeSmith, dbdkug, 3-40

denormalization with, overview, 1-21

example of, overview, B-4, B-6

fields in, overview, 1-20

fields, data type restrictions, dbdkug, 3-42

illustration of, overview, 1-21

inheritance, dbdkug, 3-42

inheritance for, overview, 1-21

named, dbdkug, 3-41

properties, dbdkug, 3-41

unnamed, dbdkug, 3-41

Row lock. See Lock, row.,

Row type, sqlr, 2-24

accessing, sqlt, 12-4

casting, sqlt, 13-6 to

casting individual field, sqlt, 13-13

casting permitted, sqlr, 2-32

collection type literal in, sqls, 1-1008

constructor syntax, sqls, 1-900

definition of, sqlr, Glossary-16

deleting, sqls, 1-337

dot notation with, sqls, 1-888, sqlt, 12-9

field information (sysattrtypes), sqlr, 1-17

field projection, sqlt, 12-9

field-level literal values, sqls, 1-1007

loading field values, sqls, 1-522, 1-518

nested, sqls, 1-1007, sqlt, 12-10, 10-12

selecting columns of, sqlt, 12-7

selecting fields, sqls, 1-604, 1-618

selecting from, sqls, 1-617

sysattrtypes information, sqlr, 1-17

syscolumns coltype code for, sqlr, 1-24

sysxtddesc contents for, sqlr, 1-62

sysxtdtypes information, sqlr, 1-64

unloading, sqls, 1-771, 1-775

updating, sqls, 1-789, 1-803

Row type See also Named row type; Unnamed row type.,

Row type (SQL),

accessing, esqlc, 9-48

as element type of collection, esqlc, 9-6

as field type of row, esqlc, 9-50

constructed rows, esqlc, 9-70

corresponding ESQL/C data type, esqlc, 2-5, 2-13

declaring host variables for, esqlc, 9-49

defined constant, esqlc, 2-9

definition of, esqlc, 9-48

deleting, esqlc, 9-76, 9-68

dot notation, esqlc, 9-74, 9-66

extended identifier, esqlc, 15-13, 15-9

fetching, esqlc, 9-62, 9-64

in dynamic SQL, esqlc, 15-13

inserting into, esqlc, 9-74, 9-64, 9-71

literal values, esqlc, 9-74, 9-75, 9-43, 9-69

nested, esqlc, 9-70

owner of, esqlc, 15-14, 15-9

See also row data type (ESQL/C).,

selecting from, esqlc, 9-73

typed table, esqlc, 9-72

updating, esqlc, 9-74, 9-66, 9-71

ROW type. See Unnamed row type.,

Row variable,

accessing, sqls, 1-835

allocating memory for, sqls, 1-27

deallocating memory for, sqls, 1-301

definition of, sqlr, Glossary-16

deleting, sqls, 1-337

inserting, sqls, 1-505

inserting into, sqls, 1-514

literalSee Literal, Row,

See alsoCollection derived table.,

selecting from, sqls, 1-617

updating, sqls, 1-803

Rowid,

adding with ALTER FRAGMENT, sqls, 1-44

adding with ALTER TABLE, sqls, 1-88

adding with CREATE TABLE, sqls, 1-244

column expression with, sqls, 1-890

column name as, sqls, 1-977

fragmented tables and, sqlt, 9-52

join using, sqlt, 3-15

locating internal row numbers, sqlt, 3-17

restrictions, sqls, 1-890

rsetnull() library function, esqlc, 2-27, 2-14

rstod() library function, esqlc, 3-34

rstoi() library function, esqlc, 3-36

rstol() library function, esqlc, 3-38

rstrdate() library function, esqlc, 6-23, gls, 7-8, 7-9

-rt processor option, esqlc, 1-93

rtoday() library function, esqlc, 6-26

rtree secondary access method, sqls, 1-151

rtypalign() library function, esqlc, 17-23, 17-12, 2-30

rtypmsize() library function, esqlc, 17-23, 17-12, 2-33

rtypname() library function, esqlc, 2-36

rtypwidth() library function, esqlc, 2-39

Rule,

arbitrary, sqls, 1-160

hash, sqls, 1-159

range, sqls, 1-159

Running C preprocessor first,

options for, esqlc, 1-68

Runtime environment, esqlc, 1-98

Runtime errors,

definition of, esqlc, 11-5

in user-defined routines, esqlc, 11-18, 11-25

Informix-specific messages, esqlc, 11-25

See also Error handling; Warnings.,

using rgetlmsg(), esqlc, 11-48

using rgetmsg(), esqlc, 11-51

using sqlca structure, esqlc, 11-38

using SQLSTATE variable, esqlc, 11-24

using the WHENEVER statement, esqlc, 11-45

-runtime processor option, esqlc, 1-93, 1-85

Runtime routines, exporting, esqlc, 1-90

rupshift() library function, esqlc, 3-40, gls, 7-23