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 ]

T

Tab character, gls_api, 4-64, 4-56, 2-12

See also Horizontal white space.,

tabid, sqlr, 1-54, 1-55

Table,

alias. See Alias.,

check constraints for, sqls, 1-234

creating with CREATE TABLE, sqls, 1-211, sqlt, 9-40

creating,

a synonym for, sqls, 1-207

definition of, sqlr, Glossary-20

dependencies, sqlr, 1-32, sqlt, 4-21

descriptor column, sqlt, 8-25

diagnostic, sqls, 1-760

dropping,

from database, sqls, 1-376

synonym for, sqls, 1-374

tables protected from, sqls, 1-378

engine response to locked table, sqls, 1-729

fragmenting, sqlt, 9-45

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

hierarchy, sqlr, Glossary-20

in object-relational model, sqlt, 1-11

in relational model, sqlt, 8-23

INFO...TABLES with, sqls, 1-490

inheritance, sqlr, Glossary-20

isolating, sqls, 1-246

join, sqlt, 4-21

joining, sqls, 1-627

joins in Condition segment, sqls, 1-627

key column, sqlt, 8-25

loading data into, sqls, 1-515

lock mode changes, sqls, 1-88

name.SeeTable name.,

object-relational model, sqlt, 1-11

operations on, sqlt, 1-13

ownership, sqlt, 11-7

primary key, sqlt, 8-25

privileges, sqlt, 11-8 to

privileges on, sqls, 1-220

privileges,

column-specific, sqlr, 1-22, sqls, 1-581

granting, sqls, 1-465 to

revoking, sqls, 1-579 to

syscolauth sample entry, sqlr, 1-8

systabauth information, sqlr, 1-53

systabauth sample entry, sqlr, 1-8

represents an entity, sqlt, 8-25

status, sqls, 1-494

structure in stores7 database, sqlr, A-2

synonym. See Synonym.,

sysdepend (dependencies) information, sqlr, 1-32

systables information, sqlr, 1-54

target, sqls, 1-753

temporary. SeeTemporary table.,

trigger, maximum number of, sqls, 1-260

typed. SeeTyped table.,

types of, sqls, 1-220

unlocking, sqls, 1-777

untyped, sqls, 1-217, sqlt, 10-8

violations, sqls, 1-752

TABLE, sqls, 1-748

Table (database),

in code-set conversion, gls, 1-48, 4-8

in SE database, gls, 6-4

naming, gls, 1-5, 1-6, 6-4, 3-7, 7-6

SE names, gls, 6-6

Table inheritance,

sysinherits information, sqlr, 1-39

with SET EXPLAIN, sqls, 1-721

Table lock. See Lock, table.,

Table name, sqls, 1-1049 to

alias for, sqls, 1-979

alias in SELECT, sqls, 1-610

'statistics', 'outer' as, sqls, 1-977

workarounds for keyword, sqls, 1-979

Table Name segment, sqls, 1-1049

Table synonym,

syssyntabble information, sqlr, 1-52

Table-level constraint,

definition, sqls, 1-231

tables Information Schema view, sqlr, 1-67

Tabs, esqlc, 1-75

Taiwanese dates, gls, 1-16, 1-51, 2-12

TAN function, sqls, 1-938

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

Tape management,

default remote shell (DBREMOTECMD), sqlr, 3-35

personal default qualifier for (ARC_DEFAULT), sqlr, 3-16

tctermcap file for(ARC_KEYPAD), sqlr, 3-16

TARGET environment variable, dbdkug, 6-20, 8-4, 5-38

Target list, dbdkug, 2-11

-target processor option, esqlc, 1-94, 1-84, 1-97, 12-16

Target table,

relationship to diagnostics table, sqls, 1-753

relationship to violations table, sqls, 1-753

Temporary file. See File, temporary.,

Temporary table,

assigning column names, sqlt, 3-13

building distributions, sqls, 1-811

creating with SELECT, sqlt, 2-76

creating with SELECT...INTO TEMP, sqls, 1-643

cursor active set with, sqlt, 5-25

dbspaces for (DBSPACETEMP), sqlr, 3-36

DBSPACETEMP environment variable, sqls, 1-643

description, sqls, 1-218

directory location (DBTEMP), sqlr, 3-38

example, sqlt, 4-12

explicit, sqls, 1-643, 1-218

implicit, sqls, 1-218

INFO statement restrictions, sqls, 1-218

naming, sqls, 1-218

storage location, sqls, 1-219

updating statistics, sqls, 1-811

when deleted, sqls, 1-218

TERM environment variable, sqlr, 3-63

TERMCAP environment variable, sqlr, 3-63

Terminal handling,

DB-Access setup file (INFORMIXTERM), sqlr, 3-52

termcap file location (TERMCAP), sqlr, 3-63

terminal type (TERM), sqlr, 3-63

terminfo file location (TERMINFO), sqlr, 3-64

TERMINFO environment variable, sqlr, 3-64

Territory, gls, 1-20, A-10, 1-33

Test files for DataBlade modules, overview, 2-4

TESTDB environment variable, dbdkug, 8-4

Testing a DataBlade module,

about, overview, 2-7

documentation of, overview, A-8

Testing DataBlade modules,

ActiveX value objects, dbdkug, 6-7

adding test data, dbdkug, 3-42

custom tests, adding, dbdkug, 8-12

directory, dbdkug, 8-10

executing scripts, dbdkug, 8-13

functional test overview, dbdkug, 8-8

initializing reference files, dbdkug, 8-14

SQL scripts, dbdkug, 8-10

UNIX,

installing, dbdkug, 8-6

overview of tasks, dbdkug, 8-7

preparing the environment, dbdkug, 8-4

prerequisite tasks, dbdkug, 8-3

shared object files, dbdkug, 8-4, 8-5

Windows NT,

dynamic link library, using, dbdkug, 9-4

installing, dbdkug, 9-5

overview of tasks, dbdkug, 9-7

preparing the environment, dbdkug, 9-4

prerequisite tasks, dbdkug, 9-3

Tests, for DataBlade modules, overview, 1-26

text,

support for, dapi, 2-4

TEXT data type, sqls, 1-870, sqlt, 9-30

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

collation, sqlr, 2-66

collation order, gls, 1-11

control characters with, sqlr, 2-65

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

declaring host variable for, esqlc, 8-5

defined constant, esqlc, 2-8

definition of, sqlr, Glossary-20

displaying values, sqlt, 2-10

GLS aspects, gls, 3-18

in code-set conversion, gls, 8-12

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

inserting values, sqlr, 2-66

Large object,

character, sqlr, 2-65

length (syscolumns), sqlr, 1-29

loading, sqls, 1-518

locator structure shown, esqlc, 8-7

on optical disc, esqlc, 8-40

partial characters, gls, 3-39

referencing in SPL routine, sqls, 2-11

referencing in User-defined routine (UDR), sqls, 2-18

restrictions,

with GROUP BY, sqlt, 3-6

role of locator.h, esqlc, 2-12, 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, 16-34, 8-15, 8-27

selecting a column, sqlr, 2-66

SQL interactively with, sqlt, 9-32

SQL restrictions, sqlr, 2-65, sqlt, 9-32

subscripting, esqlc, 8-6

sysblobs information, sqlr, 1-18

syscolumns coltype code for, sqlr, 1-24

unloading, sqls, 1-771, 1-773

with LENGTH function, sqlt, 2-60

with SET DESCRIPTOR, sqls, 1-712

Text editor, specifying with DBEDIT, sqlr, 3-26

Text File Import/Export functions, dbdkug, 5-27 to , 6-17, 5-28

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

Text operator,

description of, extend, 2-6

for an opaque type, extend, 5-20

tf(), dapi, 10-4, 10-5

Third normal form, sqlt, 8-34

Thousands separator, gls_api, 4-74, 4-75, 3-5, 3-6, gls, 1-15, 1-19, A-7, 7-19, 3-49

Thread,

in multithreaded application, sqls, 1-687

-thread preprocessor option, esqlc, 1-60, 1-50, 13-6, 1-77, 13-27, 13-17, 1-58

for dynamic thread library, esqlc, 13-51

Thread-safe application, gls_api, 1-21

concurrent connections, esqlc, 13-18

connections across threads, esqlc, 13-20

creating, esqlc, 13-16

cursors across threads, esqlc, 13-24

DCE restrictions, esqlc, 13-25

decimal values, esqlc, 13-30, 13-25

description, sqls, 1-687, 1-690

DISCONNECT ALL statement, esqlc, 13-22

disconnecting in, sqls, 1-348

environment variables, esqlc, 13-25

linking, esqlc, 13-26

preparing statements, esqlc, 13-22

programming hints, esqlc, 13-17

resource allocation, esqlc, 13-26

sample, esqlc, 13-33

SET CONNECTION statement, esqlc, 13-20, 13-18

thread-safe code, esqlc, 13-17

thread-safe DLLs for Windows, esqlc, 1-60

Thread-safe environment, sqls, 1-687

THREADLIB environment variable, sqlr, 3-65, esqlc, 13-26, 13-27

Threads,

managed by virtual processors, dbdkug, 4-6

safety, dbdkug, 4-13

Time data,

customizing format of, gls, 1-50

end-user format, gls, 1-15, 1-39, 1-19, 1-50, A-9

format of, gls, A-8

locale-specific, gls, 1-6, 1-14

precedence of environment variables, gls, 1-52, 7-17

See also Data; DATETIME data type.,

with DBTIME, gls, 2-20

with GL_DATE, gls, 2-35

Time data type,

length (syscolumns), sqlr, 1-28

list of, sqlr, 2-9

Time data types, sqls, 1-871

Time data. See Date/time data.,

Time function,

DATE function, sqls, 1-933

restrictions with GROUP BY, sqls, 1-631

SELECT with, sqlt, 2-53

syntax, sqls, 1-932

TIME locale category,

description of, gls, A-4, A-8

end-user formats, gls, 1-17, A-9

era information, gls, 2-38, A-8, 2-31

in client locale, gls, 1-24

in default locale, gls, A-5

in locale source file, gls, A-12

in server-processing locale, gls, 1-40

TIME locale category. See LC_TIME locale-file category.,

Time-out interval, esqlc, 12-70, 12-54, 12-37

Time. See DATETIME data type.,

timeout sample program, esqlc, 12-70

Times method/routine, dbdkug, 7-10, 6-18

times() function, extend, 2-5

times() operator function, sqls, 1-959

To, sqlr, 1-34

TODAY function, sqls, 1-896, 1-844

constant expression with, sqlt, 4-9

CREATE TABLE with, sqls, 1-223

example, sqls, 1-506

today() built-in function, extend, 2-9

ToString method/routine, dbdkug, 7-10, 6-17

TP/XA. See Transaction manager.,

tprintf(), dapi, 10-4, 10-5

trace classes, dapi, 10-3

TRACE statement,

debugging an SPL routine, sqlt, 14-82

output, sqlt, 15-13

syntax, sqls, 2-57

TraceSet_project procedure, dbdkug, 5-15

tracing, dapi, 10-3

Tracing,

adding, dbdkug, 5-11

C language generated code, in, dbdkug, 5-9

classes, creating, dbdkug, 5-14

codes for messages, dbdkug, 3-20

conditions for, dbdkug, 5-10

DBDK_TRACE_ENTER() macro, dbdkug, 5-13

DBDK_TRACE_EXIT() macro, dbdkug, 5-13

DBDK_TRACE_MSG() macro, using, dbdkug, 5-12

default trace file location, dbdkug, 5-10

defining messages in BladeSmith, dbdkug, 3-19

embedded parameters, dbdkug, 5-11

enabling, dbdkug, 5-14, 5-16

generated file property, dbdkug, 3-50

internationalization of messages, dbdkug, 3-21

level for, dbdkug, 5-13

locale for messages, dbdkug, 3-21

locale, setting, dbdkug, 5-17

message properties, dbdkug, 3-20

output file, setting, dbdkug, 5-17

SQL error text, dbdkug, 3-21

threshold, setting, dbdkug, 5-17

TraceSet_project procedure, creating, dbdkug, 5-15

Trailing blanks,

in VARCHAR conversion, esqlc, 3-13, 3-15

inserting into database, esqlc, 3-14

removing, esqlc, 3-30

with ESQL/C data types, esqlc, 3-5

Trailing white space,

including in length of multibyte-character string, gls_api, 4-155

including in length of wide-character string, gls_api, 4-206

omitting from length of multibyte string, gls_api, 4-166, 4-168

omitting from length of wide-character string, gls_api, 4-212

representation of, gls_api, Intro-11

Transaction, sqlr, Glossary-20

BEGIN WORK, sqls, 1-91

boundaries, sqlt, 4-30

COMMIT WORK, sqls, 1-99

committing, esqlc, 12-30

concurrent, sqls, 1-105

cursors in, sqls, 1-325, 1-95, sqlt, 7-23

data integrity protection, sqlt, 4-28

determining if used, esqlc, 11-30, 11-22, 12-27, 11-15

DISCONNECT behavior, sqls, 1-348

example, sqls, 1-318, sqlt, 6-5

exiting all connections, esqlc, 12-65

inserting rows, sqls, 1-499

interrupting the database server, esqlc, 12-52

locks with, sqlt, 7-10, 7-23

MODE ANSI with, sqlt, 4-30

ROLLBACK WORK, sqls, 1-594

rolling back, esqlc, 12-30

scroll cursor in, sqls, 1-317

smart large objects in, dapi, 3-11, 3-68

SQLWARN flag, sqlt, 5-12

switching server connections, esqlc, 12-30

Transaction logging, sqlr, Glossary-21, sqlt, 4-29

buffered, sqlt, 9-40

contents of log, sqlt, 4-31

establishing with CREATE DATABASE, sqlt, 9-38

turning off for faster loading, sqlt, 9-44

unbuffered, sqlt, 9-39

Transaction mode, sqlr, Glossary-21

constraints, sqls, 1-672

Transaction semantics, dbdkug, 2-21

transaction state changes, dapi, 9-6

transactions,

and server functions, dapi, 11-4

Transitive dependency, sqlt, 8-34

Trigger, gls, 3-7

action clause syntax, sqls, 1-264

actions, sqls, 1-272 to

BEFORE and AFTER, sqls, 1-265

merged, sqls, 1-265

order, sqls, 1-264

references check, sqls, 1-279

REFERENCING, sqls, 1-270

triggering table, sqls, 1-277

WHEN, sqls, 1-271

actions FOR EACH ROW, sqls, 1-265

correlation name with, sqls, 1-267

guidelines, sqls, 1-266

actions,

BEFORE and AFTER, sqlt, 15-7

statements allowed, sqlt, 15-3

tracing, sqlt, 15-13

WHEN, sqlt, 15-10

activating event, sqls, 1-259

DELETE...REFERENCING, sqls, 1-269

execution time, sqls, 1-261

INSERT ON...REFERENCING, sqls, 1-267

UPDATE, sqls, 1-262

UPDATE with cascading triggers, sqls, 1-282

activating from external database, sqls, 1-260

ALTER TABLE...DROP column effects, sqls, 1-76

anyone can use, sqls, 1-281

cascading, sqls, 1-281

restrictions, sqls, 1-282

client/server environment, sqls, 1-284

conditional actions, sqls, 1-271

constraint checking, sqls, 1-282

correlation name, sqls, 1-275, 1-267, 1-279

CREATE TRIGGER, sqls, 1-258

creating, sqlt, 15-4

cursor with, sqls, 1-260

definition of, sqlr, Glossary-21, sqlt, 15-3, udr, 1-13

disabled mode, sqlt, 4-26

DROP TRIGGER, sqls, 1-379

enabled mode, sqlt, 4-26

event, sqlt, 15-5

fragmentation with, sqls, 1-33, 1-36

multiple triggers on update, sqls, 1-263, 1-265

name, sqls, 1-261, sqlt, 15-5

number allowed, sqls, 1-260

object mode, sqls, 1-655

object mode (sysobjstate), sqlr, 1-40

object modes,

DISABLED/ENABLED, sqls, 1-286

setting with SET, sqls, 1-647

preventing overriding, sqls, 1-284

privileges, sqls, 1-280

privileges to activate, sqls, 1-261

privileges to create, sqls, 1-259

referential constraint restriction, sqls, 1-260

renamed column and, sqls, 1-569

SPL routines with, sqlt, 15-11

systrigbody (linearized code), sqlr, 1-58

systriggers information, sqlr, 1-59

using, sqlt, 15-7 to

when to use, sqlt, 15-3

WHEN...FOR EACH ROW with, sqls, 1-272

Triggered action, sqlt, 15-6

error message, sqlt, 15-14

FOR EACH ROW, sqlt, 15-9

statements, udr, 1-13

Triggering statement,

achieving consistent results, sqls, 1-273

Triggering table,

action on, sqls, 1-277

Trigonometric functions, sqls, 1-937 to

TRIM function, sqls, 1-940, gls, 3-40, 8-16

Troubleshooting BladeManager, bldmg_ug, A-1 to

TRUNC function, sqls, 1-911

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

Truncated value,

in CHAR conversion, esqlc, 3-17, 3-11

in decimal conversion, esqlc, 4-52

in VARCHAR conversion, esqlc, 3-13, 3-15

indicated by sqlca, esqlc, 11-31

indicated by SQLSTATE, esqlc, 11-15

of opaque data type, esqlc, 15-31

using indicator variable, esqlc, 1-42, 1-44

with pointers, esqlc, 1-39

-ts preprocessor option, esqlc, 1-58

TU_DAY qualifier macro, esqlc, 6-31

TU_DTENCODE qualifier macro, esqlc, 6-42, 6-32

TU_ENCODE qualifier macro, esqlc, 6-32

TU_END qualifier macro, esqlc, 6-32

TU_FLEN qualifier macro, esqlc, 6-32

TU_Fn qualifier macro, esqlc, 6-32

TU_FRAC qualifier macro, esqlc, 6-32

TU_HOUR qualifier macro, esqlc, 6-31

TU_IENCODE qualifier macro, esqlc, 6-32

TU_LEN qualifier macro, esqlc, 6-32

TU_MINUTE qualifier macro, esqlc, 6-31

TU_MONTH qualifier macro, esqlc, 6-31

TU_SECOND qualifier macro, esqlc, 6-32

TU_START qualifier macro, esqlc, 6-32

TU_YEAR qualifier macro, esqlc, 6-31

Tutorial, described, overview, 2-9

Type,

inheritance, sqlr, Glossary-21

substitutability, sqlr, Glossary-21

Type Compare Support functions, dbdkug, 5-32, 6-18

Type Concatenation Operator, dbdkug, 5-34, 6-18

Type constructor, sqlr, Glossary-21, sqlt, 10-14

LIST, overview, 1-18

MULTISET, overview, 1-18

SET, overview, 1-18

TimeSeries, overview, B-6

Type constructors, dbdkug, 3-32

TYPE descriptor field,

after a DESCRIBE, esqlc, 16-21, 16-6

column type values, esqlc, 16-9, 15-20

definition of, esqlc, 15-7

indicating distinct-type data, esqlc, 15-32

inserting opaque-type data, esqlc, 15-29

setting column type, esqlc, 16-33, 15-32

setting input parameter type, esqlc, 16-41, 16-36

TYPE field,

and DATA field, sqls, 1-709

and LENGTH field, sqls, 1-709

changing from BYTE or TEXT, sqls, 1-712

in X/Open programs, sqls, 1-708

with DESCRIBE, sqls, 1-342

with SET DESCRIPTOR, sqls, 1-706

Type Hash Support function, dbdkug, 5-34, 6-19

Type hierarchy, sqlr, Glossary-21, sqlt, 10-20

description of, udr, 2-10

Type Mathematic Operators, dbdkug, 5-34, 6-18

Type specifier,

definition of, gls_api, 3-10

for converting date strings, gls_api, 4-18

for converting date/time strings, gls_api, 4-27

for converting money strings, gls_api, 4-37

for converting number strings, gls_api, 4-42

for formatting date strings, gls_api, 4-55

for formatting date/time strings, gls_api, 4-63

for formatting money strings, gls_api, 4-73

for formatting number strings, gls_api, 4-79

See also Formatting directive.,

Type substitutability, sqlt, 10-25

Typed collection variable, sqlr, Glossary-21

allocating memory for, esqlc, 9-11

deallocating memory for, esqlc, 9-11

declaring, esqlc, 9-6

operating on, esqlc, 9-13

Typed row variable,

allocating memory for, esqlc, 9-57

deallocating memory for, esqlc, 9-57

declaring, esqlc, 9-50

operating on, esqlc, 9-58

Typed table, sqlr, Glossary-21, sqlt, 10-8

alias, creating, sqlt, 12-6

ALTER TABLE..ADD TYPE, sqls, 1-86

altering, sqls, 1-89

DROP TYPE clause, sqls, 1-90

inheritance with, sqls, 1-216

modifying rows of, sqlt, 12-10

typedef,

as host variable, esqlc, 1-38

dec_t, esqlc, 4-4

dtime_t, esqlc, 6-33, 6-29

intrvl_t, esqlc, 6-30, 6-34

TypeOf method, dbdkug, 7-7

Types, sqlr, 2-9

Typographical conventions, dbdkug, Intro-6, bldmg_ug, Intro-5