Index

A

Allocation extent size 3-48, 12-320, 12-330

ANSI compliance level Intro-10

assign() support function 3-55, 3-81, 12-231, 12-267, 12-294

mi_large_object_expand() 12-227

Attributes flag 3-48, 12-332

B

Binary representation

LO handle 3-62

BLOB data type

column-level storage characteristics 3-44

contents of 3-15

definition of 3-15

deleting 3-80

fetching 3-17, 3-61

inserting 3-18, 3-61

updating 3-18, 3-55, 3-61, 3-72

byte ordering

converting for integers 12-122

converting for smallints 12-124

bytes, copying 12-166, 12-390

C

Callback

mi_lo_invalidate() with 12-296, 12-365

callback 5-7

description 9-4

disabled 5-7

example 9-7

callbacks_enabled field

of MI_PARAMETER_INFO structure 5-7

classes

trace 10-3

client and server function compatibility 11-8

CLOB data type

column-level storage characteristics 3-44

contents of 3-15

definition of 3-15

deleting 3-80

fetching 3-17, 3-61

inserting 3-18, 3-55

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

Comment icons Intro-7

compatibility between client and server functions 11-8

Compliance with industry standards Intro-10

Configuration parameter

STACKSIZE 11-5

connecting to a database server 11-3

connection

establishing 12-443

to a database server 5-4

Constant

access 3-67

access-mode 3-65

file-mode 3-83, 12-288, 12-359

for smart large objects 3-49

NULL 1-8

open-mode 3-64

whence 12-307, 12-312, 12-370

Constants

for smart large objects 12-291

Constructor

LO-specification structure 3-34, 12-316

LO-status structure 3-76, 12-338

control flag 12-99

conversion

integer byte ordering 12-122

smallint byte ordering 12-124

copying

bytes 12-166, 12-390

double precision values 12-181, 12-395

integer values 12-184, 12-399

smallints 12-406

CREATE FUNCTION statement

setting stack size 11-5

CREATE PROCEDURE statement

setting stack size 11-5

CREATE TABLE statement 3-44, 3-46

Create-time flags 12-322

D

data types

DataBlade API types that correspond to server types 2-3

Database server session

current 12-273, 12-275, 12-281, 12-301

DataBlade API

client errors 9-12

example callback 9-7

initialization 5-3

server exceptions 9-10

DataBlade API data type

mi_boolean 2-4

mi_char 2-3

mi_char1 2-3

mi_date 2-4

mi_datetime 2-4

mi_decimal 2-4

mi_double_precision 2-3

mi_int1 2-3

mi_int8 2-3

mi_integer 2-3

mi_interval 2-4

mi_lvarchar 2-3

mi_money 2-3

mi_numeric 2-4

mi_real 2-4

mi_smallint 2-3

mi_string 2-3

mi_unsigned_char1 2-3

mi_unsigned_int8 2-3

mi_unsigned_integer 2-3

mi_unsigned_smallint 2-3

mi_wchar 2-3

DataBlade API functions

reference pages 12-28 to 12-506

datetime.h header file 1-6

decimal.h header file 1-6

default

system 5-9

default information structures 5-10

Default locale Intro-5

DELETE statement

smart large object 3-80

destroy() support function 3-81, 12-224, 12-277

Destructor

LO-specification structure 12-314

LO-status structure 12-346

Documentation conventions

icon Intro-7

typographical Intro-6

Documentation notes Intro-10

Documentation, types of

documentation notes Intro-10

error message files Intro-9

machine notes Intro-10

on-line manuals Intro-8

printed manuals Intro-9

release notes Intro-10

double precision values

copying 12-181, 12-395

DPRINTF macro 10-4

duration

PER_COMMAND 12-28

PER_FUNCTION 12-28

E

environment variables

INFORMIXSERVER 5-9

SERVERNUM 5-9

en_us.8859-1 locale Intro-5

error descriptor

copying 12-90

destroying 12-91

determining if a copy 12-92

Error message files Intro-9

error messages

internationalization of 12-73

errors 9-11

event description 9-3

exception

handling 9-14

level 12-93

server 9-10

Exclamation point (!)

wildcard in smart large-object filenames 12-360

export support function 12-251

F

Feature icons Intro-8

Features, product Intro-5

Fetching

smart large object 3-17, 3-61

File

copying a smart large object to 12-358

file access 11-7

G

Global Language Support (GLS) Intro-5

GL_DPRINTF 10-9

gl_tprintf() 10-9

H

Header file

DataBlade API 1-5

datetime.h 1-6

decimal.h 1-6

ESQL/C 1-6

int8.h 1-6

locator.h 1-6

miconv.h 1-5

milib.h 1-5

miloback.h 1-5

milo.h 1-5, 3-19

mitrace.h 1-5

mitypes.h 1-5

mi.h 1-5

sqlca.h 1-6

sqlda.h 1-6

sqlhdr.h 1-6

sqlstype.h 1-6

sqltypes.h 1-6

sqlxtype.h 1-6

stddef.h 1-8

varchar.h 1-6

I

Icons

comment Intro-7

feature Intro-8

platform Intro-8

Illustra large-object interface 2-6, 3-17

import support function 12-267

Industry standards, compliance with Intro-10

INFORMIXSERVER

default value of 5-9

description 5-9

initialization 5-3

DataBlade API 12-443

INSERT statement

smart large object 3-18, 3-55

Inserting

smart large object 3-18, 3-55

int8.h header file 1-6

integer values

copying 12-184, 12-399

internationalization

of error messages 12-73

ISO 8859-1 code set Intro-5

L

library errors 9-11

LO file descriptor

creating 12-272, 12-275, 12-280, 12-288, 12-301

deallocating 3-70, 12-264

declaring 3-23

description 7-12

description of 1-7, 3-20, 3-22

functions for 3-25

obtaining 3-50, 3-53, 3-75

LO handle

allocating 3-52

binary representation 3-62

checking validity of 12-365

comparing 12-302

converting to binary 12-293

converting to text 12-362

deallocating 3-56, 12-309

declaring 3-22

deleting from a database 3-80

description 7-12

description of 1-7, 3-8, 3-20, 3-21

fetching from a database 3-17

functions for 3-26

in BLOB column 3-15

in CLOB column 3-15

in DELETE 3-80

in INSERT 3-18, 3-55

in opaque data type 3-16

in SELECT 3-17, 3-61

in UPDATE 3-18, 3-55, 3-73

invalidating 12-296

memory duration 3-56, 3-82

memory duration of 3-52

obtaining 3-50, 3-51

representations of 3-62

retrieving from client 12-187

selecting from a database 3-61

sending to client 12-402

storing in a database 3-18, 3-55, 3-73

text mode 3-62

updating 3-73

valid 3-63

validating 3-63

LO seek position

current 12-304, 12-367

definition of 3-22, 12-354

initial 3-22

initializing 12-300

obtaining 3-53, 3-69, 12-354

read operations 3-66, 3-69

specifying 3-53, 3-69, 12-307, 12-311, 12-370

write operations 3-53, 3-66

Locale Intro-5

locator.h header file 1-6

Lock

exclusive 3-68, 3-70, 12-263

share mode 3-68

share-mode 3-70

update mode 3-68, 3-70

Locking

smart large objects 3-68

Logging behavior (smart large object)

altering 3-73

description of 3-11

setting 3-42

system-specified storage characteristics 3-43

lohandles() support function 12-299, 12-365

LO-specification structure

allocating 3-34, 3-35, 12-316

allocation extent size 3-48, 12-320, 12-330

attributes flag 3-48, 12-332

constructor 3-34, 12-316

create-time flags 12-322

deallocating 3-56, 12-314

declaring 3-21, 3-23

description of 1-7, 3-20, 3-21

destructor 12-314

disk-storage information 3-47

estimated size 3-47, 12-318, 12-328

functions for 3-28

initializing 12-317

last-access time indicators 3-49

logging indicators 3-49

maximum size 3-47, 12-324, 12-334

memory duration 3-56

memory duration of 3-34

obtaining 3-33

sbspace name 3-48, 12-326, 12-336

setting fields of 12-266, 12-268

storage characteristics 3-37

LO-status structure

allocating 3-76, 3-77, 12-338

constructor 12-338

deallocating 3-80, 12-346

description of 1-8, 3-20, 3-23

destructor 12-346

functions for 3-30

initializing 12-339

last-access time 3-78, 12-340

last-change time 3-78, 12-344

last-modification time 3-78, 12-348

memory duration 3-80

memory duration of 3-76

obtaining 3-76

reference count 3-78, 12-350

size 3-78, 12-352

storage characteristics 3-78, 12-342

M

Machine notes Intro-10

Major features Intro-5

Memory allocation

LO file descriptor 3-23

LO handle 3-51, 12-309

LO-specification structure 3-34, 12-316

LO-status structure 3-76, 3-77, 12-338

MI_LO_LIST structure 12-298

memory allocation

setting duration 12-28, 12-67

Memory duration

LO handle 3-52, 3-56, 3-82

LO-specification structure 3-34, 3-56

LO-status structure 3-76, 3-80

Memory management

deallocating resources 3-55

stack space 11-5

memory management 11-4

message type 9-10

miconv.h header file 1-5

milib.h file

description 1-5

milib.h header file

required for string-text conversions routines 2-5

miloback.h header file 1-5

milo.h header file 1-5, 3-19

access constants 3-67

access-mode constants 3-65

buffering-mode constants 3-67

create-time constants 3-49

LO file descriptor 3-23

LO handle 3-22

LO-specification structure 3-21

LO-status structure 3-23

open-mode constants 3-64

mitrace.h header file 1-5

mitypes.h header file

description 1-5

required with mi_alloc() 12-29, 12-68

mi.h header file 1-5, 3-19

mi_alloc() 4-8, 7-11, 11-4, 12-28

default duration 12-28

in client applications 12-29

in server applications 12-29

MI_All_Events event type 9-3, 9-6

MI_ASYNC_ACTION 1-7

mi_binary_query() 12-34

mi_binary_to_datetime() 12-31

mi_binary_to_date() 12-30

mi_binary_to_decimal() 12-32

mi_binary_to_money() 12-33

mi_boolean data type 2-4

mi_call() 11-5, 12-35

mi_cast_get() 12-36

MI_CB_CONTINUE 9-5

MI_CB_EXC_HANDLED 9-5

MI_CB_EXC_HANDLED status code 9-14

mi_char data type 2-3

mi_char1 data type 2-3

mi_client() 12-38

MI_Client_Library_Error event type 9-3, 9-12

mi_client_locale 5-4

mi_client_locale() 12-39

mi_close() 5-5, 5-7, 12-40

mi_close_statement() 12-41

mi_collection_close() 12-42

mi_collection_create() 12-43

mi_collection_delete() 12-44

mi_collection_fetch() 12-46

mi_collection_free() 12-49

mi_collection_insert() 12-50

mi_collection_open() 12-52

mi_collection_update() 12-53

MI_COLLECTION_VALUE value constant 12-496

mi_column_count() 7-7, 7-8, 12-55

mi_column_id() 7-7, 12-56

mi_column_name() 7-7, 12-57

mi_column_nullable 7-7

mi_column_nullable() 12-58

mi_column_precision 7-7

mi_column_precision() 12-59

mi_column_scale 7-7

mi_column_scale() 12-61

mi_column_typedesc 7-7

mi_column_typedesc() 12-63

mi_column_type_id() 7-7, 12-62

mi_command_is_finished() 12-64

MI_CONNECTION 1-7

MI_CONNECTION structure 5-4

MI_CONNECTION_INFO 1-7, 12-169, 12-179

MI_CONNECTION_INFO structure

definition 12-169

populating 5-8

mi_convert_from_codeset() 12-65

mi_convert_to_codeset() 12-66

mi_dalloc() 7-11, 12-67

in client applications 12-67

in server applications 12-67

MI_DATABASE_INFO 1-7

MI_DATABASE_INFO structure 5-7

definition 12-172

description 5-7

populating 5-8

mi_date data type 2-4

mi_datetime data type 2-4

mi_datetime_to_binary() 12-70

mi_date_to_binary() 12-69

MI_DATUM value 2-8

LO handle 3-61

mi_dbcreate() 12-76

mi_dbdrop() 12-78

mi_db_error_raise() 9-12, 12-71

MI_DDL 12-195, 12-415

mi_decimal data type 2-4

mi_decimal_to_binary() 12-80

mi_default_callback() 9-5, 12-81

mi_disable_callback() 12-83

MI_DML 12-195, 12-415, 12-416

mi_double_precision data type 2-3

mi_drop_prepared_statement() 12-85

mi_enable_callback() 12-86

mi_errmsg() 12-88

MI_ERROR 9-14, 12-195

MI_ERROR_DESC 1-7

copying 12-90

destroying 12-91

determining if a copy 12-92

mi_error_desc_copy() 12-90

mi_error_desc_destroy() 12-91

mi_error_desc_is_copy() 12-92

mi_error_level() 12-93

mi_error_sqlcode() 12-95

mi_error_sql_state() 12-97

MI_EVENT_END_SESSION event type 9-4

MI_EVENT_END_STMT event type 9-4

MI_EVENT_TYPE 1-7, 9-3

MI_EXCEPTION 9-10, 12-72

MI_Exception 9-5

MI_Exception event type 9-3, 9-10

mi_exec() 6-3, 12-99

mi_exec() function 3-55, 3-61

mi_exec_prepared_statement() 6-3, 12-101

mi_exec_prepared_statement() function 3-55, 3-61

mi_fetch_statement() 12-104

mi_file_allocate() 12-106

mi_file_close() 12-107

mi_file_open() 12-108

mi_file_read() 12-110

mi_file_seek() 12-111

mi_file_sync() 12-113

mi_file_tell() 12-114

mi_file_to_file() 12-115

mi_file_to_file() function 3-83

mi_file_to_large_object() 12-118

mi_file_unlink() 12-120

mi_file_write() 12-121

mi_fix_integer() 12-122

mi_fix_smallint() 12-124

MI_FPARAM 4-3

MI_FPARAM structure

in support functions 12-267

mi_fparam_allocate() 12-158

mi_fparam_copy() 12-159

mi_fparam_free() 12-161

mi_fparam_get() 12-162

mi_fp_argisnull() 12-125

mi_fp_arglen() 12-126

mi_fp_argprec() 12-127

mi_fp_argscale() 12-128

mi_fp_argtype() 12-129

mi_fp_funcstate() 4-8, 12-130

mi_fp_getcolid() 12-131

mi_fp_getcolid() function 12-267

mi_fp_getrow() 12-132

mi_fp_getrow() function 12-267

mi_fp_nargs() 12-133

mi_fp_nrets() 12-134

mi_fp_request() 12-135

mi_fp_retlen() 12-136

mi_fp_retprec() 12-137

mi_fp_retscale() 12-138

mi_fp_rettype() 12-139

mi_fp_returnisnull() 12-140

mi_fp_setargisnull() 12-141

mi_fp_setarglen() 12-142

mi_fp_setargprec() 12-143

mi_fp_setargscale() 12-144

mi_fp_setargtype() 12-145

mi_fp_setfuncid() 12-147

mi_fp_setfuncstate() 12-148

mi_fp_setisdone() 12-149

mi_fp_setnargs() 12-150

mi_fp_setnrets() 12-151

mi_fp_setretlen() 12-152

mi_fp_setretprec() 12-153

mi_fp_setretscale() 12-154

mi_fp_setrettype() 12-155

mi_fp_setreturnisnull() 12-156

mi_fp_usr_fparam() 12-157

mi_free() 11-4, 12-163

in client applications 12-29, 12-67

when required 12-29, 12-67

mi_free() function 3-56

mi_get_bytes() 12-166

mi_get_client_home() 12-168

mi_get_connection_info() 5-8, 12-169

mi_get_connection_user_data() 12-171

mi_get_database_info() 5-8, 12-172

mi_get_datetime() 12-175

mi_get_date() 12-174

mi_get_dbnames() 12-176

mi_get_decimal() 12-178

mi_get_default_connection_info 5-8

mi_get_default_connection_info() 5-3, 12-179

mi_get_default_database_info() 5-4, 5-8, 12-180

mi_get_double_precision() 12-181

mi_get_int8() 12-183

mi_get_integer() 12-184

mi_get_interval() 12-186

mi_get_lo_handle() function 12-187

mi_get_money() 12-189

mi_get_next_sysname() 5-4, 12-190

mi_get_parameter_info() 5-3, 5-8, 12-191

mi_get_real() 12-193

mi_get_result() 7-3, 8-3, 12-194, 12-377

example of 7-4

mi_get_row_desc() 7-6, 12-196

mi_get_row_desc_from_type_desc() 12-198

mi_get_row_desc_without_row() 7-6, 7-8, 12-199

mi_get_smallint() 12-201

mi_get_statement_row_desc() 12-203

mi_get_string() 12-204

mi_get_type_source_type() 12-205

mi_get_vardata() 2-5, 12-206

mi_get_vardata_align() 2-5, 12-207

mi_get_varlen() 2-5, 12-208

mi_init_library() 5-3, 12-209

mi_int1 data type 2-3

mi_int8 data type 2-3

mi_integer data type 2-3

mi_interrupt_check() 12-210

mi_interval data type 2-4

mi_issmall_data() 12-211

mi_large_object_close() function 12-212

mi_large_object_copy() function 12-214

argument values used for external files 12-215

argument values used for smart large objects 12-215

mi_large_object_copy_opts() function 12-217

argument values used for external files 12-218

argument values used for smart large objects 12-218

mi_large_object_create() function 12-220

mi_large_object_create_opts() function 12-222

mi_large_object_decrefcount() function 12-224

mi_large_object_expand() function 12-226

mi_large_object_filename() function 12-228

mi_large_object_increfcount() function 12-231

mi_large_object_info() function 12-233

mi_large_object_map() function 12-235

mi_large_object_open() function 12-237

mi_large_object_pin() function 12-239

mi_large_object_readwithseek() function 12-243

mi_large_object_read() function 12-241

mi_large_object_seek() function 12-245

mi_large_object_stat() function 12-247

mi_large_object_tell() function 12-249

mi_large_object_to_file() function 12-250

mi_large_object_unmap() function 12-253

mi_large_object_unpin() function 12-254

mi_large_object_write() function 12-255

mi_last_serial8() function 12-259

mi_last_serial() function 12-257

mi_library_version() 12-261

MI_LIB_BADARG 9-12

MI_LIB_BADSERV 9-12

MI_LIB_DROPCONN 9-12, 12-445

MI_LIB_INTERR 9-12

MI_LIB_NOIMP 9-12

MI_LIB_USAGE 9-12

MI_LODESC 1-7

MI_LODESC data type 12-238

mi_login() 5-7, 12-372

MI_LOHANDLE

data structure 1-7

MI_LOHANDLE data type

mi_large_object_copy() parameter 12-214

mi_large_object_copy_opts() parameter 12-217

mi_large_object_decrefcount() parameter 12-224

mi_large_object_filename() parameter 12-228

mi_large_object_increfcount() parameter 12-231

mi_large_object_info() parameter 12-233

mi_large_object_to_file() parameter 12-214, 12-217, 12-250

MI_LOINFO 1-7

MI_LOINFO structure 12-233

MI_LOSTAT 1-8

MI_LOSTAT structure 12-248

mi_lo_alter() function 3-73, 12-262

MI_LO_APPEND access-mode constant 3-65, 3-66, 3-68, 12-237

MI_LO_ATTR_KEEP_LASTACCESS_TIME create-time constant 3-49, 3-78, 12-262, 12-340

MI_LO_ATTR_LOG create-time constant 3-49, 12-262

MI_LO_ATTR_NOKEEP_LASTACCESS_TIME create-time constant 3-49, 12-262

MI_LO_ATTR_NO_LOG create-time constant 3-49, 12-262

MI_LO_BUFFER buffering-mode constant 3-67

mi_lo_close() function 3-70, 12-264

mi_lo_colinfo_by_ids() function 3-45, 12-266

mi_lo_colinfo_by_name() function 3-45, 12-268

mi_lo_copy() function 3-24, 3-39, 3-63, 3-64, 3-66, 3-67, 12-271

mi_lo_create() function 3-24, 3-39, 3-63, 3-64, 3-66, 3-67, 12-274

mi_lo_decrefcount() function 3-81, 12-277

MI_LO_DEFAULT_SMGR

mi_file_to_large_object() parameter 12-118

mi_large_object_copy() parameter 12-214

mi_large_object_copy_opts() parameter 12-217

mi_large_object_create() parameter 12-220

mi_large_object_create_opts() parameter 12-222

mi_large_object_expand() parameter 12-226

MI_LO_DIRTY_READ access-mode constant 3-68

mi_lo_expand() function 3-24, 3-39, 3-63, 3-64, 3-66, 3-67, 12-279

MI_LO_FD data type 1-7, 3-20, 3-22

mi_lo_filename() function 3-83, 12-282

mi_lo_from_buffer() function 12-284

mi_lo_from_file() function 3-24, 3-39, 3-63, 3-83, 12-286

mi_lo_from_file_by_lofd() function 3-83, 12-290

mi_lo_from_string() function 3-62, 12-293

MI_LO_HANDLE data type 1-7, 3-20, 3-21, 3-62

description of 1-7

mi_lo_increfcount() function 3-81, 12-294

MI_LO_INTERNAL_LO constant 12-214, 12-217, 12-220, 12-222

mi_lo_invalidate() function 3-63, 3-80, 12-296

MI_LO_LIST structure 12-298

mi_lo_lolist_create() function 12-298

MI_LO_MAP_PRIVATE constant 12-235

MI_LO_NOBUFFER buffering-mode constant 3-67

MI_LO_NOSMGR

mi_large_object_copy() parameter 12-215, 12-217

mi_large_object_create() parameter 12-118, 12-220

mi_large_object_create_opts() parameter 12-222

mi_large_object_expand() parameter 12-226

mi_lo_open() function 3-63, 3-64, 3-66, 12-300

MI_LO_PROT_READ constant 12-235

MI_LO_PROT_WRITE constant 12-235

mi_lo_ptr_cmp() function 12-302

MI_LO_RANDOM access constant 3-67

MI_LO_RDONLY access-mode constant 3-65, 3-66, 3-68, 12-237

MI_LO_RDWR access-mode constant 3-65, 3-66, 3-68, 12-287

mi_lo_readwithseek() 12-306

mi_lo_readwithseek() function 3-69

mi_lo_read() function 3-69, 12-304

mi_lo_release() function 3-56, 12-309

mi_lo_seek() function 3-53, 3-69, 12-311

MI_LO_SEEK_CUR whence constant 12-307, 12-312, 12-370

MI_LO_SEEK_END whence constant 12-307, 12-312, 12-370

MI_LO_SEEK_SET whence constant 12-307, 12-312, 12-370

MI_LO_SEQUENTIAL access constant 3-67

MI_LO_SIZE constant 3-62

MI_LO_SPEC structure 1-7, 3-20, 3-21

mi_lo_specget_estbytes() function 3-47, 12-318

mi_lo_specget_extsz() function 3-48, 12-320

mi_lo_specget_flags() function 3-49, 12-322

mi_lo_specget_maxbytes() function 3-47, 12-324

mi_lo_specget_sbspace() function 3-48, 12-326

mi_lo_specset_estbytes() function 3-47, 12-328

mi_lo_specset_extsz() function 3-48, 12-330

mi_lo_specset_flags() function 3-49, 12-332

mi_lo_specset_maxbytes() function 3-47, 12-334

mi_lo_specset_sbspace() function 3-48, 12-336

mi_lo_spec_free() function 3-56, 12-314

mi_lo_spec_init() function 3-34, 3-35, 3-38, 12-316

MI_LO_STAT structure 1-8, 3-20, 3-23

mi_lo_stat() function 3-76, 3-79, 12-338

mi_lo_stat_atime() function 3-78, 12-340

mi_lo_stat_cspec() function 3-36, 3-78, 12-342

mi_lo_stat_ctime() function 3-78, 12-344

mi_lo_stat_free() function 3-80, 12-346

mi_lo_stat_mtime_sec() function 3-78, 12-348

mi_lo_stat_refcnt() function 3-78, 3-81, 12-350

mi_lo_stat_size() function 3-78, 12-352

mi_lo_tell() function 3-53, 3-69, 12-354

mi_lo_to_buffer() function 12-356

mi_lo_to_file() function 3-83, 12-282, 12-358

mi_lo_to_string() function 12-362

MI_LO_TRUNC access-mode constant 3-65, 3-68

mi_lo_truncate() function 12-363

mi_lo_validate() function 3-63, 12-365

mi_lo_writewithseek() function 3-53, 12-369

mi_lo_write() function 3-53, 12-367

MI_LO_WRONLY access-mode constant 3-65, 3-66, 3-68

mi_lvarchar data type 2-3

mi_lvarchar_to_string() 12-374

MI_MEMORY_DURATION 12-459

MI_MESSAGE 9-10, 12-72

mi_money data type 2-3

mi_money_to_binary() 12-375

MI_MULTIREP_DATA 1-8

MI_MULTIREP_LARGE. 12-211

mi_new_var() 2-5, 12-376

mi_next_row() 7-7, 7-9, 8-3, 12-377

MI_NORMAL_VALUE 7-11

MI_NORMAL_VALUE value constant 12-496

MI_NO_MORE_RESULTS 12-194, 12-195

MI_NULL_VALUE value constant 12-496

mi_numeric data type 2-4

mi_open() 5-3, 5-7, 12-379

mi_open_prepared_statement() 12-381

MI_O_APPEND access-mode constant 12-291

MI_O_APPEND file-mode constant 3-83, 12-288, 12-359

MI_O_BINARY file-mode constant 12-359

MI_O_CLIENT_FILE file-location constant 12-291

MI_O_CLIENT_FILE file-mode constant 12-288, 12-359

MI_O_EXCL access-mode constant 12-291

MI_O_EXCL file-mode constant 3-83, 12-288, 12-359

MI_O_RDONLY access-mode constant 12-291

MI_O_RDONLY file-mode constant 3-83, 12-288

MI_O_RDWR access-mode constant 12-291

MI_O_RDWR file-mode constant 3-83, 12-288, 12-359

MI_O_SERVER_FILE file-location constant 12-291

MI_O_SERVER_FILE file-mode constant 3-83, 12-288, 12-359

MI_O_TEXT access-mode constant 12-291

MI_O_TEXT file-mode constant 3-83, 12-288, 12-359

MI_O_TRUNC access-mode constant 12-291

MI_O_TRUNC file-mode constant 3-83, 12-288, 12-359

MI_O_WRONLY file-mode constant 3-83, 12-359

mi_parameter_count() 12-383

MI_PARAMETER_INFO 1-8, 12-452

MI_PARAMETER_INFO structure

definition 12-191

description 5-7

populating 5-8, 12-191

setting fields in 5-8

mi_parameter_nullable() 12-384

mi_parameter_precision() 12-385

mi_parameter_scale() 12-386

mi_parameter_type_id() 12-387

mi_parameter_type_name() 12-388

mi_pointer data type 2-4

mi_prepare() 12-389

MI_PROC_CALLBACK 9-8

mi_put_bytes() 12-390

mi_put_datetime() 12-393

mi_put_date() 12-392

mi_put_decimal() 12-394

mi_put_double_precision() 12-395

mi_put_int8() 12-397

mi_put_integer() 12-399

mi_put_interval() 12-401

mi_put_lo_handle() function 12-402

mi_put_money() 12-404

mi_put_real() 12-405

mi_put_smallint() 12-406

mi_put_string() 12-408

mi_query_finish() 6-3, 12-410

mi_query_interrupt() 12-412

mi_real data type 2-4

mi_register_callback() 5-3, 9-5, 9-10, 12-413

mi_result_command_name() 7-4, 12-415

example of 7-4

mi_result_row_count() 7-4, 12-416

example of 7-4

mi_retrieve_callback() 12-417

mi_routine_end() 12-419

mi_routine_exec() 12-420

mi_routine_get() 12-421

mi_routine_get_by_typeid() 12-423

MI_ROW 1-8

MI_ROWS 7-6, 12-195, 12-377

mi_row_create() 12-427

MI_ROW_DESC 1-8

MI_ROW_DESC structure

description 7-6

mi_row_desc_create() 12-429

mi_row_desc_free() 12-430

mi_row_free() 12-431

MI_ROW_VALUE 7-11

MI_ROW_VALUE value constant 12-496

MI_SAVE_SET 1-8

mi_save_set_count() 8-6, 12-432

mi_save_set_create() 8-3, 12-433

mi_save_set_delete() 8-3, 12-435

mi_save_set_destroy() 8-9, 12-436

mi_save_set_get_first() 8-6, 12-437

mi_save_set_get_last() 12-438

mi_save_set_get_next() 8-6, 12-439

mi_save_set_get_previous() 8-6, 12-440

mi_save_set_insert() 8-3, 8-4, 12-441

mi_save_set_member() 8-6, 12-442

mi_server_connect() 5-3, 5-7, 12-443

mi_server_reconnect() 12-445

mi_set_connection_user_data() 12-447

mi_set_default_connection_info() 5-4, 5-8, 12-448

mi_set_default_database_info() 5-4, 5-8, 12-450

mi_set_large() 12-451

mi_set_parameter_info() 5-3, 5-8, 12-452

mi_set_vardata() 2-6, 12-453

mi_set_vardata_align() 2-6, 12-454

mi_set_varlen() 2-6, 12-455

mi_set_varptr() 12-456

mi_smallint data type 2-3

mi_statement_command_name() 12-457

mi_string data type 2-3

mi_string_to_lvarchar() 12-458

mi_switch_memory_duration() 7-11

mi_switch_mem_duration() 4-8, 12-459

mi_sysname() 5-3, 12-461

mi_td_cast_get() 12-462

mi_tracefile_set() 10-6, 12-464

mi_tracelevel_set() 10-6, 12-466

mi_transition_type() 9-6, 12-468

mi_typedesc_typeid() 12-480

mi_typeid_equals() 12-481

mi_typeid_is_collection() 12-482

mi_typeid_is_complex() 12-483

mi_typeid_is_distinct() 12-484

mi_typeid_is_list() 12-485

mi_typeid_is_multiset() 12-486

mi_typeid_is_row() 12-487

mi_typeid_is_set() 12-488

mi_typename_to_id() 12-489

mi_typename_to_typedesc() 12-490

mi_typestring_to_id() 12-491

mi_typestring_to_typedesc() 12-492

mi_type_align() 12-469

mi_type_byvalue() 2-4, 12-470

mi_type_element_typedesc() 12-471

mi_type_full_name() 12-472

mi_type_length() 12-473

mi_type_maxlength() 12-474

mi_type_owner() 12-475

mi_type_precision() 12-476

mi_type_scale() 12-477

mi_type_typedesc() 12-478

mi_type_typename() 12-479

mi_unregister_callback() 9-5, 12-493

mi_unsigned_char1 data type 2-3

mi_unsigned_int8 data type 2-3

mi_unsigned_integer data type 2-3

mi_unsigned_smallint data type 2-3

mi_value() 7-8, 7-9, 12-494

mi_value() function 3-61

mi_value_by_name() 12-497

mi_var_copy() 2-5, 12-499

mi_var_free() 2-5, 12-500

mi_var_to_buffer() 12-501

mi_wchar data type 2-3

MI_XACT_ABORT 12-504

MI_XACT_BEGIN 12-504

MI_XACT_END 12-504

mi_xact_levels() 12-502

mi_xact_state() 12-504

MI_Xact_State_Change event type 9-4, 12-504

mi_yield() 12-505

mi_zalloc() 12-506

Multirepresentational data

accessing data 12-239

converting to smart large object 12-279

__myErrors__ trace class 10-7

N

Named row

retrieving individual values from 12-496

named rows

retrieving individual values from 12-498

NULL constant 1-8, 3-34, 3-52, 3-76

O

On-line manuals Intro-8

onspaces database utility 3-42

Opaque data type

contents of 3-16

definition of 3-16

fetching 3-17

inserting 3-18

smart large object in 3-16

smart large objects in 12-231, 12-251

updating 3-18

Opaque-type support function

assign() 3-81, 12-227, 12-231, 12-267, 12-294

destroy() 3-81, 12-224, 12-277

export 12-251

import 12-267

lohandles() 12-299, 12-365

operating-system file access 11-7

P

parameter information, getting 12-191

PER_COMMAND duration 12-28

PER_FUNCTION duration 12-28

Platform icons Intro-8

pointers 5-8

pointer_checks_enabled field

of MI_PARAMETER_INFO structure 5-8

Printed manuals Intro-9

Q

Question mark (?)

wildcard in smart large-object filenames 12-360

R

reconnecting 12-445

Reference count 3-14, 3-55, 3-78, 3-80, 3-81, 12-231, 12-350

decrementing 12-224, 12-277

Release notes Intro-10

Routine modifier

STACK 11-5

S

save sets 8-3 to 8-9

creating 12-433

getting final element 12-438

getting first row 12-437

Sbspace

getting name of 12-326

running out of space 12-368, 12-370

setting 12-336

sbspace

definition of 3-7

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

name of 3-48

status information 3-13

storage characteristics for 3-43

user-data area 3-7, 3-12

SBSPACENAME configuration parameter 3-41, 3-44

SELECT statement

fetching smart-large-object data 3-61

smart large object 3-17, 3-61

server

connection to 11-3

server connection 5-4

server exception 9-10

server functions

developing 11-3

memory management 11-4

transactions and 11-4

SERVERNUM

default value of 5-9

description 5-9

smallint values

copying 12-406

Smart large object

access flags 3-66

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

access-mode flags 3-64

altering 3-73

attributes 3-11, 3-48

buffering-mode flags 3-67

closing 3-70

creating 3-32

data structures 2-6, 3-20

definition of 3-5

estimated size 3-41, 3-47

extent size 3-10, 3-41, 3-48

fetching 3-61

in opaque data type 3-16

information about 3-8

inserting 3-18, 3-55

interfaces for 2-6, 3-17

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

last-change time 3-14, 3-78

last-modification time 3-14, 3-78

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

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

locking 3-68, 3-69

logging of 3-11, 3-49

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

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

maximum I/O block size 3-41

maximum size 3-47

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

minimum extent size 3-41

modifying 3-72

next-extent size 3-10, 3-41

obtaining status of 3-74

open mode 3-22, 3-63

opening 3-63

optimizer 3-9

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

reading from 3-69

reference count 3-14, 3-78

sample program 3-57, 3-71

sbspace 3-7

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

selecting 3-17, 3-61

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

status information 3-13

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

storing 3-18, 3-55

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

transactions with 3-11

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

user data 3-13, 3-14

writing to 3-53

Smart large-object data type

allocation extent size 12-320, 12-330

altering 12-262

attributes flag 12-332

closing 12-264

comparing 12-302

copying 12-271

copying to storage manager 12-215, 12-218

create-time flags 12-322

creating 12-220

decrementing reference count 12-277

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

estimated size 12-318, 12-328

getting size of 12-352

hexadecimal identifier for 12-359

last-access time 12-340

last-change time 12-344

last-modification time 12-348

locking 12-264

maximum size 12-324, 12-334

obtaining status of 12-338

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

reading from 12-304, 12-306

reference count 12-350

sbspace 12-326, 12-336

specifying the pathname of 12-228, 12-250

temporary smart large objects 12-309

truncating 12-363

writing to 12-367, 12-369

Smart-large-object data type

definition of 3-16

Smart-large-object optimizer 3-9

Software dependencies Intro-5

SQL

status codes 9-13

SQL data type

BLOB 3-15

CLOB 3-15

opaque 3-16

sqlca.h header file 1-6

SQLCODE value 12-95

sqlda.h header file 1-6

sqlhdr.h header file 1-6

SQLSTATE value 12-95

sqlstype.h header file 1-6

sqltypes.h header file 1-6

sqlxtype.h header file 1-6

STACK routine modifier 11-5

STACKSIZE configuration parameter 11-5

status code 9-13

Status information

last-access time 3-13

last-change time 3-14

last-modification time 3-14

location of 3-8

reference count 3-14

size 3-14

storage characteristics 3-13

stddef.h header file 1-8

Storage characteristics

altering 3-73, 12-262

choosing 3-37

column-level 3-44, 12-266, 12-268

create-time flags 3-48

definition of 3-8

disk-storage information 3-9, 3-47

functions for 3-28

hierarchy 3-40

hierarchy of 3-40

initializing new 3-34

location of 3-8

obtaining 3-13, 3-78, 12-342

specifying 3-21

system default 3-41, 3-42

system-level 12-317

system-specified 3-35, 3-42

user-specified 3-46

string

support for 2-4

Structure

MI_FPARAM 4-3

MI_LO_LIST 12-298

MI_LO_SPEC 1-7, 3-20, 3-21

MI_LO_STAT 1-8, 3-20, 3-23

structures

default information 5-10

syscolattribs system catalog table 3-44

syserrors system catalog 12-73

system defaults 5-9

system parameters 5-11

System-specified storage characteristics 3-42

systraceclasses system catalog table 10-3

systracemsgs system catalog table 10-8

T

text

support for 2-4

tf() 10-4, 10-5

tprintf() 10-4, 10-5

trace classes 10-3

tracing 10-3

Transaction

smart large objects in 3-11, 3-68

transaction state changes 9-6

transactions

and server functions 11-4

U

Universal Server smart-large-object interface 2-6, 3-17, 3-19

UPDATE statement

smart large object 3-18, 3-55, 3-73

V

varchar.h header file 1-6

W

Wildcard character

exclamation point (!) 12-360

question mark (?) 12-360

with smart large-object filenames 12-360

X

X/Open compliance

level Intro-10