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 ]

P

-p preprocessor option, esqlc, 1-55

Packaging a DataBlade module with BladePack, dbdkug, 10-9

Packaging DataBlade modules, documentation of, overview, A-7

Pad, sqlr, Glossary-14

Page, sqlr, Glossary-14

Page lock,

effect on index, sqlt, 7-10

Parallel database query, dbdkug, 3-28

Parallel distributed queries,

priority level (PDQPRIORITY), sqlr, 3-58

Parallel distributed query. SeePDQ.,

Parallel sorting threads (PSORT_NPROCS), sqlr, 3-60

Parallelism, sqlr, Glossary-14

Parallelizable routines, dbdkug, 3-28

Parameter, sqlr, Glossary-14

parameter information, getting, dapi, 12-191

PARAMETER keyword, esqlc, 16-62, 1-40, 14-19

Parameterized non-SELECT statements, esqlc, 17-43, 14-52, 16-46, 15-26

Parameterized SELECT statements, esqlc, 17-41, 17-32, 16-43, 14-54, 16-36, 15-26

Parameters in error messages, dbdkug, 3-21

Parent-child relationship, sqls, 1-236, 1-70

Parenthesis symbol, esqlc, 5-31

Partial characters, gls, 7-25, 3-36

PASSWORD network parameter, esqlc, 1-107, 12-14

PATH environment variable, sqlr, 3-58, esqlc, B-2, 1-97, dbdkug, 8-4

required, esqlc, 1-10

Pathname, gls, 4-4, 5-4

C compiler (INFORMIXC), sqlr, 3-44

database server (DBPATH), sqlr, 3-31

executable programs (PATH), sqlr, 3-58

installation (INFORMIXDIR), sqlr, 3-47

message files (DBLANG), sqlr, 3-28

parallel sorting (PSORT_DBTEMP), sqlr, 3-60

remote shell (DBREMOTECMD), sqlr, 3-35

PDQ,

optimizing joins (OPTCOMPIND), sqlr, 3-57

prioritizing (PDQPRIORITY), sqlr, 3-58

SET PDQPRIORITY statement, sqls, 1-735

with SET EXPLAIN, sqls, 1-719

PDQPRIORITY environment variable, sqls, 1-735

PER_COMMAND duration, dapi, 12-28

PER_FUNCTION duration, dapi, 12-28

PERCALL_COST routine modifier, sqls, 1-1030

Percent symbol (%), gls_api, 3-10

Performance,

advancing pointer, gls_api, 4-140

buffered log, sqlt, 9-40

case conversion, gls_api, 2-20

code-set conversion, gls_api, 2-28

depends on concurrency, sqlt, 7-3

improving, gls_api, 1-23

INFORMIX-GLS library optimization, gls_api, 1-23

wide-character processing, gls_api, 1-24

Performance issues, documentation of, overview, A-8

Period (.) symbol, esqlc, 9-74, 5-30

Permission, sqlr, Glossary-14

running operating-system command from a routine, sqls, 2-55

See Privilege.,

Permissions,

dynamic link library, on, dbdkug, 9-5

shared object files, on, dbdkug, 8-5

Persistence, dbdkug, 6-5, 7-5

Phantom row, sqls, 1-745, 1-724

-Pi processor option, esqlc, 1-93

Platform icons, esqlc, Intro-9, gls_api, Intro-8, dapi, Intro-8, gls, Intro-8

Platform portability,

coding standards for, udr, 3-5

PLCONFIG environment variable, sqlr, 3-60

Plus (+) sign, esqlc, 5-30

Plus method/routine, dbdkug, 7-10, 6-18

plus() function, extend, 2-5

plus() operator function, sqls, 1-959

Pnt user-defined data type, dbdkug, 5-22

Pointer, sqlr, Glossary-14

POINTER data type, dbdkug, 3-15

Pointer, as host variable, esqlc, 1-39

pointer_checks_enabled field,

of MI_PARAMETER_INFO structure, dapi, 5-8

pointers, dapi, 5-8

Polymorphism, sqlr, Glossary-14, dbdkug, 2-23, udr, 3-4

Polymorphism. See Overloading routines.,

Populating tables, sqlt, 9-43

Positive method/routine, dbdkug, 7-10, 6-18

Positive sign, gls_api, 3-5, 3-6

positive() function, extend, 2-5

positive() operator function, sqls, 1-960

POSIX calls, allowed, dbdkug, 4-11

Pound (#) sign, esqlc, 5-30

POW function, sqls, 1-909

pow() built-in function, extend, 2-8

.prd file, product file, dbdkug, 10-5

Precedence,

dot notation, sqlt, 12-9

dot notation rules, sqls, 1-889

Precedence, rules for environment variables, sqlr, 3-11

Precedence. See Environment variable.,

Precision,

of date string, gls_api, 4-58

of date/time string, gls_api, 4-68

of money string, gls_api, 4-75

of number string, gls_api, 4-81

PRECISION descriptor field, esqlc, 16-6, 15-8

PRECISION field,

with DESCRIBE, sqls, 1-342

with SET DESCRIPTOR, sqls, 1-710

predefined data type, sqlr, Glossary-14

Predicate lock, sqlr, Glossary-14

Predicate, in SQL statement, dbdkug, 2-12, 2-14

Preparation,

problems with, bldmg_ug, A-3

registration from the command line, bldmg_ug, 3-9

registration with the GUI, bldmg_ug, 2-6

PREPARE statement, gls, 3-6

and sqlca.sqlerrd[0], esqlc, 11-29, 14-9

and sqlca.sqlerrd[3], esqlc, 11-30, 14-9

and sqlca.sqlerrd[4], esqlc, 11-39, 11-30, 14-9

deferred execution, sqlr, 3-55

deferring, sqls, 1-698

deferring execution of, esqlc, 14-30

description of, sqlt, 5-31

error return in SQLERRD, sqlt, 5-10

exceptions returned, esqlc, 14-9

executing, sqls, 1-385

for collection variables, sqls, 1-545, esqlc, 14-8

freeing resources with FREE, sqls, 1-431

FROM INSERT...VALUES, sqls, 1-560

in thread-safe application, esqlc, 13-22

increasing performance efficiency, sqls, 1-553

multi-statement text, sqls, 1-552, 1-553

multiple SQL statements, sqlt, 5-31

parameterizing a statement, sqls, 1-547

parameterizing for SQL identifiers, sqls, 1-549

question (?) mark as placeholder, sqls, 1-542

restrictions with SELECT, sqls, 1-544

role in dynamic SQL, esqlc, 14-5

SQLCODE value, esqlc, 11-39, 14-9

statement identifier, sqls, 1-319

statement identifier use, sqls, 1-543

syntax, sqls, 1-541

valid statement text, sqls, 1-544

with CREATE FUNCTION, sqls, 1-133

with CREATE PROCEDURE, sqls, 1-189

with DATABASE statement, esqlc, 12-19

with EXECUTE, esqlc, 14-41

with EXECUTE FUNCTION, esqlc, 16-22, 17-26, 16-26

with EXECUTE PROCEDURE, esqlc, 14-47

with EXECUTE...INTO, esqlc, 14-43, 14-49

with external routines, sqls, 1-545

with INSERT, esqlc, 16-29

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

with SELECT, esqlc, 16-13

with SPL routines, sqls, 1-545

prepare.sql generated script, dbdkug, 3-52

Prepared statement, sqlr, Glossary-14

comment symbols in, sqls, 1-544

DESCRIBE statement with, sqls, 1-339

executing, sqls, 1-385

parameterizing, sqls, 1-549, 1-393

prepared object limit, sqls, 1-542

valid statement text, sqls, 1-544

version number, sqlr, 1-56

Preprocessor, sqlr, Glossary-14

case sensitivity, esqlc, 1-18

conditional compilation, esqlc, 1-16, 8-48

definitions, esqlc, 1-61, 1-14

directives. See Preprocessor directive.,

generating thread-safe code, esqlc, 13-17

header files, esqlc, 1-26

include files, esqlc, 1-13

line numbers, esqlc, 1-65

options. See Preprocessor option.,

redirecting errors, esqlc, 1-65

search path for included files, esqlc, 1-64

stage 1, esqlc, 1-62, 1-13

stage 2, esqlc, 1-16, 1-67

syntax, esqlc, 1-48

version information, esqlc, 1-55, 1-58

Preprocessor directive,

define, esqlc, 1-61, 1-14

definition of, esqlc, 1-12

elif, esqlc, 1-16

else, esqlc, 1-16

endif, esqlc, 1-16

ifdef, esqlc, 1-16

ifndef, esqlc, 1-16

include, esqlc, 1-26, 1-13

undef, esqlc, 1-61, 1-14

Preprocessor option,

-ansi, esqlc, 12-18, 1-52, 1-57

ccargs, esqlc, 1-50, 1-77

-cp, esqlc, 1-49

-e, esqlc, 1-59, 1-49, 1-55

-ED, esqlc, 1-61, 1-52, 1-57

-EU, esqlc, 1-61, 1-52, 1-57

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

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

-I, esqlc, 1-63, 1-53, 1-57

-icheck, esqlc, 1-63, 1-52, 1-57

-l, esqlc, 1-76

-l for dynamic thread library, esqlc, 13-51

-libs, esqlc, 1-50

-local, esqlc, 1-53, 14-6, 1-65, 1-57

-log, esqlc, 1-53, 1-65, 1-58

-lw, esqlc, 1-58

-mserr, esqlc, 1-75, 1-58

-nln, esqlc, 1-53, 1-65, 1-58

-nowarn, esqlc, 1-75, 1-53, 1-66, 1-58

-np, esqlc, 1-50

-nup, esqlc, 1-50

-o, esqlc, 1-80, 1-50, 1-85, 1-76, 1-77, 1-55

onlycp, esqlc, 1-50

-p, esqlc, 1-55

-static, esqlc, 1-50, 13-6, 13-7, 1-77, 13-28

those affecting linking, esqlc, 1-87

those affecting preprocessing, esqlc, 1-59

those for Informix libraries, esqlc, 13-6

-thread, esqlc, 1-60, 1-50, 13-6, 1-77, 13-27, 13-17, 1-58

-ts, esqlc, 1-58

-V, esqlc, 1-59, 1-50

-xopen, esqlc, 15-20, 15-22, 1-66, 1-58

Preprocessor, ESQL,

stage 1, esqlc, 1-9

Preprocessor, ESQL/C,

stage 2, esqlc, 1-9

Primary access method, sqlr, Glossary-14

Primary key,

definition of, sqlr, Glossary-14, sqlt, 8-25

restrictions with, sqlt, 8-25

Primary key constraint, sqls, 1-70, sqlt, 4-21

data type conversion, sqls, 1-79

definition of, sqlr, Glossary-14

enforcing, sqls, 1-228

modifying a column with, sqls, 1-78

naming, sqls, 1-84

referencing, sqls, 1-70

rules of use, sqls, 1-236

shared unique index, sqls, 1-83

using, sqls, 1-232

Print class, gls_api, 4-103, 4-127, 2-12, 2-13

Print program, sqlr, 3-34

Printable character, gls_api, 4-103, 4-127, 2-12, 2-13

Printable method, dbdkug, 7-7

Printed manuals, sqlr, Intro-14, sqls, Intro-19, esqlc, Intro-13, sqlt, Intro-12, gls_api, Intro-13, dapi, Intro-9, gls, Intro-16, extend, Intro-9, udr, Intro-9

Printing with DBPRINT, sqlr, 3-34

Private installation, udr, 4-8

Privilege, sqlr, Glossary-14, sqlt, 11-5 to

chaining grantors, sqls, 1-477

effect of REVOKE, sqls, 1-587

column-specific, sqlt, 11-10

column-specific,

syscolauth information, sqlr, 1-22

CREATE SCHEMA with GRANT, sqls, 1-206

database-level, sqlt, 4-16

database-level,

granting, sqls, 1-463 to

revoking, sqls, 1-577 to

sysusers information, sqlr, 1-60

DBA, sqls, 1-464, sqlt, 11-7

DROP ROLE effects, sqls, 1-366

encoded in system catalog, sqlt, 11-9

Execute, sqls, 1-472, sqlt, 11-14

defaulting to DBA, sqls, 1-129, 1-185

trigger requirements, sqls, 1-280

Execute (user-defined routine),

ANSI-compliancy, sqls, 1-474

revoking, sqls, 1-583

fragment, sqlt, 9-54

fragment,

granting with GRANT FRAGMENT, sqls, 1-480

revoking with REVOKE FRAGMENT, sqls, 1-589

granting, sqlt, 11-5 to

granting with GRANT, sqls, 1-461

INFO statement for, sqls, 1-493

Insert, sqlt, 11-8

needed,

to create a cast, sqls, 1-113

on a support function, extend, 5-19, 5-29

on an end-user routine, extend, 2-10, 5-25, 2-11

on an opaque type, sqls, 1-168, extend, 5-15, 5-28, 5-18

on an operator class, extend, 4-19

overview, sqlt, 1-8

public, sqlt, 4-17

public,

NODEFDAC effect on, sqls, 1-474, 1-469

NODEFDAC environment variable, sqlr, 3-56

revoking, sqls, 1-580

Resource, sqlt, 11-6

role name, sqls, 1-475, 1-586

purpose, sqls, 1-193

routine-level, extend, 5-19

Select, sqlt, 11-10, 11-8

table fragment,

sysfragauth information about, sqlr, 1-34

table-level, sqlt, 11-8 to , 4-17

column-specific, sqlt, 11-10

in ANSI-compliant database, sqlt, 11-8

making column-specific, sqlt, 11-10

systabauth information, sqlt, 4-18

Update, sqlt, 11-8

view, sqlt, 11-32

table-level,

ANSI-compliancy, sqls, 1-469

column-specific, sqls, 1-466

creating a view, sqls, 1-290

effect on view, sqls, 1-470

revoking, sqls, 1-579 to

syscolauth sample entry, sqlr, 1-8

systabauth information, sqlr, 1-8, 1-53

type-level, extend, 5-19

Usage, sqls, 1-471

revoking, sqls, 1-582

Usage (user-defined data type), sqls, 1-471

Usage,

sysxtdtypeauth information, sqlr, 1-63

Privileges, setting for objects, dbdkug, 3-12

Procedural statement, sqlr, Glossary-15

Procedure,

creating from file, sqls, 1-192

creating,

from separate file, sqls, 1-191

with CREATE PROCEDURE FROM, sqls, 1-191

description of, sqlr, Glossary-15

dropping with DROP PROCEDURE, sqls, 1-362

dropping with DROP ROUTINE, sqls, 1-368

function contrasted with, sqls, 1-182

invoking,

with CALL statement, udr, 4-5

with EXECUTE statement, udr, 4-5

naming conventions, sqls, 1-409

privileges, sqls, 1-189, 1-185

system catalog tables for, sqls, 1-183

PROCEDURE data type, sqls, 2-17

Procedure Modifier, sqls, 1-1028

Procedure Parameter List, sqls, 1-1033

Procedures. See Routines.,

Process,

child, esqlc, 12-33, 12-57

parent, esqlc, 12-33, 11-33, 12-57

Process ID, for virtual processors, dbdkug, 8-16

Processor,

associating options with files, esqlc, 1-59

creating a response file, esqlc, 1-83

naming executable file, esqlc, 1-80

syntax, esqlc, 1-91, 1-78, 1-79

using a project file, esqlc, 1-82

Windows options, esqlc, 1-92

Processor option,

-c, esqlc, 1-81

-cc, esqlc, 1-81, 1-79

-cpu, esqlc, 1-92

-f, esqlc, 1-82, 1-55

-l, esqlc, 1-80, 1-88

-libs, esqlc, 1-87, 1-55

-N, esqlc, 1-55

-Pi, esqlc, 1-93

placement of, esqlc, 1-59

-r, esqlc, 1-80, 1-89

-rt, esqlc, 1-93

-runtime, esqlc, 1-93, 1-85

-Sc, esqlc, 1-94, 1-86

-ss, esqlc, 1-93, 1-94, 1-86

-subsystem, esqlc, 1-94, 1-86

-Sw, esqlc, 1-94, 1-86

-target, esqlc, 1-94, 1-84, 1-97

-V, esqlc, 1-55

-wd, esqlc, 1-94, 1-84, 1-97

-we, esqlc, 1-94, 1-84

Windows options, esqlc, 1-91

Product icons, sqls, Intro-11, extend, Intro-8, udr, Intro-7

Program,

checking library version, esqlc, 13-14

commenting, esqlc, 1-21

compiling, esqlc, 1-81, 13-12, 1-11

including files, esqlc, 1-26, 1-13

linking, esqlc, 13-12, 13-7, 1-87, 13-26, 1-11, 13-9

message request, esqlc, 12-90, 14-30, 14-22, 14-24, 14-36, 12-34, 12-39

naming the executable file, esqlc, 1-80, 1-77, 1-55

preprocessing, esqlc, 1-59, 1-12

running, esqlc, 1-11

See also Sample program.,

suppressing compilation, esqlc, 1-59

suppressing linking, esqlc, 1-81

Program block, sqlr, Glossary-15

Program variables,

inserting, sqls, 1-559

preparing, sqls, 1-560

Programming,

C language code, dbdkug, 5-3 to

DataBlade API tips, dbdkug, 4-15

guidelines, dbdkug, 4-10 to , 6-16, 4-14

Project file, esqlc, 1-82, 1-55

Projection, sqlr, Glossary-15, sqlt, 2-7, 1-14

column with dot notation, sqls, 1-888

field with dot notation, sqls, 1-888

Projects,

client, dbdkug, 6-23, 6-4

creating in BladeSmith, dbdkug, 3-7

properties of in BladeSmith, dbdkug, 3-8

server, dbdkug, 6-5, 6-19

version numbers, dbdkug, 3-10

promotable,

Promotable lock, sqlt, 7-10

SeeLock,

Properties,

ActiveX value objects, dbdkug, 6-10 to

aggregates, of, dbdkug, 3-13

casts, of, dbdkug, 3-17

collection data types, dbdkug, 3-31

distinct data types, of, dbdkug, 3-33

errors, of, dbdkug, 3-20

generated files, of, dbdkug, 3-50

interfaces, of, dbdkug, 3-22

opaque data types, of, dbdkug, 3-34

row data types, dbdkug, 3-41

SQL, custom statements, dbdkug, 3-45

trace messages, of, dbdkug, 3-20

user-defined routines, of, dbdkug, 3-23

Property sheet, for BladeSmith object, dbdkug, 3-7

Protected routine, sqlr, 1-48

PROTOCOL network parameter, esqlc, 1-108, 12-15

PSORT_DBTEMP environment variable, sqlr, 3-60

PSORT_NPROCS environment variable, sqlr, 3-61

pthread.h DCE header file, esqlc, 13-25

pthread_lock_global_np() DCE function, esqlc, 13-25

pthread_yield() DCE function, esqlc, 13-26

PUBLIC keyword,

privilege granted to all users, sqlt, 11-6

Punct class, gls_api, 4-105, 4-129, 2-12, 2-13

Punctuation character, gls_api, 4-105, 4-129, 2-12, 2-13

PUT statement,

checking results with SQLCA, sqls, 1-565

collection derived table with, sqls, 1-833

collection variables with, sqls, 1-833

constant data with, sqlt, 6-12

count of rows inserted, sqlt, 6-11

FLUSH with, sqls, 1-557

FROM keyword, sqls, 1-560

insert cursor, sqls, 1-559

inserting a row, esqlc, 14-18

inserting into a collection variable, esqlc, 9-22

multiple with transactions, sqls, 1-319

sends returned data to buffer, sqlt, 6-10

source of row values, sqls, 1-558

syntax, sqls, 1-555

trigger with, sqls, 1-260

use in transactions, sqls, 1-557

USING DESCRIPTOR clause, sqls, 1-562, esqlc, 17-31, 17-14, 17-4

USING SQL DESCRIPTOR clause, sqls, 1-561, esqlc, 16-11, 16-35, 16-5

putenv() system call, esqlc, 12-43, 14-37