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,
after a DESCRIBE statement, esqlc, 11-33, 15-17
after a GET DIAGNOSTICS statement, esqlc, 11-13
after a PREPARE statement, esqlc, 11-39
after a simple large-object access, esqlc, 8-9
after an ALLOCATE COLLECTION, esqlc, 9-12
after an ALLOCATE ROW, esqlc, 9-57
after an EXECUTE statement, esqlc, 11-40
and sqlerrd, esqlc, 11-29
definition of, esqlc, 11-32
in diagnostics area, esqlc, 11-10, 11-13
in thread-safe code, esqlc, 13-27, 13-17
indicating an interrupt, esqlc, 12-52
indicating runtime errors, esqlc, 11-38
relation to sqlca structure, esqlc, 11-32
result codes, esqlc, 11-29, 11-34
retrieving error message text, esqlc, 11-51, 11-48
See also ISAM error code; sqlca structure; SQLSTATE variable.,
See also SQL Communications Area (SQLCA).,
sqld field. See sqlda.sqld field.,
sqlda,
and a fetch array, esqlc, 15-35
sqlda structure, gls, 8-12, 8-14
allocating memory for, esqlc, 17-10, 17-6, 13-17
assigning values to, esqlc, 17-13
data type lengths, esqlc, 3-7
declaring, esqlc, 17-5
definition of, esqlc, 15-10
desc_name field, esqlc, 15-15
desc_next field, esqlc, 15-15
desc_occ field, esqlc, 15-15
DESCRIBE statement with, sqls, 1-338
examples, esqlc, 17-34, 17-18
FETCH statement with, sqls, 1-420
FETCH with, sqls, 1-413
fetching rows into, esqlc, 17-14
fields of, esqlc, 15-10, 15-11, 15-12, 15-13
for columns of a SELECT, esqlc, 17-17
for columns of an INSERT, esqlc, 17-30
for distinct-type columns, esqlc, 15-32
for input parameters, esqlc, 17-43, 17-32
for opaque-type columns, esqlc, 15-31, 15-29
for return values of a user-defined function, esqlc, 17-26
freeing memory for, esqlc, 17-15
getting field values, esqlc, 17-13
in DESCRIBE, sqls, 1-343
in EXECUTE, sqls, 1-388, 1-393
in EXECUTE...INTO, sqls, 1-391
in EXECUTE...USING, sqls, 1-395
in PUT, sqls, 1-562, 1-557
initializing, esqlc, 17-7
interrupting database server, esqlc, 12-52
managing, esqlc, 17-4
obtaining values from, esqlc, 17-13
OPEN...USING DESCRIPTOR, sqls, 1-535
setting fields, esqlc, 17-13
specifying input parameter values for, esqlc, 17-14
sqld field. See sqlda.sqld field.,
sqlvar structure. See sqlda.sqlvar structure.,
uses of, esqlc, 17-16
using an indicator variable, esqlc, 15-13
sqlda.h header file, esqlc, 1-26, 17-5, 1-23, dapi, 1-6
sqlda.sqld field,
after a DESCRIBE, esqlc, 17-21, 17-10, 15-16, 17-7
definition of, esqlc, 15-10, 15-11
saving, esqlc, 17-30, 17-17
setting, esqlc, 17-32, 17-39
sqlda.sqlvar structure,
after a DESCRIBE, esqlc, 17-7
definition of, esqlc, 15-12
getting field values, esqlc, 17-13
setting fields, esqlc, 17-13
sqldata field. See sqlda.sqlvar.sqldata field.,
sqlflags field, esqlc, 15-14
sqlformat field, esqlc, 15-13
sqlidata field, esqlc, 17-33, 15-13
sqlilen field, esqlc, 17-33, 15-13
sqlind field, esqlc, 17-8, 17-30, 17-10, 17-33, 15-31, 15-13
sqlitype field, esqlc, 17-33, 15-13
sqllen field. See sqlda.sqlvar.sqllen field.,
sqlname field, esqlc, 17-8, 17-21, 17-10, 17-24, 15-13
sqlownerlen field, esqlc, 15-14
sqlownername field, esqlc, 15-14
sqlsourceid field, esqlc, 15-32, 15-14
sqlsourcetype field, esqlc, 15-32, 15-14
sqltype field. See sqlda.sqlvar.sqltype field.,
sqltypelen field, esqlc, 15-14
sqltypename field, esqlc, 15-14
sqlxid field, esqlc, 15-13
sqlda.sqlvar.sqldata field, gls, 8-15
after a DESCRIBE, esqlc, 17-8, 17-10
after a FETCH, esqlc, 17-24, 17-14, 17-38, 17-29, 17-18
allocating memory for, esqlc, 17-10, 17-23, 15-11
definition of, esqlc, 15-13
freeing memory for, esqlc, 17-25, 17-16
setting column value, esqlc, 17-30, 17-31
setting input parameter data, esqlc, 17-40, 17-33
sqlda.sqlvar.sqllen field, gls, 8-15
after a DESCRIBE, esqlc, 17-8, 17-10
definition of, esqlc, 15-13
determining host variable type, esqlc, 17-24, 17-15
for varchar data, esqlc, 3-7
inserting opaque-type data, esqlc, 15-29
setting input parameter length, esqlc, 17-40, 17-33
used to allocate memory, esqlc, 17-23, 17-12, 17-27, 17-17
sqlda.sqlvar.sqlname field, gls, 8-16
sqlda.sqlvar.sqltype field,
after a DESCRIBE, esqlc, 17-8, 17-10
column type values, esqlc, 15-20, 15-32, 17-13
definition of, esqlc, 15-13
determining host variable type, esqlc, 17-24, 17-15
indicating distinct-type data, esqlc, 15-32
inserting opaque-type data, esqlc, 15-29
setting input parameter type, esqlc, 17-40, 17-32
used to allocate memory, esqlc, 17-23, 17-12, 17-27, 17-17
sqldata field. See sqlda.sqlvar.sqldata field.,
SQLDATE data-type constant, esqlc, 2-8
See also DATE data type.,
SQLDBOOLEAN distinct-bit constant, esqlc, 15-32, 15-34
SQLDECIMAL data-type constant, esqlc, 2-8
See also DECIMAL data type.,
sqldetach() library function, esqlc, 12-41, 12-33, 13-25, 12-57
SQLDISTINCT distinct-bit constant, esqlc, 15-32, 15-34
SQLDLVARCHAR distinct-bit constant, esqlc, 15-32, 15-34
sqldone() library function, esqlc, 12-70, 12-64, 12-33
SQLDTIME data-type constant, esqlc, 2-8
See also DATETIME data type.,
SQLERRD array,
count of deleted rows, sqlt, 6-4
count of inserted rows, sqlt, 6-11
count of row, sqlt, 6-14
count of rows, sqls, 1-915
description of, sqlt, 5-10
syntax of naming, sqlt, 5-8
value of inserted SERIAL value, sqls, 1-914
value of inserted SERIAL8 value, sqls, 1-917
sqlerrd array. See sqlca.sqlerrd array.,
SQLERRM character array, sqlt, 5-13
sqlexit() library function, esqlc, 12-41, 12-65
SQLFLOAT data-type constant, esqlc, 2-8
See also FLOAT data type.,
sqlhdr.h file,
and FetBufSize global variable, esqlc, 14-23
FetBufSize variable, esqlc, 14-23
sqlhdr.h header file, esqlc, 1-26, 1-23, dapi, 1-6
determining product version, esqlc, 13-14
var binary macros, esqlc, 10-32
sqlhdr.h, and OptMsg global variable, esqlc, 12-44
sqlhosts file, sqlr, 3-51, esqlc, B-2, 12-7
sqliapi.h header file, definition of, esqlc, 1-23
SQLINT data-type constant, esqlc, 2-8
See also INTEGER data type.,
SQLINT8 data-type constant, esqlc, 2-9
See also INT8 data type.,
SQLINTERVAL data-type constant, esqlc, 2-8
See also INTERVAL data type.,
SQLKEYWORD_ prefix, esqlc, 1-73
sqllen field. See sqlda.sqlvar.sqllen field.,
SQLLIST data-type constant, esqlc, 2-9
See also LIST data type.,
SQLLVARCHAR data-type constant, esqlc, 2-9
See also LVARCHAR data type.,
SQLMONEY data-type constant, esqlc, 2-8
See also MONEY data type.,
SQLMULTISET data-type constant, esqlc, 2-9
See also MULTISET data type.,
SQLNCHAR data-type constant, esqlc, 2-8
See also NCHAR data type.,
SQLNOTFOUND constant,
definition of, esqlc, 11-36
detecting NOT FOUND condition, esqlc, 11-45
See also NOT FOUND condition.,
with EXECUTE, sqls, 1-396
with PREPARE, sqls, 1-552
SQLNULL constant. See Null value.,
SQLNVCHAR data type constant, gls, 8-17, 8-18
SQLNVCHAR data-type constant, esqlc, 2-8
See also NVARCHAR data type.,
sqlproto.h header file, esqlc, 1-23, 1-25
SQLROW data-type constant, esqlc, 2-9
See also Row type (SQL).,
SQLSERIAL data-type constant, esqlc, 2-8
See also SERIAL data type.,
SQLSERIAL8 data-type constant, esqlc, 2-9
See also SERIAL8 data type.,
SQLSET data-type constant, esqlc, 2-9
See also SET data type.,
sqlsignal() library function, esqlc, 12-66
SQLSMFLOAT data-type constant, esqlc, 2-8
See also SMALLFLOAT data type.,
SQLSMINT data-type constant, esqlc, 2-8
See also SMALLINT data type.,
sqlstart() library function, esqlc, 12-20, 12-65, 12-68
SQLSTATE value, esqlc, 12-101, 12-96, 1-116, 12-99, dapi, 12-95
SQLSTATE variable,
after a GET DIAGNOSTICS statement, esqlc, 11-13
ANSI compliance, sqls, 1-444
applications with, sqls, 1-448
class and subclass codes, sqls, 1-445, esqlc, 11-10, 11-14, 11-15
cursor with, sqls, 1-531, 1-95
determining database server features, esqlc, 11-22, 12-28
determining number of exceptions, esqlc, 11-8
determining origin of class portion, esqlc, 11-10, 11-22, 11-24, 11-25
determining origin of subclass portion, esqlc, 11-10, 11-22, 11-24, 11-25
end of data class code, sqls, 1-443
End of Data condition, sqls, 1-823
errors class code, sqls, 1-443
errors in, sqls, 1-822
in databases that are not ANSI compliant, sqlt, 5-18
in diagnostics area, esqlc, 11-10
in thread-safe code, esqlc, 13-27, 13-17
indicating truncation, esqlc, 3-17, 3-11
Informix-specific message, subclass code, sqls, 1-444
message in, sqls, 1-442
not found class code, sqls, 1-443
Not Found condition, sqls, 1-823
quick reference, sqls, 1-443
result codes, esqlc, 11-19
See also SQLCODE variable.,
subclass codes, sqls, 1-443
success class code, sqls, 1-443
use with a cursor, sqlt, 5-22
using, esqlc, 11-12
using the WHENEVER statement, esqlc, 11-45
warning class code, sqls, 1-443
warning values, esqlc, 11-22
warnings in, sqls, 1-822
X/Open mode, sqls, 1-442
SQLSTATE, and error messages, dbdkug, 1-11
sqlstype.h header file, dapi, 1-6
definition of, esqlc, 1-23
statement-type constants, esqlc, 11-33, 15-17
SQLTEXT data type constant, gls, 8-13
SQLTEXT data-type constant, esqlc, 2-8
See also TEXT data type.,
sqltype field. See sqlda.sqlvar.sqltype field.,
sqltypes.h header file, dapi, 1-6, gls, 8-13, 8-18
data-type constants, esqlc, 16-9, 15-20, 2-7
definition of, esqlc, 1-23
distinct-bit constants, esqlc, 15-32
distinct-bit macros, esqlc, 15-32
simple-large-object data types, esqlc, 8-9, 8-6
source type for distinct columns, esqlc, 15-14, 15-9
SQLUDTFIXED data-type constant, esqlc, 15-34, 2-9
See also Fixed-length opaque data type.,
SQLUDTVAR data-type constant, esqlc, 15-34, 2-9
See also Varying-length opaque data type.,
sqlvar structure. See sqlda.sqlvar structure.,
sqlvar_struct structure,
description of, gls, 8-15
sqldata field, gls, 8-15
sqllen field, gls, 8-15
sqlname field, gls, 8-16
storing column data, gls, 8-15, 8-16
with fetch array, esqlc, 15-38
sqlvar_struct typedef. See sqlda.sqlvar structure.,
SQLVCHAR data type constant, gls, 8-17, 8-18
SQLVCHAR data-type constant, esqlc, 2-8
See also VARCHAR data type.,
SQLWARN array, sqlt, 5-12
syntax of naming, sqlt, 5-8
when dbspace skipped, sqls, 1-692
with DBANSIWARN environment variable, sqls, 1-969
with PREPARE, sqlt, 5-31
with SELECT, sqls, 1-609
with WHENEVER, sqls, 1-822
SQLWARN7 warning flag, gls, 1-38, 7-25, 1-33, 1-34, 1-47
sqlxtype.h header file, dapi, 1-6
definition of, esqlc, 1-23
X/Open data types, esqlc, 15-21, 2-9, 1-66
sqrt() built-in function, extend, 2-8
-ss processor option, esqlc, 1-93, 1-94, 1-86
sscanf() function, dbdkug, 5-22
STACK routine modifier, sqls, 1-1031, dapi, 11-5
Stack size, dbdkug, 3-29
Stack space,
used by DataBlade module routines, udr, 5-12
STACKSIZE configuration parameter, dapi, 11-5
Stacksize, setting INFORMIXSTACKSIZE, sqlr, 3-51
Standards. See ANSI SQL standards; X/Open standards.,
START DATABASE statement, esqlc, 12-18, 12-20
START VIOLATIONS TABLE statement, sqls, 1-748 to
privileges required for executing, sqls, 1-751
relationship to SET, sqls, 1-750
relationship to STOP VIOLATIONS TABLE, sqls, 1-750
Starting,
BladeManager command line interface, bldmg_ug, 3-5
BladeManager GUI, bldmg_ug, 2-4
Startup file for BladeManager command line interface, bldmg_ug, 3-6
state table in stores7 database, columns in, sqlr, A-7
State type, for an aggregate, dbdkug, 3-15
Statement, sqlr, Glossary-19
block, sqlr, Glossary-19
identifier, sqlr, Glossary-19
SQL,
Statements not valid in stored routine, sqls, 1-1043
Statement block, sqls, 1-1042 to
statements not allowed in, sqls, 1-1043
Statement identifier, gls, 1-48, 1-5, 1-6, 3-6, 4-8, 7-6
case sensitivity, esqlc, 1-18
creating, esqlc, 14-5
cursor for, sqls, 1-319
DECLARE statement, sqls, 1-304
definition of, sqls, 1-543
dynamic, sqls, 1-544
freeing, esqlc, 14-13
releasing, sqls, 1-543
scope of, sqls, 1-386
scope rules, esqlc, 13-22, 1-65
structure, esqlc, 14-5
syntax,
in PREPARE, sqls, 1-541
use,
in PREPARE, sqls, 1-543
using delimited identifiers, esqlc, 1-33
Statement local variable,
declaration, sqls, 1-943
expression, sqls, 1-944
using, sqls, 1-944
Statement local variable (SLV), udr, 3-15
precedence of, udr, 3-16
Statement Local Variable (SLV), dbdkug, 3-27
Statement. See SQL, statement.,
Static cursor,
with OPTOFC feature, esqlc, 14-36
static preprocessor option, esqlc, 13-6, 13-7, 1-77, 13-28
-static preprocessor option, esqlc, 1-50
Static SQL, sqlt, 5-5
Static variables, avoiding, dbdkug, 4-13
Static-link library, esqlc, 1-95, 1-96
status code, dapi, 9-13
Status information,
last-access time, dapi, 3-13
last-change time, dapi, 3-14
last-modification time, dapi, 3-14
location of, dapi, 3-8
reference count, dapi, 3-14
size, dapi, 3-14
storage characteristics, dapi, 3-13
Status variable, sqlr, Glossary-19
STATUS variable (4GL), sqlt, 5-9
stcat() library function, esqlc, 3-42, 14-7
stchar() library function, esqlc, 3-44
stcmpr() library function, esqlc, 3-46
stcopy() library function, esqlc, 14-7, 3-48
StdAfx.cpp file, dbdkug, B-3
StdAfx.h file, dbdkug, B-3
StdDbdk.cpp file, dbdkug, B-4, 6-27
StdDbdk.h file, dbdkug, B-4, 6-27
stddef.h header file, dapi, 1-8
STDEV function, sqls, 1-955
stleng() library function, esqlc, 3-50
stock table in stores7 database, columns in, sqlr, A-5
STOP VIOLATIONS TABLE statement,
description of, sqls, 1-767
privileges required for executing, sqls, 1-768
relationship to START VIOLATIONS TABLE, sqls, 1-750
syntax, sqls, 1-767
Storage characteristics,
altering, esqlc, 7-36, dapi, 12-262, 3-73
choosing, dapi, 3-37
column-level, esqlc, 7-14, 7-39, dapi, 12-266, 12-268, 3-44
create-time flags, esqlc, 7-10, dapi, 3-48
definition of, dapi, 3-8
disk-storage information, esqlc, 7-8, dapi, 3-9, 3-47
functions for, dapi, 3-28
hierarchy, dapi, 3-40
hierarchy of, dapi, 3-40
inheritance hierarchy, esqlc, 7-13
initializing new, dapi, 3-34
location of, dapi, 3-8
obtaining, esqlc, 7-84, 7-31, 7-12, dapi, 12-342, 3-78, 3-13
sbspace-level, esqlc, 7-13
specifying, dapi, 3-21
system default, esqlc, 7-13, dapi, 3-41, 3-42
system-level, esqlc, 7-49, dapi, 12-317
system-specified, esqlc, 7-13, dapi, 3-42, 3-35
user-defined, esqlc, 7-15
user-specified, dapi, 3-46
Storage for DataBlade modules, documentation of, overview, A-8
Stored procedure, sqlr, Glossary-19, esqlc, 14-47, gls, 1-48, 1-5, 1-6, 3-6, 3-7, 4-8
dropping with DROP PROCEDURE, sqls, 1-365
executing, sqls, 1-408
handling multiple rows, sqls, 2-52
inserting data with legacy SPL, sqls, 1-509
name confusion with SQL functions, sqlt, 14-24
replaced by SPL function, sqls, 1-126, 1-734
replaced by SPL procedure, sqls, 1-183
Return clause, sqls, 1-1025
saving return values, sqls, 1-410
See also EXECUTE PROCEDURE statement.,
See also Procedure;SPL Procedure;SPL routine.,
sending mail from, sqls, 2-55
simulating errors, sqls, 2-49
Stored Procedure Language, sqlr, Glossary-19, dbdkug, 3-3
documentation of, overview, A-8
writing DataBlade module routines, overview, 1-22
Stored Procedure Language. See SPL.,
Stored routine,
granting privileges on, sqlt, 11-14
stores7 database, sqlr, Intro-6, sqls, Intro-6, sqlt, Intro-7, extend, Intro-5, udr, Intro-5
call_type table columns, sqlr, A-6
catalog table columns, sqlr, A-5
creating and populating, esqlc, B-3
cust_calls table columns, sqlr, A-6
customer table columns, sqlr, A-2
data values, sqlr, A-16
description of, sqlr, A-1
items table columns, sqlr, A-4
manufact table columns, sqlr, A-7
map of, sqlr, A-8
orders table columns, sqlr, A-3
primary-foreign key relationships, sqlr, A-9 to
See also Demonstration database.,
stock table columns, sqlr, A-5
structure of tables, sqlr, A-2
Straight cast, overview, 1-25
Strategy function,
definition, sqls, 1-176
description for secondary access method, extend, 4-7
description of, extend, 4-7
optimizer use of, sqls, 1-176
side-effect data, sqls, 1-178
specifying in CREATE OPCLASS, sqls, 1-176
Strategy functions, sqlr, Glossary-19
definition, udr, 1-8
Stream input, gls_api, 1-22
Stream output, gls_api, 1-22
string,
support for, dapi, 2-4
string data type,
corresponding SQL data type, esqlc, 2-4, 2-12
defined constant, esqlc, 2-10
definition of, esqlc, 3-4, 3-5
fetching into, esqlc, 3-17, 2-18, 6-35, 5-6, 3-11, 3-13
inserting from, esqlc, 3-17, 3-18, 3-12, 3-14
See also CHAR data type.,
with ANSI-compliant database, esqlc, 3-18
with empty string, esqlc, 3-6
String operations, gls_api, 2-29
See also String processing; String traversal.,
String processing,
character searching, gls_api, 2-33
concatenation, gls_api, 2-31
INFORMIX-GLS functions for, gls_api, 2-31
multibyte characters, gls_api, 2-31
string copying, gls_api, 2-32
string-length determination, gls_api, 2-32
wide characters, gls_api, 2-31
String traversal, gls_api, 2-29
String. See Character data; Quoted string; Substring.,
String. See Character string; Multibyte-character string; Wide-character string.,
Strings,
counting number of values in, dbdkug, 5-19
delimiters, dbdkug, 6-27
reading, dbdkug, 5-20, 6-28
.str file, strings file, dbdkug, 10-5
writing, dbdkug, 6-32
strncmp() system call, esqlc, 11-20, 11-24
struct data type. See Structure.,
Structure,
as host variable, esqlc, 1-37
conv_state_t, gls_api, 4-47, 2-25
decimal, esqlc, 4-4
dtime, esqlc, 6-29
for dynamic management, esqlc, 15-4
gl_wchar_t, gls_api, 2-8
ifx_int8_t, esqlc, 5-7
ifx_lo_create_spec_t, esqlc, 7-8
ifx_lo_stat_t, esqlc, 7-30
ifx_lo_t, esqlc, 7-18
intrvl, esqlc, 6-30
locator. See Locator structure.,
MI_FPARAM, dapi, 4-3
MI_LO_LIST, dapi, 12-298
MI_LO_SPEC, dapi, 1-7, 3-20, 3-21
MI_LO_STAT, dapi, 3-20, 1-8, 3-23
nesting, esqlc, 1-37
sqlca, esqlc, 11-27
sqlda, esqlc, 15-10
sqlvar_struct, esqlc, 15-12
Structured Query Language (SQL),
CREATE FUNCTION statement, udr, 2-4, 2-5
CREATE PROCEDURE statement, udr, 2-5
statements using routine signature, udr, 2-4
statements using specific name, udr, 2-6
Structured Query Language. See SQL.,
structures,
default information, dapi, 5-10
Subclass value. See SQLSTATE variable, class and subclass codes.,
Subquery, sqls, 1-621
ALL/ANY/SOME, sqls, 1-851
examples, sqls, 1-626
beginning with IN keyword, sqls, 1-625
collection column and, sqlt, 12-14
condition with, sqls, 1-849 to
UNIQUE or DISTINCT keyword, sqls, 1-850
correlated, sqlt, 3-29
cascading deletes error, sqlt, 4-24
correlated vs. uncorrelated, sqlt, 3-29, 4-14
correlated,
condition dependencies for, sqls, 1-849
definition of, sqlr, Glossary-19
DISTINCT keyword with, sqls, 1-601
in DELETE statement, sqlt, 4-6
in SELECT, sqlt, 3-29 to
restrictions with UNION operator, sqls, 1-645
UPDATE with, sqlt, 4-13
Subscripting,
on character columns, sqls, 1-636
SPL variables, sqlt, 14-22
Subservient table, sqlt, 3-20
Substitutability, sqlt, 10-25
Substring, sqlt, 14-22, gls, 3-39, 3-34
in ORDER BY clause of SELECT, sqls, 1-636
-subsystem processor option, esqlc, 1-94, 1-86
Subtable, sqlr, Glossary-19, sqlt, 10-20
inherited properties, sqls, 1-216
Subtype, sqlr, Glossary-19, sqlt, 10-20
Subtype and supertype, udr, 2-10
SUM function, sqls, 1-954
Supertable, sqlr, Glossary-19, sqlt, 10-20
Supertype, sqlr, Glossary-20, sqlt, 10-20
Support,
C++ library, dbdkug, B-2, B-4, 6-34, 6-27 to
methods, dbdkug, 6-25 to
routines, defining in BladeSmith, dbdkug, 6-10, 3-38
Support function,
as casts, extend, 5-17
assign, sqls, 1-793, 1-523, 1-503, 1-172
assign(), extend, 6-4, 5-6
compare, sqls, 1-173
compare(), extend, 6-5, 5-6
defining, sqls, 1-171
definition, sqls, 1-178
description for secondary access method, extend, 4-7
description of, extend, 5-13, 4-7
destroy, sqls, 1-377, 1-329, 1-172
destroy(), extend, 6-4, 5-6
dropping, extend, 5-29
export, sqls, 1-172, extend, 6-4, 5-6
exportbinary, sqls, 1-172, extend, 6-4, 5-6
import, sqls, 1-172, extend, 6-4, 5-6
importbinary, sqls, 1-172, extend, 6-4, 5-6
Informix GLS API, extend, 6-24
input, sqls, 1-171, extend, 6-3, 5-5
lohandles, sqls, 1-173
lohandles(), extend, 6-5, 5-6
output, sqls, 1-171, extend, 6-3, 5-5
privileges, extend, 5-19, 5-29
receive, sqls, 1-172, extend, 6-4, 5-5
registering, extend, 5-15
routine identifier, extend, 5-16
send, sqls, 1-172, extend, 6-4, 5-6
specifying in CREATE OPCLASS, sqls, 1-178
that support bulk copy, extend, 6-14
Support functions, sqlr, Glossary-20
definition, udr, 1-8
overview, overview, 1-23
tests for, overview, 1-26
support.c file, dbdkug, A-1, 5-5
-Sw processor option, esqlc, 1-94, 1-86
Symbols,
unresolved when compiling on UNIX, dbdkug, 5-38
Synonym, gls, 3-7
ANSI-compliant naming, sqls, 1-207
chaining, sqls, 1-374, 1-209
creating with CREATE SYNONYM, sqls, 1-207
difference from alias, sqls, 1-207
dropping with DROP SYNONYM, sqls, 1-374
identical names, sqls, 1-209
loading data into, sqls, 1-515
naming conventions, sqls, 1-1048
private, sqls, 1-208
privileges, sqls, 1-208
privileges. See Privilege,table-level.,
public, sqls, 1-208
syssynonyms information, sqlr, 1-51
syssyntable information, sqlr, 1-52
Synonym Name segment, sqls, 1-1047
Syntax conventions, dbdkug, Intro-7
elements of, sqls, Intro-13
example diagram, sqls, Intro-16
how to read, sqls, Intro-16
icons used in, sqls, Intro-14
Syntax Guide,
diagrams in, sqls, 1-9
Elements, Purpose, Restrictions, and segment location (Syntax), sqls, 1-9
organization, sqls, 1-7
References sections, sqls, 1-10
Segments sections, sqls, 1-7
sysams system catalog table, extend, 4-24
sysbldobjects system table, dbdkug, 3-52
SYSBldTstSBSpace routine, dbdkug, C-1
syscasts, sqlr, 2-25
syscasts system catalog table, extend, 3-5, 3-13, 5-29, 5-18
syscolattribs, sqlr, 1-20
syscolattribs system catalog table, dapi, 3-44
syscolauth,
example, sqlr, 1-8
syscolumns, sqlr, 1-23
example, sqlr, 1-7
sysconstraints, sqlr, 1-29
sysdefaults, sqlr, 1-30
sysdepend, sqlr, 1-32
sysdistrib, sqlr, 1-32
syserrors, sqlr, 1-33
syserrors system catalog, dapi, 12-73, dbdkug, 5-13, 5-17
sysfragauth, sqlr, 1-34
sysfragments, sqlr, 1-36
sysindexes,
view, sqlr, 1-39
sysindices, sqlr, 1-37
sysinherits, sqlr, 1-39
syslangauth, sqlr, 1-40
syslogmap, sqlr, 1-40
Sysmaster database,
See alsoSystem catalog. 70,
Sysmaster databases, sqlr, Glossary-20
sysobjstate, sqlr, 1-40
sysopclasses, sqlr, 1-42
sysopclasses system catalog table, extend, 4-27
sysprocauth, sqlr, 1-44
sysprocauth system catalog table, extend, 5-19, 5-29
sysprocedure system catalog table, extend, 5-29
sysprocedures, sqlr, 1-46
sysprocedures system catalog table, extend, 5-16
sysprocplan, sqlr, 1-48
sysreferences, sqlr, 1-49
sysroleauth, sqlr, 1-50
sysroutinelangs, sqlr, 1-51
syssynonyms, sqlr, 1-51
syssyntable, sqlr, 1-52
systabauth, sqlr, 1-8, 1-53, sqlt, 4-18
systables, sqlr, 1-54, sqlt, 4-18
example, sqlr, 1-6
systables system catalog table, gls, 1-26
System call,
calloc(), esqlc, 17-10
DCE restrictions, esqlc, 13-25
exec(), esqlc, 13-25, 12-58
exit(), esqlc, 11-44, 11-33
fclose(), esqlc, 1-64
fopen(), esqlc, 1-64
fork(), esqlc, 8-62, 13-25, 12-57
fread(), esqlc, 1-64
free(), esqlc, 17-25, 8-14
longjmp(), esqlc, 12-64, 12-36
malloc(), esqlc, 17-10, 17-11, 17-25, 8-14
open(), esqlc, 8-19
setjmp(), esqlc, 12-36
signal(), esqlc, 12-36
strncmp(), esqlc, 11-20, 11-24
vfork(), esqlc, 12-58
wait(), esqlc, 8-63
System calls,
avoiding, dbdkug, 4-10
user-defined virtual processor, using in, dbdkug, 4-10
System catalog, sqlr, 1-3 to , gls, 1-26, 2-18
accessing, sqlr, 1-10
altering contents not recommended, sqlr, 1-10
character variable length, sqlr, 1-27
collection data type elements, sqlr, 1-17
column information,
constraints (sysconstraints), sqlr, 1-29
default values (sysdefaults), sqlr, 1-30
complex data type members, sqlr, 1-17
constraint information, sqlr, 1-20, 1-23
data distribution information, sqlr, 1-32
data type privileges, sqlr, 1-63
database-level privileges, sqlr, 1-60
description of, sqlr, Glossary-20
execute on routine privileges, sqlr, 1-44
how used by database server, sqlr, 1-5
list of tables, sqlr, 1-11
location, sqls, 1-118
messages, sqlr, 1-33
object states, sqlr, 1-40
operator class table (sysopclasses), sqlr, 1-42
optical cluster, sqlr, 1-43
privilege information,
user-defined data type, sqlr, 1-63
privileges in, sqlt, 11-9
privileges needed, sqlr, 1-10
programming language, sqlr, 1-40
programming languages supported, sqlr, 1-51
referential constraint information, sqlr, 1-49
referential constraints (sysreferences), sqlr, 1-49
role names for privileges, sqlr, 1-50
routine plans, sqlr, 1-48
routines, sqlr, 1-46
smart large object attributes (syscolattribs), sqlr, 1-20
structure, sqlr, 1-11
sysams, sqlr, 1-12, extend, 4-24
sysattrtypes, sqlr, 1-17
sysblobs table, sqlr, 1-18
syscasts, sqlr, 1-19, extend, 3-5, 5-18
syschecks, sqlr, 1-20, sqls, 1-569
syscolauth, sqlr, 1-22, sqlt, 11-9
syscoldepend, sqlr, 1-23
sysdepend,
use with DROP VIEW, sqls, 1-383
sysindices, sqlr, 1-9
sysopclstr, sqlr, 1-43
sysprocauth, extend, 5-19
sysprocbody, sqlr, 1-45, sqlt, 14-81
sysprocedures, extend, 5-16
systabauth, sqlt, 11-9
sysusers, sqlt, 11-9
sysviews, sqlr, 1-7, sqls, 1-569
sysxtddesc, sqlr, 1-62
sysxtdtypeauth, sqlr, 1-63, extend, 5-19, 1-12
sysxtdtypes, sqlr, 1-64, sqls, 1-168, extend, 5-15, 1-12
table fragment privileges, sqlr, 1-34
table fragmentation, sqlr, 1-36
table indexes, sqlr, 1-37
table information,
dependencies (sysdepend), sqlr, 1-32
table inheritance, sqlr, 1-39
table synonyms, sqlr, 1-51, 1-52
table-level privileges, sqlr, 1-53
tables in database, sqlr, 1-54
trace classes, sqlr, 1-56
trace messages, sqlr, 1-57
triggers, sqlr, 1-59
UPDATE STATISTICS for routines, sqlr, 1-48
UPDATE STATISTICS results, sqlr, 1-32
updating statistics, sqlr, 1-11
updating tables, sqlr, 1-10
user-defined casts, sqlr, 1-19
user-defined data type descriptions, sqlr, 1-62
user-defined function information, sqls, 1-127
user-defined procedure information, sqls, 1-183
view dependencies (sysdepend), sqlr, 1-32
view synonyms, sqlr, 1-52
views, sqlr, 1-61
violations, sqlr, 1-61
System catalog routines,
systrigbody, sqlr, 1-58
system defaults, dapi, 5-9
System descriptor area,
DATA,
fetching null value, sqls, 1-438
host variables in, sqls, 1-706
IDATA field, sqls, 1-438
PRECISION field, sqls, 1-437
X/Open standard with, sqls, 1-437
System indexes,
idxname,
used with sysindices, sqlr, 1-39
idxtab,
used with sysindices, sqlr, 1-39
System Monitoring Interface (SMI), sqlr, Glossary-20
System name, in database name, sqls, 1-859
system parameters, dapi, 5-11
SYSTEM statement,
setting environment variables with, sqls, 2-55
syntax, sqls, 2-54
System-defined cast, extend, 3-3, 3-8, 3-13
definition of, sqlr, Glossary-20
See Cast, system-defined.,
System-descriptor area,
allocating memory for, sqls, 1-24, esqlc, 16-5
assigning values to, esqlc, 16-8
COUNT field. See COUNT descriptor field.,
COUNT field. See COUNT field.,
DATA field. See DATA field.,
data type lengths, esqlc, 3-7
deallocating memory for, sqls, 1-299
definition of, esqlc, 16-3, 15-5
determining number of values, sqls, 1-435
examples, esqlc, 16-30, 16-24, 16-37, 16-15
FETCH statement with, sqls, 1-419
FETCH.. USING SQL DESCRIPTOR with, sqls, 1-419
fetching rows into, esqlc, 16-11
fields of, esqlc, 15-5, 15-7
for columns of a SELECT, esqlc, 16-13, 16-29
for columns of an INSERT, esqlc, 16-29
for distinct-type columns, esqlc, 15-32
for input parameters, esqlc, 17-41, 16-43, 16-46, 16-36
for opaque-type columns, esqlc, 15-31, 15-29
for return values of a user-defined function, esqlc, 16-22
freeing memory for, esqlc, 16-12
getting field values, esqlc, 16-10
getting values from, sqls, 1-436
IDATA field. See IDATA field.,
ILENGTH field. See ILENGTH field.,
INDICATOR field. See INDICATOR field.,
initializing, esqlc, 16-6
interrupting database server, esqlc, 12-52
item descriptor fields, esqlc, 15-7
item descriptors, sqls, 1-25
ITYPE field. See ITYPE field.,
LENGTH field. See LENGTH field.,
managing, esqlc, 16-4
modifying contents of, sqls, 1-436
NAME field. See NAME field.,
NULLABLE field. See NULLABLE field.,
number of items allocated, sqls, 1-705
obtaining values from, sqls, 1-433, esqlc, 16-8
OPEN using, sqls, 1-535
PRECISION field, sqls, 1-437
PRECISION field. See PRECISION field.,
SCALE field, sqls, 1-437
SCALE field. See SCALE field.,
setting fields, esqlc, 16-9
setting number of values, sqls, 1-705
setting with SET DESCRIPTOR, sqls, 1-702
specifying input parameter values for, esqlc, 16-10
TYPE field, sqls, 1-436, 1-437
TYPE field. See TYPE field.,
undefined, sqls, 1-705
uses for, esqlc, 16-13
using an indicator variable, esqlc, 16-30, 16-36, 15-8
with DESCRIBE, sqls, 1-341, 1-342
with EXECUTE...INTO, sqls, 1-390
with EXECUTE...USING, sqls, 1-394
with PUT, sqls, 1-561
System-specified storage characteristics, dapi, 3-42
systraceclasses, sqlr, 1-56
systraceclasses system catalog, dbdkug, 5-13, 5-14
systraceclasses system catalog table, dapi, 10-3
systracemsgs, sqlr, 1-57
systracemsgs information, sqlr, 1-57
systracemsgs system catalog, dbdkug, 5-17
systracemsgs system catalog table, dapi, 10-8
systriggers, sqlr, 1-59
sysusers, sqlr, 1-60
sysviews, sqlr, 1-61
sysviolations, sqlr, 1-61
sysxtdtypeauth system catalog table, extend, 5-19, 1-12, 5-28
sysxtdtypes, sqlr, 2-56, 2-58
DESCRIBE and GET DESCRIPTOR with, sqls, 1-438, 1-439
sysxtdtypes system catalog table, sqls, 1-168, 1-711, 1-712, 1-381, extend, 5-15, 1-12, 5-29


Copyright © 1997, Informix Software, Inc. All rights reserved.