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 ]

B

B-tree access method, dbdkug, 2-20

B-tree index, sqlr, Glossary-2

btree_ops operator class, sqls, 1-179

default operator class, sqls, 1-179

sort order options, sqls, 1-145

uses, sqls, 1-151

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

B-tree secondary access method, sqls, 1-151

B-tree. See Generic B-tree.,

Bachman, C. R., sqlt, 8-19

Backslash (\) character, esqlc, 1-19

Backslash. See\, backslash.,

Backup. See Archiving.,

Base data type,

See Opaque data type.,

Basic Text Input/Output functions, dbdkug, 5-21 to , 5-25, 6-17

Batch file, bldmg_ug, 3-6

-bc processor option, esqlc, 1-79

BEGIN WORK statement, sqls, 1-91

specifies start of a transaction, sqlt, 4-30

BETWEEN conditions, gls, 3-25

Binary File Import/Export functions, dbdkug, 5-28 to , 6-18, 5-29

Binary large object (blob), gls, 1-48, 8-13, 4-7

See also BYTE data type TEXT data type.,

Binary Large Object (BLOB),

buffer size variable (DBBLOBBUF), sqlr, 3-19

effect of isolation on retrieval, sqls, 1-747, 1-726

Binary large object (blob). See Simple large-object data type.,

Binary representation,

LO handle, dapi, 3-62

Binary Send/Receive functions, dbdkug, 5-26 to , 6-17, 5-27

Bindary data type. See BLOB data type; BYTE data type; Smart large object; Simple large object.,

BladeManager, dbdkug, C-1, 1-4, 7-4, overview, 2-6

BladeManager command line interface,

confirmation, setting, bldmg_ug, 3-5

connecting as a different user, bldmg_ug, 3-8

connecting to a different server, bldmg_ug, 3-8

connection problems, bldmg_ug, A-1

displaying DataBlade module information, bldmg_ug, 3-14

executing commands at startup, bldmg_ug, 3-6

executing multiple commands, bldmg_ug, 3-6

exiting, bldmg_ug, 3-5

failure to execute, bldmg_ug, 3-5

help command, bldmg_ug, 3-5

installing, bldmg_ug, 3-4

installing client files, bldmg_ug, 3-12

interfaces, ensuring availability of, bldmg_ug, 3-10

listing available databases, bldmg_ug, 3-8

listing available servers, bldmg_ug, 3-8

listing client files, bldmg_ug, 3-12

log files, bldmg_ug, 3-14

managing DataBlade modules, bldmg_ug, 3-7 to

preparation, bldmg_ug, 3-9

prerequisite tasks, bldmg_ug, 3-3

registering DataBlade modules, bldmg_ug, 3-9

starting, bldmg_ug, 3-5

uninstalling client files, bldmg_ug, 3-13

unregistering DataBlade modules, bldmg_ug, 3-11

upgrading DataBlade modules, bldmg_ug, 3-10

BladeManager GUI,

Client Files page, bldmg_ug, 2-10

connection problems, bldmg_ug, A-1

Databases page, bldmg_ug, 2-4

default user, bldmg_ug, 2-6

displaying DataBlade module information, bldmg_ug, 2-13

installing, bldmg_ug, 2-4

installing client files, bldmg_ug, 2-11

interfaces, ensuring availability of, bldmg_ug, 2-7

log files, bldmg_ug, 2-12

Logs page, bldmg_ug, 2-12

managing DataBlade modules, bldmg_ug, 2-4 to

Module Info page, bldmg_ug, 2-14

preparation, bldmg_ug, 2-6

prerequisite tasks, bldmg_ug, 2-3

registering DataBlade modules, bldmg_ug, 2-7

starting, bldmg_ug, 2-4

uninstalling client files, bldmg_ug, 2-11

unregistering DataBlade modules, bldmg_ug, 2-9

upgrading DataBlade modules, bldmg_ug, 2-8

blademgr.run file, bldmg_ug, 3-6

BladePack,

building an installation, dbdkug, 10-19, 6-24

components, dbdkug, 10-14

custom extensions, dbdkug, 10-17

DataBlade module packaging tasks, overview, 2-8

described, overview, 2-5

directories, dbdkug, 10-11

distribution media, creating, dbdkug, 10-26

files, dbdkug, 10-11

item view, dbdkug, 10-6

on-line help, dbdkug, 10-5

packaging overview, dbdkug, 10-9

prerequisite tasks, dbdkug, 10-3

project view, dbdkug, 10-6

registry changes, dbdkug, 10-13

software requirements, dbdkug, Intro-5, overview, Intro-5

windows, dbdkug, 10-6

BladeSmith,

aggregates, creating, dbdkug, 3-12, overview, 1-13

casts, creating, dbdkug, 3-17

client files, adding, dbdkug, 3-46, overview, 1-27

data types in, overview, 1-14

data types, creating, dbdkug, 3-31 to , 3-42, 6-9

DataBlade module creation tasks, overview, 2-7

DataBlade module objects, creating, dbdkug, 3-11 to , 3-42, 6-9

described, overview, 2-3

description locale, dbdkug, 3-10

end-user routines, writing, overview, 1-23

errors, creating, dbdkug, 3-19

generated files, dbdkug, 6-13, 6-14, 3-47 to , 3-56, B-1 to

including qualified data types in, overview, 1-15

interfaces, creating, dbdkug, 3-21

item view, dbdkug, 3-6

locale, default for, dbdkug, 3-21

new object prefix, using, dbdkug, 3-9

opaque data type support functions, writing, overview, 1-23

overloading routines in, overview, 1-22

overview of, dbdkug, 1-4

privilege, setting for objects, dbdkug, 3-12

project view, dbdkug, 3-6

project, creating, dbdkug, 3-7

SQL statements, adding custom, dbdkug, 3-44

test data, adding, dbdkug, 3-42

test scripts, dbdkug, 8-10

tracing macros from, identifying, dbdkug, 5-7

user-defined routines, creating, dbdkug, 3-22

utility functions from, identifying, dbdkug, 5-7

utility functions generated, dbdkug, 5-19

viewing property sheets, dbdkug, 3-7

windows, dbdkug, 3-5

Blank character, gls_api, 4-74, 2-12

See also Horizontal white space.,

Blank class, gls_api, 4-18, 4-93, 4-166, 4-155, 4-212, 4-168, 4-41, 4-117, 4-206, 4-36, 4-25, 2-12, 2-13, 4-16, 4-28

.bld file, build file, dbdkug, 6-20, 6-24, 10-10, 7-4, 5-36, 9-7, 6-19

BLOB data type, sqlr, 2-33, sqls, 1-870, sqlt, 9-26, dbdkug, C-1, 2-7

Glossary-2, sqlr, Glossary-2

attributes in syscolattribs, sqlr, 1-20

casting not available, sqlr, 2-33

coltype code for, sqlr, 1-26

column-level storage characteristics, dapi, 3-44

contents of, dapi, 3-15

copying to a file, sqls, 1-928

copying to a smart large object, sqls, 1-930

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

creating from a file, sqls, 1-926

declaring host variable for, esqlc, 7-7

definition of, dapi, 3-15

deleting, dapi, 3-80

displaying values, sqlt, 2-10

fetching, dapi, 3-17, 3-61

handle values, sqls, 1-890

implementation of, esqlc, 10-48

inserting, dapi, 3-18, 3-61

inserting data, sqlr, 2-34

on optical disc, esqlc, 7-32

restrictions,

with GROUP BY, sqlt, 3-6

role of locator.h, esqlc, 2-11

See also ifx_lo_t data type; Smart-large-object data type.,

See also Smart large object.,

SQL restrictions, sqlt, 9-26

storage (PUT) location for, sqls, 1-250

syntax, sqls, 1-869

unloading, sqls, 1-771, 1-773

updating, dapi, 3-18, 3-72, 3-61, 3-55

blob. See Binary large object (blob).,

blob.See Simple large object.,

blobpage, sqlr, Glossary-2

blobspace, sqlr, 2-19, Glossary-2, sqlt, 9-32

blobspaces,

size and location, sqlr, 1-18

Blocking system calls,

in DataBlade module routines, dbdkug, 4-10

.bom file, bill of materials, dbdkug, 10-5

BOOLEAN data type, sqlr, 2-34, sqlt, 9-19

Glossary-2, sqlr, Glossary-2

coltype code for, sqlr, 1-26

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

data conversion, esqlc, 2-18, 2-14

defined constant, esqlc, 2-9

description of, sqlr, 2-34

distinct-bit constant, esqlc, 15-32

distinct-bit macro, esqlc, 15-32

See also boolean data type.,

unloading, sqls, 1-770

boolean data type,

corresponding SQL data type, esqlc, 2-13

declaration, esqlc, 2-13

defined constant, esqlc, 2-11

See also BOOLEAN data type.,

Boolean expression,

TEXT data type limitation, sqlr, 2-65

Boolean function, sqlr, Glossary-2

Borland compiler, invoking, esqlc, 1-79

Bourne shell,

.profile file, sqlr, 3-8

setting environment variables, sqlr, 3-8

Breakpoints,

setting on UNIX, dbdkug, 8-18

setting on Windows NT, dbdkug, 9-11

Btree cleaner list, sqls, 1-815

Buffer,

size for fetch (FET_BUF_SIZE), sqlr, 3-43

Buffer-size estimate,

case conversion, gls_api, 2-16, 4-11, 2-23, 4-49

code-set conversion, gls_api, 2-40, 2-23, 4-49

Buffer. See Cursor buffer., esqlc, Buffer.

Build file, esqlc, 1-83

Building your data model, sqlt, 8-3 to

Building. See Compiling.,

Built-in data type, sqlr, 2-9 to , sqlt, 9-5 to , extend, 1-13

Glossary-2, sqlr, Glossary-2

as element type of collection, esqlc, 9-6

as field type in row, esqlc, 9-50

casting, system-defined, sqlr, 2-32, 2-25

description of, extend, 1-5

INT, sqlr, 2-47

owner, sqls, 1-122

See also each data type listed under its own name.,

syntax, sqls, 1-861 to

Built-in data types, overview, 1-15

Built-in function,

definition of, extend, 2-8, 1-9

for an opaque type, extend, 5-21, 5-7

Built-in functions, overview, 1-22

bycmpr() library function, esqlc, 3-21

bycopy() library function, esqlc, 3-24

bye command, bldmg_ug, 3-15

byfill() library function, esqlc, 3-26

byleng() library function, esqlc, 3-28

BYTE data type, sqlr, 2-35, sqls, 1-870, sqlt, 9-31

Glossary-2, sqlr, Glossary-2

code-set conversion, gls, 1-48, 8-12, 4-7

coltype code for, sqlr, 1-24

corresponding ESQL/C data , esqlc, type 2-4, 2-11

declaring host variable for, esqlc, 8-5

defined constant, esqlc, 2-8

displaying values, sqlt, 2-10

inserting, esqlc, 8-34, 8-23, 8-28, 8-17

inserting data, sqlr, 2-35

length (syscolumns), sqlr, 1-29

LENGTH function, sqlt, 2-60

loading, sqls, 1-518

locator structure shown, esqlc, 8-7

on optical disc, esqlc, 8-40

partial characters, gls, 3-39

referencing, sqls, 2-18

referencing in SPL routine, sqls, 2-11

restrictions,

in Boolean expression, sqlr, 2-35

with GROUP BY, sqlr, 2-35, sqlt, 3-6

with LIKE or MATCHES, sqlr, 2-35

with ORDER BY, sqlr, 2-35

role of locator.h, esqlc, 2-11, 1-23

See also Binary large object (blob).,

See also loc_t data type; Simple large-object data type.,

See also Simple large object.,

selecting, esqlc, 8-33, 8-22, 8-15, 8-27

selecting a BYTE column, sqlr, 2-36

SQL interactively with, sqlt, 9-32

SQL restrictions, sqlt, 9-32

subscripting, esqlc, 8-6

sysblobs information, sqlr, 1-18

unloading, sqls, 1-771, 1-773

with SET DESCRIPTOR, sqls, 1-712

byte ordering,

converting for integers, dapi, 12-122

converting for smallints, dapi, 12-124

Bytes,

comparing, esqlc, 3-21

copying, esqlc, 3-24

determining number of, esqlc, 3-28

filling with a character, esqlc, 3-26

bytes, copying, dapi, 12-166, 12-390