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 ]

G

-G preprocessor option, esqlc, 1-52, 1-65, 1-57

-g preprocessor option, esqlc, 1-52, 1-65, 1-57

Gateway, sqlr, Glossary-9

Gen_IsMMXMachine() utility function, dbdkug, 5-19, 5-20

Gen_LoadLOFromFile() utility function, dbdkug, 5-19, 5-27, 5-29

Gen_nstrwords() utility function, dbdkug, 5-19

Gen_sscanf() utility function, dbdkug, 5-19, 5-20, 5-23

Gen_StoreLOToFile() utility function, dbdkug, 5-19, 5-29

Gen_Trace() utility function, dbdkug, 5-19, 5-11

Generate DataBlade dialog box, dbdkug, 3-47

Generated files,

C code, described, dbdkug, A-1, 5-4

C++ code, described, dbdkug, B-5, B-1 to

directory saved in, dbdkug, A-1, B-1, 3-50, 6-13

file structure of, dbdkug, 3-49

format of, dbdkug, 3-50

installation package files, dbdkug, 3-55

logging, dbdkug, 3-50

merging, setting, dbdkug, 3-50

MMX support, dbdkug, 3-50

objects.sql script, dbdkug, 3-52

options for, dbdkug, 3-49

packaging, dbdkug, 10-5

prepare.sql script, dbdkug, 3-52

properties of, dbdkug, 3-50

setting properties, dbdkug, 3-49

tracing, dbdkug, 3-50

Generating,

ActiveX value objects, dbdkug, 6-13

all files, dbdkug, 3-51

files with BladeSmith, dbdkug, 3-47 to

SQL scripts, dbdkug, 3-51

test files, dbdkug, 3-54

Generic B-tree,

default operator class, extend, 4-12, 4-7

description of, extend, 4-4

extending, extend, 4-20, 4-12

new operator class, extend, 4-20

strategy functions, extend, 4-8

support functions, extend, 4-8

Gengo year format, gls, 1-17

German locale, gls, 1-27, 1-30, A-10, 1-24

GET DESCRIPTOR statement, sqls, 1-433 to

DECIMAL data type with, sqls, 1-437

EXTYPEID field with, sqls, 1-438

EXTYPELENGTH field with, sqls, 1-439

EXTYPENAME field with, sqls, 1-438

EXTYPEOWNERLENGTH field with, sqls, 1-439

getting COUNT field, esqlc, 16-14, 16-29

getting fields, esqlc, 16-10, 16-4

getting row values, esqlc, 16-14

See also System-descriptor area.,

setting COUNT field, esqlc, 16-10

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

VALUE clause, sqls, 1-436, 1-437

with OPTOFC and Deferred PREPARE features, esqlc, 14-38

X/Open mode, sqls, 1-437

GET DIAGNOSTICS statement, sqls, 1-441 to

and OPTOFC feature, esqlc, 14-36

ANSI SQL compliance, esqlc, 11-6

CLASS_ORIGIN keyword, sqls, 1-453

CONNECTION_NAME keyword, sqls, 1-457

description, esqlc, 11-7

error-checking with, sqls, 1-448

examples of use, esqlc, 11-55, 11-12, 11-9, 11-26

EXCEPTION clause, sqls, 1-451

exception information, esqlc, 11-9

INFORMIX_SQLCODE keyword, sqls, 1-453

MESSAGE_LENGTH keyword, sqls, 1-454

MESSAGE_TEXT keyword, sqls, 1-454

MORE keyword, sqls, 1-450

NUMBER keyword, sqls, 1-450

retrieving multiple exceptions, esqlc, 11-25

RETURNED_SQLSTATE field, esqlc, 11-13

RETURNED_SQLSTATE keyword, sqls, 1-453

ROW_COUNT keyword, sqls, 1-450

See also Diagnostics area.,

SERVER_NAME keyword, sqls, 1-455

SQLCODE variable, esqlc, 11-13

SQLSTATE codes, sqls, 1-445

SQLSTATE variable, esqlc, 11-12

Statement clause, sqls, 1-449

statement information, esqlc, 11-7

SUBCLASS_ORIGIN keyword, sqls, 1-454

X/Open compliance, esqlc, 11-6

GetBuffer method, dbdkug, 6-32

getcd_me sample program, esqlc, 8-15

getcd_nf sample program, esqlc, 8-27

getcd_of sample program, esqlc, 8-22

GetConnect() library function, esqlc, 12-93, 12-95

GetData method, dbdkug, 6-26

GetDataC method, dbdkug, 7-6

GetDataCpp method, dbdkug, 7-6

GL_DATE environment variable, sqls, 1-770, 1-517, esqlc, 6-63, 6-23, 1-108, 6-48, 6-6, gls_api, 4-54, 4-16

era-based dates, gls, 3-51, 1-51

ESQL library functions, gls, 7-8

precedence of, gls, 1-39, 1-51, 7-14, 1-24

sending to database server, gls, 1-32

setting, gls, 1-50

syntax, gls, 2-25

GL_DATETIME environment variable, sqls, 1-772, 1-518, esqlc, 1-108, sqlt, 9-19, gls_api, 4-62, 4-25

era-based dates, gls, 3-51

era-based dates and times, gls, 1-51

ESQL library functions, gls, 7-15

precedence of, gls, 1-39, 1-52, 7-17, 1-24

sending to database server, gls, 1-32

setting, gls, 1-50

syntax, gls, 2-35

GL_DPRINTF, dapi, 10-9

gl_dprintf() function, dbdkug, 5-11

gl_mchar_t data type, gls_api, 2-6

gl_tprintf(), dapi, 10-9

gl_wchar data type, dbdkug, 6-32, 6-28

gl_wchar_t data type, gls_api, 2-8

glfiles utility,

-cm option, gls, A-26, A-22

code-set files, gls, A-26

code-set-conversion files, gls, A-25, 1-46

-cv option, gls, A-25, A-22

-lc option, gls, A-22

locale files, gls, 1-21, A-22

sample output, gls, A-25, A-26, A-23, A-24

syntax, gls, A-21

Global ESQL/C variables, esqlc, 1-116

Global Language Support (GLS), sqlr, Intro-5, sqls, Intro-6, esqlc, Intro-4, sqlt, Intro-6, dapi, Intro-5, extend, Intro-4, udr, Intro-4

collation (sort) order, sqlt, 2-24

database, description of, sqlt, 1-17

DATETIME format, sqlt, 9-19

default locale, sqlt, 2-24

locale,

GL_COLLATE and GL_TYPE in systables, sqlr, 1-56

MATCHES with, sqlt, 2-41

SELECT...ORDER BY with, sqlt, 2-24

SQL comment symbols with, sqls, 1-13

systables information, sqlr, 1-56

Global Language Support (GLS) environment,

character data types for host variables, esqlc, 3-3

inserting character data, esqlc, 3-12, 3-15

naming host variables, esqlc, 1-28

naming indicator variables, esqlc, 1-45

transfering character data, esqlc, 3-11

Global Language Support. See GLS environment.,

Global Language Support. See GLS.,

global variable,

defined, sqlt, 14-24

Global variable, sqlr, Glossary-9

FetBufSize, esqlc, 14-23

OptMsg, esqlc, 12-43

Global variables, avoiding, dbdkug, 4-13

GLS,

identifying routines from API, dbdkug, 5-7

locale, dbdkug, 3-21, 3-10

GLS API, sqlr, Glossary-9

GLS API. See INFORMIX-GLS.,

GLS Application Programming Interface, gls, 4-18

GLS environment,

locale. See Locale.,

GLS feature,

available locales, gls, 1-29, 1-21

CHAR data type, gls, 3-17

character data types for host variables, gls, 8-6

client/server environment, gls, 1-18, 1-22

description of, gls, 1-3

environment variables, gls, 2-4

ESQL library functions, gls, 7-7

for ESQL/C SQL API, gls, 7-3, 8-3

for ESQL/COBOL SQL API, gls, 7-3

for INFORMIX-Universal Server, gls, 4-3

for OnLine database server, gls, 5-3

for SE database server, gls, 6-3

for SQL, gls, 3-3

functionality listed, gls, 1-5

fundamentals, gls, 1-3

GLS files, gls, A-15, A-18, A-19, A-9

GLS library, gls, 1-4

locales, gls, 1-7

managing GLS files, gls, A-1

NCHAR data type, gls, 3-11

NVARCHAR data type, gls, 3-13

TEXT data type, gls, 3-18

using character data types, gls, 3-11

VARCHAR data type, gls, 3-18

GLS locale. See Locale.,

GLS. See Global Language Support (GLS) environment.,

GLS. See Global Language Support.,

gls.h header file, gls_api, A-1, 2-6, 4-138, 2-8, 1-14

gls.h header file, definition of, esqlc, 1-22

GLS8BITFSYS environment variable,

for ESQL filenames, gls, 7-5

for INFORMIX-Universal Server filenames, gls, 4-5

for OnLine filenames, gls, 5-5

for SE filenames, gls, 6-4, 6-6

syntax, gls, 2-23

GRANT FRAGMENT statement, sqls, 1-480, sqlt, 9-54

AS grantor clause, sqls, 1-487

WITH GRANT OPTION clause, sqls, 1-486

GRANT statement, sqls, 1-461 to

ALL (PRIVILEGES) behavior, sqls, 1-468

ANSI compliance, sqls, 1-206

AS grantor clause, sqls, 1-478

column-specific privileges, sqls, 1-468

CREATE SCHEMA statement with, sqls, 1-206

database-level privileges, sqls, 1-463 to , sqlt, 11-5

example using signature, udr, 2-6, 3-20

example using specific name, udr, 2-6

EXECUTE ON (user-defined routine), sqls, 1-472

Execute privilege, extend, 5-19, 2-10, 2-11

grantor chain, sqls, 1-477

in embedded SQL, sqlt, 5-35 to

Resource privilege, extend, 4-19, 5-15

role name and privileges, sqls, 1-475

table-level privileges, sqls, 1-465 to , sqlt, 11-7

USAGE ON (user-defined data type), sqls, 1-471

Usage privilege, extend, 5-18

view name and privileges, sqls, 1-470

WITH GRANT OPTION clause, sqls, 1-477

Graph class, gls_api, 4-123, 4-99, 2-12, 2-13

Graphical character, gls_api, 4-123, 4-99, 2-12, 2-13

Graphical user interface, BladeManager, bldmg_ug, 2-3 to , 2-14

GreaterThan method/routine, dbdkug, 6-18, 7-9

greaterthan() function, extend, 2-6, 4-8

greaterthan() operator function, sqls, 1-1020

GreaterThanOrEqual method/routine, dbdkug, 6-18, 7-9

greaterthanorequal() function, extend, 2-6, 4-8

greaterthanorequal() operator function, sqls, 1-1020

GROUP BY keywords,

column number with, sqlt, 3-7

description of, sqlt, 3-4

restrictions in modifiable view, sqlt, 11-29

Grouping, dbdkug, 2-17

Grouping information, gls_api, 3-5, 3-6

Groupings separator. See Thousands separator.,