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

Sample database, installing, vis_ug, 1-26

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

Saving,

resources, vis_ug, 11-4

worlds, vis_ug, 12-4

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

sbspaces,

size and location, sqlr, 1-18

SCALE field,

with DESCRIBE, sqls, 1-342

with SET DESCRIPTOR, sqls, 1-710

Scatter charts,

and multivariate charts, vis_ug, 5-5

description of, vis_ug, 5-6

discussion of, vis_ug, 5-4

properties of, vis_ug, A-60

Scene Editor,

illustration of, vis_ug, 1-15, 4-4

introduction to, vis_ug, 1-7

modes of, vis_ug, 1-15

printing from, vis_ug, 12-5

uses for, vis_ug, 5-9

using the Object Inspector with, vis_ug, 7-20

Scene parameters,

description of, vis_ug, 4-6

example of, vis_ug, 2-5, 4-6

for wormholes, vis_ug, 4-6, 7-18

illustration of mapping, vis_ug, 7-20

in event actions, vis_ug, 4-6

inserting, vis_ug, 4-6

mapping object properties to, vis_ug, 7-9

selecting data types for, vis_ug, 4-7

setting default values for, vis_ug, 4-7

specifying in object properties, vis_ug, 7-18 to

Scene tabs, vis_ug, 14-3, 13-5, 1-23, 14-9

Scenes, vis_ug, 1-3, 1-4

and popup menu tasks, vis_ug, 4-6

contents of, vis_ug, 4-3

description of, vis_ug, 1-5, 4-3

examples of, vis_ug, 2-5

inserting, vis_ug, 4-5

jumping to, vis_ug, 11-12

jumps between, vis_ug, 14-10

local parameters in, vis_ug, 7-5

modifying, vis_ug, 7-18

multiple, vis_ug, 4-3

new, vis_ug, 4-5

parameters in, vis_ug, A-63

properties of, vis_ug, A-62

renaming, vis_ug, 4-6

using scene parameters to change the appearance of, vis_ug, 7-18

varying appearance of, vis_ug, 4-6

viewpoints in, vis_ug, 7-5

Scenes panel,

folders in, vis_ug, 7-6

illustration of, vis_ug, 4-4, 7-5, 1-10

levels of detail in, vis_ug, 7-8

manipulating objects in, vis_ug, 12-7

object hierarchy in the, vis_ug, 7-3

Schema, sqlr, Glossary-16

Schema Knowledge, instll32, 12

Schema. See Data model.,

Scope, sqlr, Glossary-16

Scripting languages,

JavaScript, vis_ug, 14-7

VBScript, vis_ug, 14-7

Scroll cursor, sqls, 1-317

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

Search command, vis_ug, 12-8

Second normal form, sqlt, 8-33

Secondary access method, sqlr, Glossary-17

B-tree, sqls, 1-151

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

default operator class, sqls, 1-179

definition, sqls, 1-175, 1-138

definition of, sqlr, Glossary-17

See Access method, secondary; Index.,

specifying with CREATE OPCLASS, sqls, 1-175

secondary access method,

R-tree, sqls, 1-151

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

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

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

reopening, sqls, 1-537

use of, sqlt, 5-21

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

BETWEEN condition, sqls, 1-622

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

deriving data from expressions, sqlt, 2-45

DESCRIBE with, sqls, 1-341

description of advanced, sqlt, 3-4 to

display label, sqlt, 2-48

DISTINCT keyword, sqls, 1-601, sqlt, 2-51

embedded, sqlt, 5-14

end of data indicator, sqlt, 6-14

expressions in select list, sqls, 1-601

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

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

IN condition, sqls, 1-622

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

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

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

array variable with, sqls, 1-608

INTO clause restrictions, sqls, 1-544

INTO TEMP clause, sqls, 1-642, sqlt, 2-76

IS NULL condition, sqls, 1-623

join, sqlt, 2-67 to

joining tables in WHERE clause, sqls, 1-627

LIKE or MATCHES condition, sqls, 1-623

multiple-table, sqlt, 2-66

ORDER BY clause, sqls, 1-634, sqlt, 2-12

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

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

SELECT clause, sqls, 1-598

select numbers, sqls, 1-638

singleton, sqls, 1-606, sqlt, 2-28

smart large objects with, sqls, 1-890

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 operator, sqls, 1-644, sqlt, 3-39

UNIQUE keyword, sqls, 1-601

view with, sqlt, 11-29

WHERE clause, sqlt, 2-27 to

WHILE or FOR loop with, sqls, 1-983

with,

FOREACH, sqls, 2-27

LET, sqls, 2-40

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

Selecting,

axes, vis_ug, 5-19

data sources, vis_ug, 5-11, 5-9

layouts, vis_ug, 5-11

objects to modify, vis_ug, 7-10

viewpoints when defining event actions, vis_ug, 11-12

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

Selectivity, sqlr, Glossary-17

Self-referencing query, sqlt, 3-11

SELFUNC routine modifier, sqls, 1-1030

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

Send support function, sqls, 1-172

Sequential cursor, 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

,

generated number in SQLERRD, sqlt, 5-10

initializing value, sqlt, 9-10

inserting values, sqlr, 2-60

length (syscolumns), sqlr, 1-27

resetting values, sqlr, 2-60

starting value, sqlt, 4-9

syscolumns coltype code for, sqlr, 1-24

Serial number and key, instll32, 13

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

,

initializing value, sqlt, 9-10

inserting values, sqlr, 2-62

length (syscolumns), sqlr, 1-27

resetting values, sqlr, 2-62

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 parameters, instll32, 20

server_info Information Schema view, sqlr, 1-70

services file, instll32, 22

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 statement,

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 CONNECTION statement, sqls, 1-685 to

CURRENT keyword, sqls, 1-690

DEFAULT option, sqls, 1-689

SET CONSTRAINT statement,

trigger activated, sqls, 1-282

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

deleting elements, sqls, 1-332

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

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, 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

VALUE clause, sqls, 1-706

X/Open mode, sqls, 1-708

Set difference, sqlt, 3-47

SET EXPLAIN statement, sqls, 1-714 to

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

Setnet32 utility, vis_ug, 13-4, 14-4, 1-20

buttons, instll32, 18

product configuration, instll32, 18

Setting environment variables, instll32, 19, sqlr, 3-8

Setting parameters when defining event actions, vis_ug, 11-12

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

Shared class libraries, sqlt, 1-10

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

Shared lock,

SeeLock,

Shared memory, sqlr, Glossary-17

client (INFORMIXSHMBASE), sqlr, 3-50

parameter file (ONCONFIG), sqlr, 3-57

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

Side-effect index, sqls, 1-178

Simple assignment, sqls, 2-40

Simple forms,

and visibility, vis_ug, 5-20

description of, vis_ug, 5-6

properties of, vis_ug, A-64

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-object data type,

unloading, sqls, 1-771, 1-773

Simple predicate, sqlr, Glossary-18

Simple Query wizard,

creating SQL queries with, vis_ug, 3-8

defining expressions in, vis_ug, 3-9

defining output columns in, vis_ug, 3-14

example of, vis_ug, 3-7

launching, vis_ug, 3-6

SQL format for, vis_ug, 3-7

summarizing records in, vis_ug, 3-12

using, vis_ug, 3-5, 3-6

viewing query results from, vis_ug, 3-15

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

Single inheritance, sqlt, 10-20

Single record, displaying, vis_ug, 5-4

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

Size, modifying, vis_ug, 7-10

Slice locator properties, vis_ug, A-65

SMALLFLOAT data type, sqlr, 2-64, sqls, 1-868, sqlt, 9-11

casts for, sqlr, 2-27

syscolumns coltype code for, sqlr, 1-24

unloading, sqls, 1-771

SMALLINT data type, sqlr, 2-64, sqlt, 9-9

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

length (syscolumns), sqlr, 1-27

syscolumns coltype code for, sqlr, 1-24

unloading, sqls, 1-771

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

attributes in syscolattribs, sqlr, 1-20

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 from a file, sqls, 1-923, 1-924, 1-926

expressions with, sqls, 1-890

extent size, sqlt, 9-29

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

LOCOPY function, sqls, 1-930

LOTOFILE function, sqls, 1-928

modifying characteristics, sqls, 1-78

sbspace storage for, sqlt, 9-26

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

SQL interactive uses, sqlt, 9-27

SQL restrictions, sqlt, 9-26

syntax, sqls, 1-869

Smart large-object,

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

Smart large-object data type,

access time, sqls, 1-252

extent size, sqls, 1-251

logging, sqls, 1-251

unloading, sqls, 1-771, 1-773

SMI.SeeSystem Monitoring Interface.,

Software dependencies, vis_ug, Intro-5, sqlr, Intro-5, sqls, Intro-5, sqlt, Intro-6

Sorting,

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 file, sqlr, Glossary-18

Source scene, vis_ug, 8-10

SOURCEID field,

with GET DESCRIPTOR, sqls, 1-439

with SET DESCRIPTOR, sqls, 1-712

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

Spatial data,

displaying, vis_ug, 5-7

layout for displaying, vis_ug, 5-4

Spatial queries, vis_ug, 13-6

Specific name, sqlr, Glossary-18

syntax, sqls, 1-1039

sysprocedures field, sqlr, 1-46

Spiral patterns,

description of, vis_ug, 5-8

properties of, vis_ug, A-66

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

cursors with, sqls, 2-27

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

executing, sqls, 1-397, 1-545

optimization, sqls, 1-127

punctuation for, sqls, 1-127

registering, sqls, 1-127

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

SPL procedure, sqlr, Glossary-18

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

TRACE output file, sqls, 1-695

SPL routine, sqlr, Glossary-18

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

Spline connectors,

illustration of, vis_ug, 5-23

inserting, vis_ug, 5-24

properties of, vis_ug, A-67

sqexplain.out file, sqls, 1-714

SQL,

error handling, sqlt, 5-17

history, sqlt, 1-15

Informix, sqlt, 1-16

keywords, sqls, 1-968

Structured Query Language, sqlt, 1-15

SQL API, sqlr, Glossary-19

comments with, sqls, 1-12

concatenation operator with, sqls, 1-884

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 Editor, instll32, 12

SQL procedure,

debugging, sqls, 2-57

SQL queries,

about query diagrams for, vis_ug, 3-29

AND and OR clauses in, vis_ug, 3-26

and the Expression Editor, vis_ug, 3-11

casting in, vis_ug, 3-44

choosing functions in, vis_ug, 3-9

combining search criteria in, vis_ug, 3-26

creating with the Advanced Query wizard, vis_ug, 3-15

creating with the Simple Query wizard, vis_ug, 3-8

defining aggregates in, vis_ug, 3-7, 3-12

defining filters in, vis_ug, 3-24, 3-37

defining functional expressions in, vis_ug, 3-7

defining output for, vis_ug, 3-14

defining output from, vis_ug, 3-38

defining parameters in, vis_ug, 3-41, 3-43, 3-25

example of simple, vis_ug, 3-7

format in Advanced Query wizard, vis_ug, 3-15

format in Simple Query wizard, vis_ug, 3-7

modifying, vis_ug, 3-39

modifying in Query Diagram view, vis_ug, 3-39

modifying in SQL Text view, vis_ug, 3-40

modifying parameters in, vis_ug, 3-44

of multiple tables, vis_ug, 3-17

selecting columns for, vis_ug, 3-8

selecting in the Layout wizard, vis_ug, 5-11

selecting tables for, vis_ug, 3-8

summarizing records in, vis_ug, 3-12

to create data sources, vis_ug, 3-3

viewing results from, vis_ug, 3-39, 3-40

SQL statement,

diagnostics area, sqls, 1-441

SQL statements, sqls, 1-14 to

access method, sqls, 1-14

ANSI-compliant, sqls, 1-19

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

client/server connection, sqls, 1-15

comment symbol, sqls, 1-12

comments examples, sqls, 1-12

comments in, sqls, 1-11

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

dynamic management, sqls, 1-17

editor for (DBEDIT), sqlr, 3-31

GET DIAGNOSTICS for, sqls, 1-442

Informix extensions, sqls, 1-19

messages in SQLSTATE variable, sqls, 1-442

not available in routines, sqls, 1-1043

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

SQL Text view,

about, vis_ug, 3-29

introduction to, vis_ug, 1-14

modifying data sources using, vis_ug, 3-40

uses for, vis_ug, 3-6

SQL3, sqlr, Glossary-19

sql_languages Information Schema view, sqlr, 1-70

SQLCA. See SQL Communications Area.,

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 variable,

See also SQL Communications Area (SQLCA).,

sqlda structure,

DESCRIBE statement with, sqls, 1-338

FETCH statement with, sqls, 1-420

FETCH with, sqls, 1-413

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

OPEN...USING DESCRIPTOR, sqls, 1-535

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

SQLERRM character array, sqlt, 5-13

sqlhosts file, sqlr, 3-51

SQLNOTFOUND constant,

with EXECUTE, sqls, 1-396

with PREPARE, sqls, 1-552

SQLSTATE variable,

ANSI compliance, sqls, 1-444

applications with, sqls, 1-448

class and subclass codes, sqls, 1-445

cursor with, sqls, 1-531, 1-95

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

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

subclass codes, sqls, 1-443

success class code, sqls, 1-443

use with a cursor, sqlt, 5-22

warning class code, sqls, 1-443

warnings in, sqls, 1-822

X/Open mode, sqls, 1-442

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

STACK routine modifier, sqls, 1-1031

Stacksize, setting INFORMIXSTACKSIZE, sqlr, 3-51

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 Visionary Studio, vis_ug, 1-19

state table in stores7 database, columns in, sqlr, A-7

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,

cursor for, sqls, 1-319

DECLARE statement, sqls, 1-304

definition of, sqls, 1-543

dynamic, sqls, 1-544

releasing, sqls, 1-543

scope of, sqls, 1-386

syntax,

in PREPARE, sqls, 1-541

use,

in PREPARE, sqls, 1-543

Statement local variable,

declaration, sqls, 1-943

expression, sqls, 1-944

using, sqls, 1-944

Statement. See SQL, statement.,

Static objects,

adding, vis_ug, 6-4

definition of, vis_ug, 6-3

using connectors with, vis_ug, 6-7

Static SQL, sqlt, 5-5

Status variable, sqlr, Glossary-19

STATUS variable (4GL), sqlt, 5-9

STDEV function, sqls, 1-955

Stock charts,

description of, vis_ug, 5-6

properties of, vis_ug, A-69

Stock images,

adding, vis_ug, 11-5

and Picture objects, vis_ug, 6-5

and Visionary building blocks, vis_ug, 1-4

description of, vis_ug, 11-3

illustration of using, vis_ug, 11-7

performance with, vis_ug, 5-17

viewing, vis_ug, 11-7

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

Stored procedure, sqlr, Glossary-19

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 Procedure;SPL Procedure;SPL routine.,

sending mail from, sqls, 2-55

simulating errors, sqls, 2-49

Stored Procedure Language, sqlr, Glossary-19

Stored Procedure Language. See SPL.,

Stored routine,

granting privileges on, sqlt, 11-14

stores7 database, vis_ug, 1-26, sqlr, Intro-6, sqls, Intro-6, sqlt, Intro-7

call_type table columns, sqlr, A-6

catalog table columns, sqlr, A-5

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

Storing resources, vis_ug, 11-4

Storyboards,

contents of, vis_ug, 2-3

creating, vis_ug, 2-3

definition of, vis_ug, 2-3

example of, vis_ug, 2-4, 2-6

in basic steps to create a world, vis_ug, 1-21

tools to create, vis_ug, 2-4

Straight connectors,

example of using, vis_ug, 5-26

illustration of, vis_ug, 5-23

properties of, vis_ug, A-71

Strategy function,

definition, sqls, 1-176

optimizer use of, sqls, 1-176

side-effect data, sqls, 1-178

specifying in CREATE OPCLASS, sqls, 1-176

Strategy functions, sqlr, Glossary-19

Structure view, vis_ug, 1-17

Structured Query Language (SQL), vis_ug, 1-3, 1-5

generated by query diagram, vis_ug, 1-15

Structured Query Language. See SQL.,

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

in ORDER BY clause of SELECT, sqls, 1-636

Subtable, sqlr, Glossary-19, sqlt, 10-20

inherited properties, sqls, 1-216

Subtype, sqlr, Glossary-19, sqlt, 10-20

SUM function, sqls, 1-954

Supertable, sqlr, Glossary-19, sqlt, 10-20

Supertype, sqlr, Glossary-20, sqlt, 10-20

Support function,

assign, sqls, 1-793, 1-523, 1-503, 1-172

compare, sqls, 1-173

defining, sqls, 1-171

definition, sqls, 1-178

destroy, sqls, 1-377, 1-329, 1-172

export, sqls, 1-172

exportbinary, sqls, 1-172

import, sqls, 1-172

importbinary, sqls, 1-172

input, sqls, 1-171

lohandles, sqls, 1-173

output, sqls, 1-171

receive, sqls, 1-172

send, sqls, 1-172

specifying in CREATE OPCLASS, sqls, 1-178

Support functions, sqlr, Glossary-20

Symbols. See Data symbols; Formatting symbols.,

Synonym,

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, vis_ug, 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

syscasts, sqlr, 2-25

syscolattribs, sqlr, 1-20

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

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

sysprocauth, sqlr, 1-44

sysprocedures, sqlr, 1-46

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

System catalog, sqlr, 1-3 to

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

sysattrtypes, sqlr, 1-17

sysblobs table, sqlr, 1-18

syscasts, sqlr, 1-19

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

sysprocbody, sqlr, 1-45, sqlt, 14-81

systabauth, sqlt, 11-9

sysusers, sqlt, 11-9

sysviews, sqlr, 1-7, sqls, 1-569

sysxtddesc, sqlr, 1-62

sysxtdtypeauth, sqlr, 1-63

sysxtdtypes, sqlr, 1-64, sqls, 1-168

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 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 requirements, instll32, 4

database, vis_ug, Intro-5

software, vis_ug, Intro-5

SYSTEM statement,

setting environment variables with, sqls, 2-55

syntax, sqls, 2-54

System-defined cast,

definition of, sqlr, Glossary-20

See Cast, system-defined.,

System-descriptor area,

allocating memory for, sqls, 1-24

COUNT field. See COUNT field.,

DATA field. See DATA field.,

deallocating memory for, sqls, 1-299

determining number of values, sqls, 1-435

FETCH statement with, sqls, 1-419

FETCH.. USING SQL DESCRIPTOR with, sqls, 1-419

getting values from, sqls, 1-436

IDATA field. See IDATA field.,

ILENGTH field. See ILENGTH field.,

INDICATOR field. See INDICATOR field.,

item descriptors, sqls, 1-25

ITYPE field. See ITYPE field.,

LENGTH field. See LENGTH field.,

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

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 number of values, sqls, 1-705

setting with SET DESCRIPTOR, sqls, 1-702

TYPE field, sqls, 1-436, 1-437

TYPE field. See TYPE field.,

undefined, sqls, 1-705

with DESCRIBE, sqls, 1-341, 1-342

with EXECUTE...INTO, sqls, 1-390

with EXECUTE...USING, sqls, 1-394

with PUT, sqls, 1-561

systraceclasses, sqlr, 1-56

systracemsgs, sqlr, 1-57

systracemsgs information, sqlr, 1-57

systriggers, sqlr, 1-59

sysusers, sqlr, 1-60

sysviews, sqlr, 1-61

sysviolations, sqlr, 1-61

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