[ 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.