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 ]

S

SameType method, dbdkug, 7-7

Sample program,

bycmpr, esqlc, 3-22

bycopy, esqlc, 3-24

byfill, esqlc, 3-27

byleng, esqlc, 3-29

create_clob, esqlc, 7-100

decadd, esqlc, 4-9

deccmp, esqlc, 4-11

deccopy, esqlc, 4-14

deccvasc, esqlc, 4-6, 4-17

deccvdbl, esqlc, 4-19

deccvint, esqlc, 4-21

deccvlong, esqlc, 4-23

decdiv, esqlc, 4-26

dececvt, esqlc, 4-29

decfcvt, esqlc, 4-33

decmul, esqlc, 4-35

decround, esqlc, 4-38

decsub, esqlc, 4-40

dectoasc, esqlc, 4-43

dectodbl, esqlc, 4-45

dectoint, esqlc, 4-48

dectolong, esqlc, 4-50

dectrunc, esqlc, 4-53

demo1, esqlc, 1-117

demo2, esqlc, 14-54

demo3, esqlc, 16-37, 16-15, 17-18

demo4, esqlc, 17-34, 14-54, 16-15

dispcat_pic, esqlc, 8-44, 11-59

dtaddinv, esqlc, 6-41

dtcurrent, esqlc, 6-43

dtcvasc, esqlc, 6-46

dtcvfmtasc, esqlc, 6-49

dtextend, esqlc, 6-52

dtsub, esqlc, 6-55

dtsubinv, esqlc, 6-58

dttoasc, esqlc, 6-60

dttofmtasc, esqlc, 6-63

dyn_sql, esqlc, 11-59

ESQLAUTH, esqlc, 12-16

getcd_me, esqlc, 8-15

getcd_nf, esqlc, 8-27

getcd_of, esqlc, 8-22

ILOGIN, esqlc, 1-112

incvasc, esqlc, 6-66

incvfmtasc, esqlc, 6-69

intoasc, esqlc, 6-73

intofmtasc, esqlc, 6-75

invdivdbl, esqlc, 6-78

invdivinv, esqlc, 6-81

invextend, esqlc, 6-83

invmuldbl, esqlc, 6-86

ldchar, esqlc, 3-31

rdatestr, esqlc, 6-7

rdayofweek, esqlc, 6-8

rdefmtdate, esqlc, 6-12

rdownshift, esqlc, 3-33

rfmtdate, esqlc, 6-15

rfmtdec, esqlc, 5-38

rfmtdouble, esqlc, 5-42

rfmtlong, esqlc, 5-45

rgetlmsg, esqlc, 11-49

rgetmsg, esqlc, 11-52

risnull, esqlc, 2-25

rjulmdy, esqlc, 6-17

rleapyear, esqlc, 6-19

rmdyjul, esqlc, 6-22

rsetnull, esqlc, 2-27

rstod, esqlc, 3-34

rstoi, esqlc, 3-36

rstol, esqlc, 3-38

rstrdate, esqlc, 6-24

rtoday, esqlc, 6-26

rtypalign, esqlc, 2-31

rtypmsize, esqlc, 2-34

rtypname, esqlc, 2-36

rtypwidth, esqlc, 2-40

rupshift, esqlc, 3-41

See also Program.,

sqgetdbs, esqlc, 12-50

sqldetach, esqlc, 12-58, 12-59

stcat, esqlc, 3-43

stchar, esqlc, 3-45

stcmpr, esqlc, 3-47

stcopy, esqlc, 3-48

stleng, esqlc, 3-51

timeout, esqlc, 12-70

updcd_me, esqlc, 8-17

updcd_nf, esqlc, 8-28

updcd_of, esqlc, 8-23

varchar, esqlc, 3-7

WDEMO, esqlc, 1-97

Sample-code conventions, sqlr, Intro-13, sqls, Intro-18, sqlt, Intro-11, gls, Intro-11

sapi.lib library file, dbdkug, 5-39

save sets, dapi, 8-3 to

creating, dapi, 12-433

getting final element, dapi, 12-438

getting first row, dapi, 12-437

SB_SPACE_NAME environment,

CREATE TABLE with, sqls, 1-251

sbspace, sqlr, 2-17, sqlt, 9-26

defaults, overriding with extent, sqlt, 9-29

definition of, sqlr, Glossary-16, dapi, 3-7

meta-data area, dapi, 3-7, 3-8, 3-12, 3-14

name of, dapi, 3-48

status information, dapi, 3-13

storage characteristics for, dapi, 3-43

user-data area, dapi, 3-7, 3-12

Sbspace, dbdkug, C-1, 2-8

definition of, esqlc, 7-9

getting name of, esqlc, 7-71, dapi, 12-326

on optical disc, esqlc, 7-32

running out of space, esqlc, 7-96, 7-99, dapi, 12-370, 12-368

setting, esqlc, 7-80, dapi, 12-336

storage characteristics for, esqlc, 7-13

SBSPACENAME configuration parameter, esqlc, 7-13, dapi, 3-41, 3-44

sbspaces,

size and location, sqlr, 1-18

-Sc processor option, esqlc, 1-94, 1-86

SCALE descriptor field, esqlc, 16-6, 15-8

SCALE field,

with DESCRIBE, sqls, 1-342

with SET DESCRIPTOR, sqls, 1-710

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

Schema, sqlr, Glossary-16

Schema. See Data model.,

Scope, sqlr, Glossary-16

Scope of,

cursor names, esqlc, 13-24, 1-65

host variables, esqlc, 1-29

preprocessor definitions, esqlc, 1-14

statement identifiers, esqlc, 13-22, 1-65

scripts directory,

contents, dbdkug, 3-51

Scroll cursor, sqls, 1-317, esqlc, 14-15

active set, sqls, 1-416, 1-317, sqlt, 5-26

definition of, sqlr, Glossary-16

FETCH with, sqls, 1-415

position options, sqls, 1-415

SE database server. See INFORMIX-SE database server.,

secheck utility, gls, 6-9

Second normal form, sqlt, 8-33

secondary access method,

R-tree, sqls, 1-151

Secondary access method, sqlr, Glossary-17

B-tree, sqls, 1-151

CREATE INDEX... USING, sqls, 1-151

default operator class, sqls, 1-179

defined by server, extend, 4-4

defining new operator classes, extend, 4-24

definition, sqls, 1-175, 1-138

definition of, sqlr, Glossary-17, extend, 4-4

documentation of, overview, A-8

example of, overview, B-5

See Access method, secondary; Index.,

specifying with CREATE OPCLASS, sqls, 1-175

user-defined, extend, 4-6

Secondary access methods, dbdkug, 2-20

Security,

database-level privileges, sqlt, 11-4

making database inaccessible, sqlt, 11-4

restricting access to rows, sqlt, 11-25

See alsoPrivilege.,

table-level privileges, sqlt, 11-10

with routines, sqlt, 11-3

See also SERIAL data type,

inserting values, sqls, 1-503

value range, sqls, 1-867

See also SERIAL8 data type,

inserting values, sqls, 1-503

length, sqls, 1-867

resetting values, sqls, 1-79

value range, sqls, 1-867

with routines, sqls, 2-11

See also SQLCODE variable.,

sqlerrd array. See sqlca.sqlerrd array.,

sqlerrm, esqlc, 11-29, 11-49, 11-38

sqlerrp, esqlc, 11-29

sqlwarn structure. See sqlca.sqlwarn structure.,

using the WHENEVER statement, esqlc, 11-45

warning values, esqlc, 11-37

See Locating a simple large object.,

null values, esqlc, 8-9

on optical disc, esqlc, 8-40

programming with, esqlc, 8-5

See also BYTE data type; TEXT data type.,

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

subscripting, esqlc, 8-6

Segment, sqls, 1-826

Literal INTERVAL, sqls, 1-999

Select cursor, sqls, 1-308

closing, sqls, 1-94

default mode, sqls, 1-309

definition of, sqlr, Glossary-17, esqlc, 14-16

fetch buffer, esqlc, 14-20

for collection variable, esqlc, 9-27

opening, sqls, 1-530, 1-537, sqlt, 5-21

reopening, sqls, 1-537

statements that manage, esqlc, 14-15

use of, sqlt, 5-21

using, esqlc, 14-45

Select cursor. SeeCursor,select.,

Select list, sqlt, 2-17

explicit, sqlt, 2-12

implicit, sqlt, 2-13

labels in, sqlt, 3-43

substring notation, sqlt, 2-26

Select privilege,

column level, sqlt, 11-10

definition of, sqlt, 11-8

SELECT statement, sqls, 1-596 to , sqlt, 2-10 to

* (asterisk) with, sqlt, 2-11

active set, sqlt, 2-28

aggregate function with, sqls, 1-603

alias names, sqlt, 2-74

alias with, sqlt, 2-74

ALL keyword, sqls, 1-601

and collation order, gls, 1-9

and NOT FOUND condition, esqlc, 11-20, 11-35

associated with a cursor, esqlc, 14-14, 16-4, 17-4

BETWEEN condition, sqls, 1-622

checking for truncation, esqlc, 11-31

collation of character data, gls, 3-20, 3-21

Collection Derived Table clause, esqlc, 9-64, 9-24

collection derived table with, sqls, 1-833

collection variables with, sqls, 1-833

collection with, sqls, 1-613

column expression in, sqls, 1-602

column list,

display label, sqlt, 2-48

column numbers, sqls, 1-638

compound query, sqlt, 3-39

constant expression in, sqls, 1-602

correlated subquery, sqlt, 3-29

cursor for, sqls, 1-640, 1-639, sqlt, 5-21

defined statement constant, esqlc, 15-17

deriving data from expressions, sqlt, 2-45

DESCRIBE with, sqls, 1-341

description of advanced, sqlt, 3-4 to

determining estimated cost of, esqlc, 11-30

determining rowid, esqlc, 11-30, 11-35

display label, sqlt, 2-48

DISTINCT keyword, sqls, 1-601, sqlt, 2-51, extend, 6-22, 5-24

embedded, sqlt, 5-14, gls, 3-50

end of data indicator, sqlt, 6-14

executing a singleton SELECT, esqlc, 14-43

expressions in select list, sqls, 1-601

failing to access rows, esqlc, 11-29

fetching CHAR data, esqlc, 3-18, 3-11

fetching collection data, esqlc, 9-41, 9-24, 9-37, 9-16

fetching DATETIME data, esqlc, 6-33

fetching INTERVAL data, esqlc, 6-34

fetching opaque-type data, esqlc, 10-30, 10-23, 10-14

fetching row-type data, esqlc, 9-73, 9-62, 9-64

fetching smart large-object data, esqlc, 7-22

fetching smart-large-object data, dapi, 3-61

fetching VARCHAR data, esqlc, 3-13

FOR READ ONLY clause, sqls, 1-640

FOR UPDATE clause, sqls, 1-639

FROM Clause, sqls, 1-610

function expression in, sqls, 1-603

functions in, sqlt, 2-50 to

GROUP BY clause, sqls, 1-630, sqlt, 3-4, extend, 5-23

HAVING clause, sqls, 1-632, sqlt, 3-9

identifying variable mismatch, esqlc, 11-31, 11-23, 11-15

in ANSI-compliant database, esqlc, 3-18

IN condition, sqls, 1-622

indicator variables with, sqls, 1-401, 1-607

INSERT with, sqls, 1-507, sqlt, 4-10

interrupting, esqlc, 12-52, 12-34

INTO clause, sqls, 1-417, 1-605

array variable with, sqls, 1-608

INTO clause restrictions, sqls, 1-544

INTO host_var clause, esqlc, 11-31, 14-6

INTO TEMP clause, sqls, 1-642, esqlc, 11-21, 11-36, sqlt, 2-76

IS NULL condition, sqls, 1-623

join, sqlt, 2-67 to

joining tables in WHERE clause, sqls, 1-627

known at compile time, esqlc, 14-43

LIKE keyword, gls, 3-30

LIKE or MATCHES condition, sqls, 1-623

MATCHES relational operator, gls, 3-28

multiple-table, sqlt, 2-66

nonparameterized, esqlc, 14-43, 16-13, 15-24, 17-17

not known at compile time, esqlc, 15-24, 15-26

ORDER BY clause, sqls, 1-634, sqlt, 2-12, gls, 3-21, 1-9, extend, 6-22, 5-24

ascending/descending order, sqls, 1-637

column number with, sqls, 1-638

display label with, sqlt, 2-50

null values in, sqls, 1-637

sorting rows, sqlt, 2-12

UNION operator, sqls, 1-645

outer join, sqlt, 3-20 to

parameterized, esqlc, 17-41, 17-32, 16-43, 14-52, 14-54, 16-36, 15-26

privilege for, sqlt, 11-5, 11-8

privilege for See Privilege, table-level.,

relational-operator condition, sqls, 1-621

restrictions in routine, sqls, 1-1044

routine argument as, sqls, 1-831

row type, sqls, 1-604

row type with, sqls, 1-617

rowid, sqlt, 3-20, 3-15

rowid,

example, sqls, 1-890

search criteria, sqlt, 2-28

See also Cursor (database); Fetching.,

SELECT clause, sqls, 1-598

select numbers, sqls, 1-638

select-list columns, gls, 8-14

singleton, sqls, 1-606, esqlc, 16-12, 14-43, 14-10, 16-4, 17-4, 14-16, sqlt, 2-28

smart large object, dapi, 3-17, 3-61

smart large objects with, sqls, 1-890

specifying literal matches, gls, 3-28, 3-31

specifying matches with a range, gls, 3-29

specifying quoted strings, gls, 3-33

SPL function in, sqls, 1-603

SPL routines in, sqlt, 2-64

SQLCODE, SQLSTATE with, sqlt, 6-14

subquery, sqlt, 3-29 to

subquery (inner SELECT), sqlt, 3-29

subquery in WHERE clause, sqls, 1-621

UNION keyword, extend, 6-22, 5-24

UNION operator, sqls, 1-644, sqlt, 3-39

UNIQUE keyword, sqls, 1-601, extend, 6-22, 5-24

using length functions, gls, 3-40

using TRIM, gls, 3-40, 8-16

view with, sqlt, 11-29

WHERE clause, sqlt, 2-27 to , gls, 1-9, 3-24

WHILE or FOR loop with, sqls, 1-983

with aggregate functions, esqlc, 11-31

with DESCRIBE, esqlc, 17-8, 15-16, 16-6, 17-7

with sqlda structure, esqlc, 17-32, 17-17

with system-descriptor area, esqlc, 17-41, 16-43, 16-13, 16-36

with,

FOREACH, sqls, 2-27

LET, sqls, 2-40

writing rows retrieved to an ASCII file, sqls, 1-769

Selection, sqlr, Glossary-17, sqlt, 2-6, 1-13

Selectivity, sqlr, Glossary-17

Selectivity routine, dbdkug, 3-30

Self-referencing query, sqlt, 3-11

SELFUNC routine modifier, sqls, 1-1030

selog utility, gls, 6-9

Semantic integrity, sqlt, 4-19, 4-20, 9-3

Send routine, dbdkug, 6-17

Send support function, sqls, 1-172

as casting function, extend, 5-17

description of, extend, 6-13, 5-6

locale-sensitive data, extend, 6-25

parameter type, extend, 5-16

return type, extend, 5-16

summary of, extend, 6-4

SENDRECV data type,

casting from, extend, 5-17

casting to, extend, 5-17

definition of, extend, 6-11

locale-sensitive data, extend, 6-25

parameter in receive function, extend, 5-16

return value in send function, extend, 5-16

Sequential cursor, esqlc, 9-21, 9-27, 14-15, 14-18, sqlt, 5-23

active set, sqls, 1-414, sqlt, 5-25

DECLARE with, sqls, 1-316

definition of, sqlr, Glossary-17

FETCH with, sqls, 1-414

with FETCH, sqls, 1-414

Sequential cursor. SeeCursor, sequential.,

Sequential integers,

with SERIAL data type, sqlr, 2-59

with SERIAL8 data type, sqlr, 2-61

SERIAL data type, sqlr, 2-59, sqlt, 9-10

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

data conversion, esqlc, 2-19

defined constant, esqlc, 2-8

,

generated number in SQLERRD, sqlt, 5-10

initializing value, sqlt, 9-10

inserting values, sqlr, 2-60

length (syscolumns), sqlr, 1-27

obtaining value after INSERT, esqlc, 11-29

resetting values, sqlr, 2-60

See also int data type.,

starting value, sqlt, 4-9

syscolumns coltype code for, sqlr, 1-24

using typedefs, esqlc, 1-38

SERIAL8 data type, sqlr, 2-61, sqlt, 9-10

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

declaring host variable for, esqlc, 5-7

defined constant, esqlc, 2-9

,

ifx_getserial8(), esqlc, 5-10

initializing value, sqlt, 9-10

inserting values, sqlr, 2-62

length (syscolumns), sqlr, 1-27

resetting values, sqlr, 2-62

See also int8 data type.,

syscolumns coltype code for, sqlr, 1-24

Serializable, sqlr, Glossary-17

Serializable isolation level,

with SET TRANSACTION, sqls, 1-745

Serializable isolation level (ANSI), sqlt, 7-16

with SET TRANSACTION, sqls, 1-743

Server,

name, sqlr, Glossary-17

number, sqlr, Glossary-17

See also Database server.,

server,

connection to, dapi, 11-3

Server code set, gls, 4-6, 1-41, 6-5, 5-6, 7-5, 1-47

Server computer,

server code set, gls, 1-41

setting DB_LOCALE, gls, 1-28

setting SERVER_LOCALE, gls, 1-28

server connection, dapi, 5-4

server exception, dapi, 9-10

server functions,

developing, dapi, 11-3

memory management, dapi, 11-4

transactions and, dapi, 11-4

Server locale, gls_api, 1-19, 1-10, 1-11

code set. See Server code set.,

definition of, gls, 1-27

INFORMIX-Universal Server filenames, gls, 4-4

OnLine filenames, gls, 5-4

sample, gls, 1-27, 1-23, 1-35

SE filenames, gls, 6-5

See also SERVER_LOCALE environment variable.,

server code set, gls, 1-41

setting, gls, 1-28

uses of, gls, 4-3, 5-3, 6-3

Server projects, dbdkug, 6-5, 6-19

generated files, dbdkug, B-5

UNIX, dbdkug, 6-20

Windows NT, dbdkug, 6-21

Server-processing locale, gls_api, 1-19, 1-10, 1-11

COLLATION category, gls, 1-38

CTYPE category, gls, 1-38

date data, gls, 1-39

definition of, gls, 1-34

determining, gls, 1-34

filename checking, gls, 4-7, 6-6, 5-7

initialization of, gls, 1-34

localized order, gls, 1-36

MESSAGES category, gls, 1-40

MONETARY category, gls, 1-40

monetary data, gls, 1-39

NUMERIC category, gls, 1-40

numeric data, gls, 1-39

precedence of environment variables, gls, 1-37, 1-39

sample, gls, 1-35

TIME category, gls, 1-40

time data, gls, 1-39

server_info Information Schema view, sqlr, 1-70

SERVER_LOCALE environment variable, gls_api, 1-11, extend, 6-24

default value, gls, 1-28

INFORMIX-Universal Server filenames, gls, 4-4

location of message files, gls, 2-16

OnLine filenames, gls, 5-4

precedence of, gls, 2-16

role in code-set conversion, gls, 1-47

SE filenames, gls, 6-4

See also Server locale.,

server code set, gls, 1-41

setting, gls, 1-28

syntax, gls, 2-41

SERVERNUM,

default value of, dapi, 5-9

description, dapi, 5-9

SERVICE network parameter, esqlc, 1-108, 12-15

Session, sqlr, Glossary-17

Session control block,

accessed by DBINFO function, sqls, 1-915

contents of, sqls, 1-915

Session ID,

obtaining with DBINFO(), sqls, 1-915

SessionID,

returned by DBINFO function, sqls, 1-915

SET, sqlt, 10-16

SET AUTOFREE (SQL) statement, esqlc, 14-25

setting, esqlc, 14-26

SET AUTOFREE statement, esqlc, 14-25, 14-26

1-676 to 1-684, sqls, 1-676 to

cursor-AUTOFREE mode, sqls, 1-683, 1-680

DISABLED option, sqls, 1-682

ENABLED option, sqls, 1-677

global-AUTOFREE mode, sqls, 1-682, 1-678

IFX_AUTOFREE environment variable with, sqls, 1-683

with IFX_AUTOFREE environment variable, sqls, 1-700

SET BUFFERED LOG statement, sqls, 1-731

set confirm command, bldmg_ug, 3-17

SET CONNECTION statement, sqls, 1-685 to , esqlc, 12-93, 12-100

and explicit connections, esqlc, 12-18

CURRENT keyword, sqls, 1-690

DEFAULT option, sqls, 1-689

determining database server features, esqlc, 12-27

making connection dormant, esqlc, 13-21, 13-23, 13-18

managing connections across threads, esqlc, 13-20

switching to a dormant connection, esqlc, 12-29, 13-18

with an active transaction, esqlc, 12-30

SET CONSTRAINT statement,

trigger activated, sqls, 1-282

SET data type, sqlr, 2-62, Glossary-17

accessing, esqlc, 9-4

after a DESCRIBE, esqlc, 17-8

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

declaring host variable for, esqlc, 9-6

defined constant, esqlc, 2-9

definition of, esqlc, 9-4

deleting elements, sqls, 1-332

deleting elements from, sqls, 1-333, 1-329

inserting many elements into, esqlc, 9-20

See also Collection data type (SQL).,

selecting one element from, sqls, 1-614

syscolumns coltype code for, sqlr, 1-24

unloading, sqls, 1-770

updating elements, sqls, 1-791, 1-797, 1-798

updating elements in, sqls, 1-803

SET DATASKIP statement,

restrictions, sqls, 1-693

syntax, sqls, 1-692

SET DEBUG FILE TO statement,

syntax and use, sqls, 1-695

with TRACE, sqls, 2-57

SET DEFERRED PREPARE statement, esqlc, 14-32

SET DEFERRED_PREPARE statement, sqls, 1-698 to

DISABLED option, sqls, 1-700

ENABLED option, sqls, 1-699

SET DESCRIPTOR statement, sqls, 1-702 to

COUNT keyword, sqls, 1-705

IDATA field, sqls, 1-438

PUT with, sqls, 1-561

See also System-descriptor area.,

setting COUNT field, esqlc, 16-9, 16-36

setting fields, esqlc, 16-9, 16-36, 16-4

VALUE clause, sqls, 1-706

VALUE keyword, esqlc, 16-36

X/Open mode, sqls, 1-708

Set difference, sqlt, 3-47

SET EXPLAIN statement, sqls, 1-714 to , gls, 1-27

DYNAMIC HASH JOIN information, sqls, 1-716

examples, sqls, 1-717

interpreting output, sqls, 1-715

MERGE JOIN information, sqls, 1-716

optimizer access paths, sqls, 1-715

SORT SCAN information, sqls, 1-716

with fragmentation, sqls, 1-719

with PDQ, sqls, 1-719

with SET OPTIMIZATION, sqls, 1-721

with table inheritance, sqls, 1-721

Set intersection, sqlt, 3-46

SET ISOLATION statement, sqls, 1-722 to

controlling the effect of locks, sqlt, 4-32

default database levels, sqls, 1-725

definition of isolation levels, sqls, 1-724

discussed, sqlt, 7-11

effects of isolation, sqls, 1-726

similarities to SET TRANSACTION statement, sqls, 1-743, sqlt, 7-12

SET keyword,

use in UPDATE, sqls, 1-786

SET LOCK MODE statement, sqls, 1-728 to

controlling the effect of locks, sqlt, 4-32

description of, sqlt, 7-18

kernel locking, sqls, 1-729

ON EXCEPTION statement with, sqls, 1-984

setting wait period, sqls, 1-729

SET LOG statement, sqls, 1-731

buffered vs. unbuffered, sqlt, 9-40

SET OPTIMIZATION statement, sqls, 1-733

HIGH keyword, sqls, 1-733

LOW keyword, sqls, 1-733

with SET EXPLAIN, sqls, 1-721

SET PDQPRIORITY statement, sqls, 1-735

SET ROLE statement, sqls, 1-738

SET SESSION AUTHORIZATION statement, sqls, 1-740

SET statement, sqls, 1-648 to

diagnostics tables with, sqls, 1-653

error options, sqls, 1-652

ON EXCEPTION statement with, sqls, 1-984

privileges required for executing, sqls, 1-649

relationship to START VIOLATIONS TABLE, sqls, 1-750

transaction mode format, sqls, 1-672

trigger object modes, sqls, 1-287

violations tables with, sqls, 1-653

SET TRANSACTION statement,

access mode, sqlt, 7-17

default database levels, sqls, 1-746

definition of isolation levels, sqls, 1-745

effects of isolation, sqls, 1-747

similarities to SET ISOLATION statement, sqls, 1-743, sqlt, 7-12

syntax, sqls, 1-742

SET type constructor, overview, 1-18

set user command, bldmg_ug, 3-18

SET, type constructor, dbdkug, 3-32

SetClean method, dbdkug, 6-26

SetConnect() library function, esqlc, 12-93, 12-100

SetData method, dbdkug, 6-26

SetDataC method, dbdkug, 7-6

SetDataCpp method, dbdkug, 7-6

SetDirty method, dbdkug, 6-26

SetFieldDelimiters method, dbdkug, 6-31

setjmp() system call, esqlc, 12-36

Setnet32 utility,

description, esqlc, 1-6

determining default database server, esqlc, 12-95

use of ixreg.dll, esqlc, 1-89

SetNotNull method, dbdkug, 6-26

SetNull method, dbdkug, 7-7

SetNullFlag method, dbdkug, 7-10, 6-19

SetStringDelimiters method, dbdkug, 6-31, 6-32

Setting environment variables, sqlr, 3-8

Setup program for DataBlade modules on Windows NT, bldmg_ug, 1-6

SHARE keyword, syntax in LOCK TABLE, sqls, 1-525

Shared class libraries, sqlt, 1-10

Shared library, sqlr, Glossary-17, sqls, 1-922

creating for dynamic thread functions, esqlc, 13-50

Shared lock,

SeeLock,

Shared memory, sqlr, Glossary-17

about, overview, 1-10

client (INFORMIXSHMBASE), sqlr, 3-50

documentation of, overview, A-8

parameter file (ONCONFIG), sqlr, 3-57

Shared memory, used by virtual processors, dbdkug, 4-6

Shared object file,

loading into server address space, udr, 4-9

Shared object files,

compiling, dbdkug, 5-38

compiling with debugging support, dbdkug, 5-39

loading into server address space, dbdkug, 8-15

ownership of, dbdkug, 8-5

path, designating in BladeSmith, dbdkug, 3-24

permissions on, dbdkug, 8-5

replacing, dbdkug, 8-5

unresolved symbols in, dbdkug, 8-5

using, dbdkug, 8-4

shared.,

Shell,

file for environment variables, sqlr, 3-8

remote (DBREMOTECMD), sqlr, 3-35

remote, overriding (DBREMOTECMD), sqlr, 3-35

search path (PATH), sqlr, 3-58

short int data type,

corresponding SQL data type, esqlc, 5-4, 2-12

data conversion, esqlc, 2-20

defined constant, esqlc, 2-10

See also SMALLINT data type; int data type.,

show client command, bldmg_ug, 3-18

show log command, bldmg_ug, 3-18

show modules command, bldmg_ug, 3-19

show servers command, bldmg_ug, 3-19

Side-effect index, sqls, 1-178

Signal handling,

of ESQL/C library, esqlc, 12-66

of SIGINT, esqlc, 12-35

signal() system call, esqlc, 12-36

Signal-handler function, esqlc, 12-35, 12-36

Signals,

SIGCHLD, esqlc, 12-67

SIGINT, esqlc, 12-35

Signature,

components of, udr, 2-4

Signature. See Routine signature.,

Simple assignment, sqls, 2-40

Simple large object, sqlr, 2-19, Glossary-18, sqls, 1-870, sqlt, 9-30 to , 9-24

blobspace storage for, sqlt, 9-32

cluster key, sqlr, Glossary-3

inserting, sqls, 1-502

length (syscolumns), sqlr, 1-29

loading, sqls, 1-521, 1-518

location, sqlr, 1-18

See also BYTE data type; Large object ; TEXT data type.,

SQL interactively with, sqlt, 9-32

SQL restrictions, sqlt, 9-32

syntax, sqls, 1-869

sysblobs information, sqlr, 1-18

Simple large objects, and a fetch array, esqlc, 15-34

Simple large-object data type,

unloading, sqls, 1-771, 1-773

Simple predicate, sqlr, Glossary-18

Simple-large-object data type,

compared with smart large objects, esqlc, 8-4

declaring host variable for, esqlc, 8-5

definition of, esqlc, 8-3

format on disk, esqlc, 8-40

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

locating,

Simple-large-object descriptor, esqlc, 8-40

SIN function, sqls, 1-937, 1-938

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

Single inheritance, sqlt, 10-20

Single quotes (' '),

delimiting strings, esqlc, 1-32

escaping, esqlc, 1-19

in a literal collection, esqlc, 9-43

in a literal row, esqlc, 9-76

in a prepared statement string, esqlc, 14-5

in a quoted string, esqlc, 1-20

Single-byte character, gls, 1-4, 1-8, Intro-12, 3-35, 3-38

description of, gls_api, 2-4

forward traversal of, gls_api, 2-29, 4-164

in code-set conversion, gls_api, 4-51

representation of, gls_api, Intro-9

reverse traversal of, gls_api, 4-172

Single-threaded application, sqls, 1-687

Singleton SELECT statement, sqls, 1-606, sqlt, 2-28

definition of, sqlr, Glossary-18

SITENAME function, sqls, 1-895

CREATE TABLE with, sqls, 1-223

example, sqlt, 3-19

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

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

Skip backwards operator, dbdkug, 6-29

Skip method, dbdkug, 6-31

Skip operator, dbdkug, 6-29

SkipBlanks method, dbdkug, 6-31

SkipDelimiters method, dbdkug, 6-31

.sl file extension, esqlc, 13-13

SLV,

referencing return values with, udr, 3-16

SMALLFLOAT data type, sqlr, 2-64, sqls, 1-868, sqlt, 9-11, gls, A-7, 1-14

casts for, sqlr, 2-27

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

data conversion, esqlc, 2-19, 2-20, 2-21

defined constant, esqlc, 2-8

number of decimal digits, esqlc, 2-18, 5-6

See also float data type.,

See Numeric data.,

syscolumns coltype code for, sqlr, 1-24

unloading, sqls, 1-771

SMALLINT data type, sqlr, 2-64, sqlt, 9-9, gls, A-7, 1-14

casts for, sqlr, 2-27, 2-28

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

creating a typedef for, esqlc, 1-38

data conversion, esqlc, 2-19, 2-20, 2-21

defined constant, esqlc, 15-21, 2-8, 2-9

length (syscolumns), sqlr, 1-27

See also short int data type.,

See Numeric data.,

syscolumns coltype code for, sqlr, 1-24

unloading, sqls, 1-771

smallint values,

copying, dapi, 12-406

Smart large object, sqlr, 2-17, Glossary-18, sqls, 1-870, sqlt, 9-25 to , 9-24

access flags, dapi, 3-66

access-mode flags, dapi, 3-64

accessing, dapi, 3-17, 3-60, 7-12

altering, dapi, 3-73

attributes, dapi, 3-11, 3-48

attributes in syscolattribs, sqlr, 1-20

buffering-mode flags, dapi, 3-67

closing, dapi, 3-70

column data,

accessing, sqls, 1-891

column defaults inherited, sqlt, 9-29

copying to a file, sqls, 1-928

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

creating, dapi, 3-32

creating from a file, sqls, 1-923, 1-924, 1-926

data structures, dapi, 2-6, 3-20

definition of, dapi, 3-5

estimated size, dapi, 3-41, 3-47

expressions with, sqls, 1-890

extent size, sqlt, 9-29, dapi, 3-41, 3-10, 3-48

fetching, dapi, 3-61

FILETOBLOB function, sqls, 1-926

FILETOCLOB function, sqls, 1-926

functions for copying, sqls, 1-925, sqlt, 9-27

generating filename for, sqls, 1-929

handle values, sqls, 1-890

importing and exporting, sqlt, 9-27

in opaque data type, dapi, 3-16

in opaque type, extend, 5-5, 6-15

information about, dapi, 3-8

inserting, dapi, 3-18, 3-55

interfaces for, dapi, 3-17, 2-6

last-access time, dapi, 3-78, 3-13, 3-49

last-change time, dapi, 3-78, 3-14

last-modification time, dapi, 3-78, 3-14

LO file descriptor, dapi, 3-75, 3-53, 3-20, 3-22

LO handle, dapi, 3-51, 3-20, 3-21, 3-8

LO-specification structure, dapi, 3-20, 3-21, 3-33

LO-status structure, dapi, 3-20, 3-76, 3-23

locking, dapi, 3-68, 3-69

LOCOPY function, sqls, 1-930

logging of, dapi, 3-11, 3-49

LOTOFILE function, sqls, 1-928

maximum I/O block size, dapi, 3-41

maximum size, dapi, 3-47

meta data, dapi, 3-12, 3-13, 3-14

minimum extent size, dapi, 3-41

modifying, dapi, 3-72

modifying characteristics, sqls, 1-78

next-extent size, dapi, 3-41, 3-10

obtaining status of, dapi, 3-74

open mode, dapi, 3-63, 3-22

opening, dapi, 3-63

optimizer, dapi, 3-9

permanent, dapi, 3-81, 3-82, 12-310

reading from, dapi, 3-69

reference count, dapi, 3-78, 3-14

sample program, dapi, 3-71, 3-57

sbspace, dapi, 3-7

sbspace name, dapi, 3-41, 3-10, 3-48

sbspace storage for, sqlt, 9-26

See also BLOB data type; CLOB data type; Large object.,

selecting, dapi, 3-17, 3-61

size of, dapi, 3-41, 3-10, 3-78, 3-14

SQL interactive uses, sqlt, 9-27

SQL restrictions, sqlt, 9-26

status information, dapi, 3-13

storage characteristics, dapi, 3-21, 3-8, 3-37

storing, dapi, 3-18, 3-55

syntax, sqls, 1-869

temporary, dapi, 3-82, 3-55, 3-56

transactions with, dapi, 3-11

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

user data, dapi, 3-13, 3-14

writing to, dapi, 3-53

Smart large object, permanent, esqlc, 7-59

Smart large objects,

accessing, overview, B-3

defined, overview, B-3

Smart large objects. See Large objects.,

Smart large-object,

loading values, sqls, 1-521, 1-518

Smart large-object data type,

access time, sqls, 1-252

allocation extent size, dapi, 12-330, 12-320

altering, dapi, 12-262

attributes flag, dapi, 12-332

closing, dapi, 12-264

comparing, dapi, 12-302

copying, dapi, 12-271

copying to storage manager, dapi, 12-215, 12-218

create-time flags, dapi, 12-322

creating, dapi, 12-220

decrementing reference count, dapi, 12-277

determining storage characteristics of, dapi, 12-272, 12-275, 12-280

estimated size, dapi, 12-328, 12-318

extent size, sqls, 1-251

getting size of, dapi, 12-352

hexadecimal identifier for, dapi, 12-359

last-access time, dapi, 12-340

last-change time, dapi, 12-344

last-modification time, dapi, 12-348

locking, dapi, 12-264

logging, sqls, 1-251

maximum size, dapi, 12-334, 12-324

obtaining status of, dapi, 12-338

opening, dapi, 12-271, 12-272, 12-275, 12-287, 12-300, 12-280

reading from, dapi, 12-304, 12-306

reference count, dapi, 12-350

sbspace, dapi, 12-336, 12-326

specifying the pathname of, dapi, 12-250, 12-228

temporary smart large objects, dapi, 12-309

truncating, dapi, 12-363

unloading, sqls, 1-771, 1-773

writing to, dapi, 12-367, 12-369

Smart-large-object data type,

access modes, esqlc, 7-23

accessing, esqlc, 7-22

advantages, esqlc, 8-4

allocation extent size, esqlc, 7-75, 7-66

altering, esqlc, 7-36

closing, esqlc, 7-38, 7-29

compared with simple large objects, esqlc, 8-4

copying from user-defined buffer, esqlc, 7-52

copying to a file, esqlc, 7-41

copying to a user-defined buffer, esqlc, 7-93

create-time flags, esqlc, 7-77, 7-67

creating, esqlc, 7-21, 7-46

declaring host variable for, esqlc, 7-7

definition of, esqlc, 9-3, 7-5, dapi, 3-16

determining storage characteristics of, esqlc, 7-47

duration of open, esqlc, 7-27

ESQL/C functions for, esqlc, 7-33

estimated size, esqlc, 7-73, 7-64, 7-9

file position, esqlc, 7-92, 7-61

format on disk, esqlc, 7-32

getting size of, esqlc, 7-31, 7-91

hexadecimal identifier for, esqlc, 7-42, 7-16

ifx_lo_alter(), esqlc, 7-36

ifx_lo_close(), esqlc, 7-38

ifx_lo_col_info(), esqlc, 7-39

ifx_lo_copy_to_file(), esqlc, 7-41, 9-45

ifx_lo_copy_to_lo(), esqlc, 7-44

ifx_lo_create(), esqlc, 7-46

ifx_lo_def_create_spec(), esqlc, 7-49

ifx_lo_filename(), esqlc, 7-50

ifx_lo_from_buffer(), esqlc, 7-52

ifx_lo_open(), esqlc, 7-52, 7-53

ifx_lo_read(), esqlc, 7-55

ifx_lo_readwithseek(), esqlc, 7-57

ifx_lo_release(), esqlc, 7-59

ifx_lo_seek(), esqlc, 7-61

ifx_lo_spec_free(), esqlc, 7-63

ifx_lo_specget_estbytes(), esqlc, 7-64

ifx_lo_specget_extsz(), esqlc, 7-66

ifx_lo_specget_flags(), esqlc, 7-67

ifx_lo_specget_maxbytes(), esqlc, 7-69

ifx_lo_specget_sbspace(), esqlc, 7-71

ifx_lo_specset_estbytes(), esqlc, 7-73

ifx_lo_specset_extsz(), esqlc, 7-75

ifx_lo_specset_maxbytes(), esqlc, 7-79

ifx_lo_specset_sbspace(), esqlc, 7-80

ifx_lo_stat(), esqlc, 7-81

ifx_lo_stat_atime(), esqlc, 7-83

ifx_lo_stat_cspec(), esqlc, 7-84

ifx_lo_stat_ctime(), esqlc, 7-86

ifx_lo_stat_free(), esqlc, 7-87

ifx_lo_stat_mtime_sec(), esqlc, 7-88

ifx_lo_stat_refcnt(), esqlc, 7-89

ifx_lo_stat_size(), esqlc, 7-91

ifx_lo_tell(), esqlc, 7-92

ifx_lo_to_buffer(), esqlc, 7-93

ifx_lo_truncate(), esqlc, 7-95

ifx_lo_write(), esqlc, 7-96

ifx_lo_writewithseek(), esqlc, 7-98

inserting, esqlc, 7-17

lightweight I/O, esqlc, 7-25

LO file descriptor, esqlc, 7-20

LO-pointer structure, esqlc, 7-18

LO-specification structure, esqlc, 7-8

LO-status structure, esqlc, 7-30

locking, esqlc, 7-53, 7-47, 7-26, 7-38

locks, esqlc, 7-26

maximum size, esqlc, 7-79, 7-69, 7-9

modifying, esqlc, 7-28

obtaining status of, esqlc, 7-81, 7-29

on optical disc, esqlc, 7-32

opening, esqlc, 7-53, 7-23, 7-47

programming with, esqlc, 7-6

reading from, esqlc, 7-55, 7-57, 7-28

reference count, esqlc, 7-31, 7-89

sample program, esqlc, 7-100

sbspace, esqlc, 7-71, 7-80

See also BLOB data type; CLOB data type; ifx_lo_t data type.,

selecting, esqlc, 7-22

storage characteristics, esqlc, 7-12, 7-8

storing, esqlc, 7-17

temporary smart large objects, esqlc, 7-59

temporary, releasing resources, esqlc, 7-59

time of last access, esqlc, 7-83, 7-31

time of last change in status, esqlc, 7-86, 7-31

time of last modification, esqlc, 7-31, 7-88

truncating, esqlc, 7-95

updating, esqlc, 7-17

writing to, esqlc, 7-96, 7-98, 7-29

Smart-large-object optimizer, dapi, 3-9

SMI.SeeSystem Monitoring Interface.,

.so file extension, esqlc, 13-13, 13-8

Software dependencies, sqlr, Intro-5, sqls, Intro-5, esqlc, Intro-4, sqlt, Intro-6, gls_api, Intro-4, dapi, Intro-5, gls, Intro-5, extend, Intro-4, udr, Intro-4

Software requirements, dbdkug, Intro-5, overview, Intro-5, bldmg_ug, Intro-4

Sort order. See Collation order.,

Sort order. See Collation.,

Sorting, dbdkug, 2-16

column by number in SELECT, sqlt, 2-23

in SELECT, sqls, 1-634

nested, sqlt, 2-14

non-English data, sqlt, 2-24

parallel process performance (PSORT_NPROCS), sqlr, 3-61

temporary dbspace for (DBSPACETEMP), sqlr, 3-36

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

threads for (PSORT_NPROCS), sqlr, 3-61

with ORDER BY, sqlt, 2-13

Sorting rows, sqlt, 2-12

Source code,

compiling, overview, 2-7

editing, overview, 2-7

files for a DataBlade module, overview, 2-4

Source code files. See Files.,

Source file, sqlr, Glossary-18

Source type, for distinct data type, dbdkug, 3-33

source.ec file, argument to preprocessor, esqlc, 1-50

source.ecp file, argument to the preprocessor, esqlc, 1-50

SOURCEID descriptor field, esqlc, 15-32, 15-9

SOURCEID field,

with GET DESCRIPTOR, sqls, 1-439

with SET DESCRIPTOR, sqls, 1-712

SOURCETYPE descriptor field, esqlc, 15-32, 15-9

SOURCETYPE field,

with GET DESCRIPTOR, sqls, 1-439

with SET DESCRIPTOR, sqls, 1-712

Space ( ),

as delimiter in DATETIME, sqlr, 2-42

as delimiter in INTERVAL, sqlr, 2-50

Space character. See Blank character; White-space character.,

Space class, gls_api, 4-131, 4-107, 2-12, 2-13, 4-28

Spanish locale, gls, 1-30

SPECIFIC keyword, udr, 2-6

Specific name, sqlr, Glossary-18

creating, udr, 2-6

naming conventions, udr, 2-6

syntax, sqls, 1-1039

sysprocedures field, sqlr, 1-46

SPL, sqlr, Glossary-18

program variable, sqlt, 5-6

statements described, sqls, 2-3

SPL function, sqlr, Glossary-18

CREATE FUNCTION, sqls, 1-127

CREATE FUNCTION example, sqls, 1-127

cursor function, esqlc, 14-42

cursors with, sqls, 2-27

definition, esqlc, 14-47

dynamic routine-name specification, sqls, 1-402, sqlt, 14-72

executing, sqls, 1-397, 1-545

executing dynamically, esqlc, 14-50, 16-23, 17-28, 17-29, 16-29

optimization, sqls, 1-127

punctuation for, sqls, 1-127

registering, sqls, 1-127

registering from inside an external routine, sqls, 1-135

See also SPL routine; User-defined function.,

SPL procedure, sqlr, Glossary-18, esqlc, 14-47

creating with CREATE PROCEDURE, sqls, 1-183

dynamic routine-name specification, sqls, 1-410, sqlt, 14-72

executing, sqls, 1-545, 1-407

optimization, sqls, 1-183

registering with CREATE PROCEDURE, sqls, 1-183

See also SPL routine; User-defined procedure.,

TRACE output file, sqls, 1-695

SPL routine, sqlr, Glossary-18, esqlc, 14-47, 12-34

as triggered action, sqlt, 15-11

automating access control, sqlt, 11-19

comments, sqls, 1-1045

compiler warning, sqlt, 14-80

cursor routine, sqlt, 14-30

debugging, sqlt, 14-82

exceptions, sqlt, 14-84 to

executing operating system commands from, sqls, 2-54

finding in system catalog, sqlt, 14-81

FOREACH loop, sqlt, 14-30

listing compiler messages, sqlt, 14-80

loop, controlled, sqls, 2-22

loop,

expression with FOR...IN, sqls, 2-26

multiple ranges for, sqls, 2-25

range and expression with FOR statement, sqls, 2-26

range of FOR..TO, sqls, 2-24

modifying, restrictions on, sqls, 1-371

passing BYTE or TEXT argument to, sqls, 2-18

preparing, sqls, 1-545

SELECT statement with, sqlt, 2-64

syntax error, sqlt, 14-80

tracing triggered actions, sqlt, 15-13

SPL, in user-defined routines, dbdkug, 3-23

SPL. See Stored Procedure Language.,

sprintf() function, dbdkug, 5-25

sqexplain.out file, sqls, 1-714

sqgetdbs() library function, esqlc, 12-49

SQL,

custom statements, dbdkug, 3-52, 3-44, 3-45, 3-46

error handling, sqlt, 5-17

errors, dbdkug, 3-20, 3-21

generating, dbdkug, 3-51

grouping, dbdkug, 2-17

history, sqlt, 1-15

importing custom statements from a file, dbdkug, 3-46

Informix, sqlt, 1-16

keywords, sqls, 1-968

predicate, dbdkug, 2-12, 2-14

privileges, setting, dbdkug, 3-12

sorting rows, dbdkug, 2-16

status codes, dapi, 9-13

Structured Query Language, sqlt, 1-15

target list, dbdkug, 2-11

test scripts, dbdkug, 8-10

transaction semantics, dbdkug, 2-21

user-defined routines in a WHERE clause, dbdkug, 2-12

SQL API, sqlr, Glossary-19

comments with, sqls, 1-12

concatenation operator with, sqls, 1-884

SQL API products,

comments, gls, 7-6

ESQL library enhancements, gls, 7-7

filenames, gls, 7-7

handling non-ASCII characters, gls, 7-3

host variables, gls, 7-6

identifiers, gls, 1-31

literal strings, gls, 7-7

SQL identifier names, gls, 7-6

using GLS8BITFSYS, gls, 7-5, 2-25

SQL command script file, sqls, 1-12

SQL Communications Area (SQLCA),

altered by end of transaction, sqlt, 6-5

checking for WHERE clause, sqls, 1-340

CLOSE results, sqls, 1-94

cursor with, sqls, 1-530

DBANSIWARN with, sqlr, 3-18

description of, sqlt, 5-8

inserting rows, sqls, 1-914, 1-917, sqlt, 6-11

processing rows, sqls, 1-915

result after DATABASE, sqls, 1-296

result after DESCRIBE, sqls, 1-339

result after EXECUTE, sqls, 1-395

result after FETCH, sqls, 1-424

result after FLUSH, sqls, 1-427

result after PUT, sqls, 1-565

result after SELECT, sqls, 1-609

SQLCODE field. See SQLCODE field.,

SQLERRD array. See SQLERRD array.,

SQLWARN array. See SQLWARN array.,

warning when dbspace skipped, sqls, 1-692

warnings in, sqls, 1-822

SQL data type,

BLOB, dapi, 3-15

CLOB, dapi, 3-15

IMPEXP, extend, 6-15

IMPEXPBIN, extend, 6-17

LVARCHAR, extend, 6-6

opaque, dapi, 3-16

SENDRECV, extend, 6-11

SQL data types,

BLOB, esqlc, 2-5, 7-5, 2-11

BOOLEAN, esqlc, 2-5, 2-13

BYTE, esqlc, 2-4, 8-3, 2-11

CHAR, esqlc, 3-3, 2-4, 2-11

CLOB, esqlc, 2-5, 2-13

collections, esqlc, 9-4

DATE, esqlc, 2-4, 6-3, 2-11

DATETIME, esqlc, 2-4, 2-11, 6-28

DECIMAL, esqlc, 2-4, 4-3, 2-12

defined constants for, esqlc, 15-21, 2-8

distinct, esqlc, 15-28

FLOAT, esqlc, 2-4, 5-5, 2-12

INT8, esqlc, 2-5, 5-4, 5-5, 5-7, 2-13

INTEGER, esqlc, 2-4, 5-4, 2-12

INTERVAL, esqlc, 2-4, 2-12, 6-28

LIST, esqlc, 2-5, 9-4, 2-13

LVARCHAR, esqlc, 2-5, 2-12

MONEY, esqlc, 2-4, 2-12

MULTISET, esqlc, 2-4, 9-4, 2-12

named row type, esqlc, 9-48

NCHAR, esqlc, 3-3, 2-4, 2-12

NVARCHAR, esqlc, 3-3, 2-4, 3-4, 3-5, 2-12

opaque, esqlc, 10-3, 2-5, 2-13

row types, esqlc, 2-5, 9-48

See also individual data type names.,

SERIAL, esqlc, 2-4, 5-4, 2-12

SERIAL8, esqlc, 2-5, 5-4, 5-7, 2-13

SET, esqlc, 2-5, 9-4, 2-13

SMALLFLOAT, esqlc, 2-4, 5-5, 2-12

SMALLINT, esqlc, 2-4, 5-4, 2-12

TEXT, esqlc, 2-4, 8-3, 2-12

unnamed row type, esqlc, 9-48, 2-13

VARCHAR, esqlc, 3-3, 2-4, 2-12

X/Open defined constants, esqlc, 2-9

SQL files, included in DataBlade modules, overview, 1-26

SQL identifier, esqlc, 14-51, 1-32

delimited, gls, 3-10

examples, gls, 3-9

multibyte characters, gls, 3-5, 4-17

non-ASCII characters, gls, 1-31, 7-6

owner names, gls, 3-8

rules for, gls, 3-4

See also Delimited identifier.,

SQL keyword protection,

against interpretation by C preprocessor, esqlc, 1-73

relation to the dollar ($) sign, esqlc, 1-73

SQL length function,

CHAR_LENGTH, gls, 3-45

classification of, gls, 3-40

LENGTH, gls, 3-40

OCTET_LENGTH, gls, 3-43

using, gls, 3-40

SQL procedure,

debugging, sqls, 2-57

SQL script, for DataBlade module, overview, 2-4

SQL segments, gls, 3-7

SQL statement,

CLOSE DATABASE, esqlc, 12-99

CONNECT, esqlc, 12-93, 12-12, gls, 3-5

CREATE CAST, gls, 4-17

CREATE DISTINCT TYPE, gls, 4-17

CREATE FUNCTION, gls, 4-17

CREATE INDEX, gls, 3-4, 3-20, 3-6

CREATE OPAQUE TYPE, gls, 4-17

CREATE OPCLASS, gls, 4-18

CREATE PROCEDURE, gls, 4-18, 3-6, 3-7

CREATE ROLE, gls, 3-6

CREATE ROW TYPE, gls, 4-18

CREATE SYNONYM, gls, 3-7

CREATE TABLE. See CREATE TABLE statement.,

CREATE TRIGGER, gls, 3-7

CREATE VIEW, gls, 3-7

data manipulation, gls, 3-49

DATABASE, esqlc, 12-96

DECLARE, gls, 3-5

DELETE. See DELETE statement.,

DESCRIBE, gls, 8-14

diagnostics area, sqls, 1-441

DISCONNECT, esqlc, 12-93, 12-98

end-user formats in, gls, 1-12

FETCH, gls, 3-6

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

INSERT. See INSERT statement.,

LOAD, gls, 3-52, 3-6, 3-49

PREPARE, gls, 3-6

SET CONNECTION, esqlc, 12-93, 12-100

SET EXPLAIN, gls, 1-27

UNLOAD, gls, 3-52, 3-49

UPDATE. See UPDATE statement.,

SQL statement, failures in log files, bldmg_ug, 2-12, 3-14

SQL statements, sqls, 1-14 to

access method, sqls, 1-14

ANSI-compliant, sqls, 1-19

ANSI-compliant with Informix extensions, sqlt, 1-16

case sensitivity, esqlc, 1-18

client/server connection, sqls, 1-15

comment symbol, sqls, 1-12

comments examples, sqls, 1-12

comments in, sqls, 1-11

cursor-management statements, esqlc, 14-15, 14-18

data access, sqls, 1-15

data definition, sqls, 1-16

data integrity, sqls, 1-17

data manipulation, sqls, 1-17

DBANSIWARN environment variable, sqlr, 3-18

defined constants for, esqlc, 11-33, 15-17

dynamic management, sqls, 1-17

dynamic. See Dynamic SQL.,

editor for (DBEDIT), sqlr, 3-31

for dynamic SQL, esqlc, 14-11, 16-4, 14-15, 17-4, 14-18

GET DIAGNOSTICS for, sqls, 1-442

Informix extensions, sqls, 1-19

interruptable, esqlc, 12-34

messages in SQLSTATE variable, sqls, 1-442

not available in routines, sqls, 1-1043

obtaining diagnostic information, esqlc, 11-4

parameterized, esqlc, 14-51

parts of, sqls, 1-8

print program for (DBPRINT), sqlr, 3-34

restrictions on invoking routines, sqls, 1-1044

segments describe shared syntax, sqls, 1-7

static, esqlc, 11-30, 14-3

SQL utilities, gls, 5-10, 4-11, 6-9

SQL, documentation of, overview, A-8

SQL-invoked function,

aggregate functions, extend, 2-10

built-in functions, extend, 2-8

casting functions, extend, 3-9

definition of, extend, 1-16, 2-3

end-user routines, extend, 2-10

opaque data types, extend, 5-19

operator functions, extend, 2-4

SQL3, sqlr, Glossary-19

sql_languages Information Schema view, sqlr, 1-70

sqlauth() authentication function, esqlc, 1-108, 12-14, 1-89

SQLBOOL data-type constant, esqlc, 2-9

See also BOOLEAN data type.,

sqlbreak() library function, esqlc, 12-70, 12-52, 12-34

sqlbreakcallback() library function, esqlc, 12-54, 12-32, 12-37

SQLBYTES data type constant, gls, 8-13

SQLBYTES data-type constant, esqlc, 2-8

See also BYTE data type.,

sqlca structure, esqlc, 1-116

and DESCRIBE, esqlc, 15-23

and PREPARE, esqlc, 14-9

checking for exceptions, esqlc, 11-27

definition of, esqlc, 11-28

determining database server features, esqlc, 11-30, 11-37, 12-28

in thread-safe code, esqlc, 13-27, 13-17

indicating truncation, esqlc, 2-16, 1-44

relation to SQLCODE status variable, esqlc, 11-32

retrieving error message text, esqlc, 11-47

sqlcode, esqlc, 11-29

sqlerrm, gls, 1-48, 4-8

sqlwarn.sqlwarn7, gls, 7-25

SQLCA structure,

connection warnings, gls, 7-25, 1-33

SQLWARN7 flag, gls, 1-38, 7-25, 1-33, 1-34, 1-47

SQLCA. See SQL Communications Area.,

sqlca.h header file, dapi, 1-6

constant definitions, esqlc, 11-36

definition of, esqlc, 1-23

structure definition, esqlc, 11-28, 13-28

variable definitions, esqlc, 11-32, 11-12, 13-28

sqlca.sqlcode value. See SQLCODE variable.,

sqlca.sqlerrd array,

definition of, esqlc, 11-29, 11-30

sqlerrd[0], esqlc, 11-34, 14-9

sqlerrd[1], esqlc, 11-29, 11-51, 11-34, 11-48, 11-38

sqlerrd[2], esqlc, 11-35, 11-38

sqlerrd[3], esqlc, 11-34, 14-9

sqlerrd[4], esqlc, 11-39, 14-9, 11-38

sqlerrd[5], esqlc, 11-35

sqlca.sqlwarn structure,

definition of, esqlc, 11-30, 11-31, 11-37

sqlwarn0, esqlc, 11-30, 11-31

sqlwarn1, esqlc, 3-17, 11-30, 11-31, 6-35, 3-11, 12-28

sqlwarn2, esqlc, 11-30, 11-31, 12-28

sqlwarn3, esqlc, 11-31, 12-28

sqlwarn4, esqlc, 15-23, 11-31, 12-28

sqlwarn5, esqlc, 11-31

sqlwarn6, esqlc, 11-31, 12-28

sqlwarn7, esqlc, 11-30, 11-31, 12-28

sqlca.sqlwarn.sqlwarn7 flag, gls, 7-25

SQLCHAR data type constant, gls, 8-17

SQLCHAR data-type constant, esqlc, 2-8

See also CHAR data type.,

SQLCODE field,

after opening cursor, sqlt, 5-21

description of, sqlt, 5-9

End of Data condition, sqls, 1-823

end of data on SELECT, sqlt, 6-14

end of data signalled, sqlt, 5-18

errors in, sqls, 1-822

Not Found condition, sqls, 1-823

set by DELETE, sqlt, 6-4

set by DESCRIBE, sqlt, 5-33

set by PUT, FLUSH, sqlt, 6-11

SQLCODE value, esqlc, 12-101, 12-96, 1-116, 12-99, dapi, 12-95

SQLCODE variable,