Master Index

Home

Index Key

[ A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Symbols ]

V

-V preprocessor option, esqlc, 1-59, 1-50

-V processor option, esqlc, 1-55

VALUE descriptor field, esqlc, 16-21

Value objects. See ActiveX value objects.,

value.h header file, esqlc, 1-24

VALUES clause. See statement containing clause.,

var binary data type,

checking for null, esqlc, 10-41, 10-31, 10-33

corresponding SQL data type, esqlc, 2-5, 2-13

deallocating data buffer, esqlc, 10-35

declaration, esqlc, 10-23

defined constant, esqlc, 2-11

fetching into, esqlc, 10-30

getting data buffer from, esqlc, 10-39

getting size of data buffer, esqlc, 10-40

inserting from, esqlc, 10-28

See also Varying-length opaque data type.,

setting data buffer, esqlc, 10-42

setting size of data buffer, esqlc, 10-44

setting to null, esqlc, 10-29, 10-46

specifying memory allocation, esqlc, 10-37

varchar data type,

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

defined constant, esqlc, 2-10

definition of, esqlc, 3-4, 3-6

fetching into, esqlc, 3-17, 2-18, 5-6, 3-11

inserting from, esqlc, 3-17, 3-18, 3-12, 3-14

role of varchar.h, esqlc, 1-24

See also VARCHAR data type; CHAR data type.,

with ANSI-compliant database, esqlc, 3-18

VARCHAR data type, sqlr, 2-69, sqls, 1-863, sqlt, 9-22

code-set conversion, gls, 1-48, 4-7

collation, sqlr, 2-70

collation order, gls, 1-11

coltype code for, sqlr, 1-24

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

data conversion, esqlc, 2-19, 3-12

defined constant, esqlc, 2-8

difference from NVARCHAR, gls, 3-14

displaying values, sqlt, 2-10

fetching, esqlc, 2-19, 3-13

GLS aspects, gls, 3-18

greater than condition, sqls, 1-1020

inserting, esqlc, 2-19, 3-14

LENGTH function, sqlt, 2-60

length in syscolumns, sqlr, 1-27

macros, esqlc, 3-7

performance considerations, gls, 3-16

role of varchar.h, esqlc, 1-24

See also varchar data type.,

See Character; Character string.,

truncating values, esqlc, 3-13, 3-15

unloading, sqls, 1-770, 1-772

with null-terminated strings, esqlc, 3-4, 3-5

varchar.h header file, esqlc, 3-7, 1-24, dapi, 1-6

Variable,

default values, sqls, 2-13, 2-14

definition of, sqlr, Glossary-22

global, sqls, 2-11

host. See Host variable.,

indicator. See Indicator variable.,

inserting values with PUT, sqls, 1-559

local, sqls, 2-10, 2-14

main, esqlc, 1-42

PROCEDURE type, sqls, 2-17

SPL, sqls, 2-8

unknown values in IF, sqls, 2-36

with same name as a keyword, sqlt, 14-22

Variable name,

'global', sqls, 1-983

'on', 'off', 'procedure', sqls, 1-982

Variable size opaque data types, dbdkug, 3-36

VARIANCE function, sqls, 1-956

Variant functions, dbdkug, 3-27

VARIANT routine modifier, sqls, 1-1031

Varying length data type,

execution time, sqlt, 9-23

Varying-length data type,

opaque data type, sqls, 1-169

Varying-length opaque data type, sqls, 1-170

declaring host variable for, esqlc, 10-23

inserting, esqlc, 10-28

See also Fixed-length opaque data type; var binary data type.,

selecting, esqlc, 10-30

VCLENGTH varchar macro, esqlc, 3-7

VCMAX varchar macro, esqlc, 3-7

VCMIN varchar macro, esqlc, 3-7

VCSIZ varchar macro, esqlc, 3-7

Vendor information, displaying, bldmg_ug, 3-14, 2-13

Version independence, esqlc, 1-90

Version information, esqlc, 1-55, 1-58

Version numbers, for a project, dbdkug, 3-10

Vertical bar (|), delimiter, sqls, 1-775, 1-523

Vertical white space, gls_api, 4-131, 4-107, 2-12, 2-13

Vertical-tab character, gls_api, 2-12

See also Vertical white space.,

vfork() system call, esqlc, 12-58

View, sqlt, 11-23 to , gls, 1-5, 1-6, 3-7, 7-6

alias. See Alias.,

base table changes with, sqls, 1-76

changes to base table, sqlt, 11-26

constraints with, sqlt, 11-31

creating, sqlt, 11-24

creating synonym for, sqls, 1-207

creating with CREATE VIEW statement, sqls, 1-289

creating with SELECT * notation, sqls, 1-290

dependencies, sqlr, 1-32, sqls, 1-383

derived data, sqlt, 11-24

description of, sqlr, Glossary-22

dropped when basis is dropped, sqlt, 11-26

dropping with DROP VIEW, sqls, 1-383

duplicate rows, sqlt, 11-30, 11-25

external table and, sqlt, 11-27

inserting rows in, sqlt, 11-30

listing with INFO statement, sqls, 1-490

loading data into, sqls, 1-515

modifying data through, sqlt, 11-29

naming conventions, sqls, 1-1053

privilege when creating, sqls, 1-290

privileges, sqls, 1-470

privileges. See Privilege, table-level.,

renamed column in, sqls, 1-569

restrictions on, sqlt, 11-26

restrictions with UNION operator, sqls, 1-645

sysdepend (dependencies), sqlr, 1-32

syssynonyms (synonym), sqlr, 1-51

syssyntable (synonym), sqlr, 1-52

sysviews information, sqlr, 1-61

typed, sqlt, 11-27

updatable, sqls, 1-293

updating, sqls, 1-781

using CHECK OPTION, sqlt, 11-31

virtual column, sqls, 1-291

View Name segment, sqls, 1-1052

Violations table, sqlr, Glossary-23

creating with START VIOLATIONS, sqls, 1-748

examples, sqls, 1-756, 1-768, 1-759

examples with object mode examples, sqls, 1-659

how to stop, sqls, 1-767

privileges on, sqls, 1-754

relationship to diagnostics table, sqls, 1-753

relationship to target table, sqls, 1-753

starting, sqls, 1-748

starting with constraint-mode and index-mode objects, sqls, 1-666

starting with filtering-mode objects, sqls, 1-653

stopping with filtering-mode objects, sqls, 1-654

structure, sqls, 1-752

use with SET, sqls, 1-653

Violations tables,

sysviolations information, sqlr, 1-61

Virtual column, sqlr, Glossary-23

Virtual processor, sqlr, Glossary-23

Virtual processors,

about, overview, 1-9

choosing for user-defined routine, udr, 5-8

classes, dbdkug, 4-5

definition, dbdkug, 4-4

documentation of, overview, A-8

identifying for debugging, dbdkug, 8-16

managing threads, dbdkug, 4-6

process ID, dbdkug, 8-16

See also User-defined virtual processors.,

shared memory, dbdkug, 4-6

yielding threads, dbdkug, 4-6

Virtual table, sqlr, Glossary-23

Visual C++,

attaching to the server process, dbdkug, 9-10

breakpoints, setting, dbdkug, 9-11

compiling with, dbdkug, 6-21, 6-23, 5-39

include files, setting, dbdkug, 5-40, 6-21

library files, setting, dbdkug, 5-40, 6-21

running the debugger, dbdkug, 9-10

stopping the server and debugger, dbdkug, 9-11

VPCLASS parameter,

user-defined classes, udr, 5-9