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

Pad, sqlr, Glossary-14

Page, sqlr, Glossary-14

Page lock,

effect on index, sqlt, 7-10

Panels, vis_ug, 1-9

Connectors, vis_ug, 1-12

Controls, vis_ug, 1-12

Data Sources, vis_ug, 1-10

Data Symbols, vis_ug, 1-12

Database Contents, vis_ug, 1-11

Layouts, vis_ug, 1-12

manipulating objects in, vis_ug, 12-7

Primitives, vis_ug, 1-11

Query Design, vis_ug, 1-11

Resources, vis_ug, 1-10

Scenes, vis_ug, 12-7, 1-10

Panning, vis_ug, 14-10

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

Parameter, sqlr, Glossary-14

Parameter bar,

illustration of, vis_ug, 7-20, 7-17

Parameter blocks, vis_ug, 3-31

Parameters,

about, vis_ug, 3-41

defining for Visionary Viewer, vis_ug, 14-8

description of, vis_ug, 1-4, 1-6

global, vis_ug, 11-8, 7-5

in object properties, vis_ug, 1-18

local, vis_ug, 7-5

mapping object properties to, vis_ug, 7-15 to

public, vis_ug, 14-8

query, vis_ug, A-54

scene, vis_ug, 4-6, A-63

See also Global parameters; Scene parameters; Query parameters.,

selecting, vis_ug, 11-13

setting, vis_ug, 11-12

setting in Visionary Viewer, vis_ug, E-13

setting with event actions, vis_ug, 9-6

specifying columns for, vis_ug, 11-13

wiring in World Structure Editor, vis_ug, 1-17, 12-9

Parent objects, vis_ug, 7-3

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

Pasting objects, vis_ug, 12-7

PATH environment variable, sqlr, 3-58

Pathname,

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

Patterns,

horizon, vis_ug, 5-7

matrix, vis_ug, 5-8

spiral, vis_ug, 5-8

table, vis_ug, 5-8

uses for, vis_ug, 5-4

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

PERCALL_COST routine modifier, sqls, 1-1030

Percentages, displaying. See Pie charts.,

Performance,

buffered log, sqlt, 9-40

depends on concurrency, sqlt, 7-3

Permission, sqlr, Glossary-14

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

See Privilege.,

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

Picture objects,

and stock images, vis_ug, 11-7

displaying in a scene, vis_ug, 5-17

inserting, vis_ug, 5-17

properties of, vis_ug, A-47

viewing properties of, vis_ug, 11-7

Pie charts,

changing wedge colors in, vis_ug, 7-14

child objects of, vis_ug, 5-20

creating, vis_ug, 5-10

description of, vis_ug, 5-5

example of, vis_ug, 2-5, 5-10, 5-13

illustration of, vis_ug, 5-13

modifying, vis_ug, 5-14

properties of, vis_ug, A-48

selecting in Object Inspector, vis_ug, 5-14

Planning a Visionary world, vis_ug, 2-3

PLCONFIG environment variable, sqlr, 3-60

plus() operator function, sqls, 1-959

Pointer, sqlr, Glossary-14

PointNumber( ) function, vis_ug, 7-15

Polygons,

and linear maps, vis_ug, 5-7

properties of, vis_ug, A-50

Polylines,

and linear maps, vis_ug, 5-7

properties of, vis_ug, A-51

varying the width of, vis_ug, 5-18

Polymorphism, sqlr, Glossary-14

Populating tables, sqlt, 9-43

Ports, about, vis_ug, 3-29

positive() operator function, sqls, 1-960

POW function, sqls, 1-909

Precedence,

dot notation, sqlt, 12-9

dot notation rules, sqls, 1-889

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

PRECISION field,

with DESCRIBE, sqls, 1-342

with SET DESCRIPTOR, sqls, 1-710

predefined data type, sqlr, Glossary-14

Predicate lock, sqlr, Glossary-14

PREPARE statement,

deferred execution, sqlr, 3-55

deferring, sqls, 1-698

description of, sqlt, 5-31

error return in SQLERRD, sqlt, 5-10

executing, sqls, 1-385

for collection variables, sqls, 1-545

freeing resources with FREE, sqls, 1-431

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

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

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 external routines, sqls, 1-545

with SPL routines, sqls, 1-545

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

Price interval bars,

description of, vis_ug, 5-22

properties of, vis_ug, A-52

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

Primitives,

adding, vis_ug, 6-5

definition of, vis_ug, 6-4

Primitives panel, vis_ug, 1-11

Print program, sqlr, 3-34

Printed manuals, sqlr, Intro-14, sqls, Intro-19, sqlt, Intro-12

Printing, vis_ug, 12-5

Printing with DBPRINT, sqlr, 3-34

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 an opaque type, sqls, 1-168

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

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

Usage, sqls, 1-471

revoking, sqls, 1-582

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

Usage,

sysxtdtypeauth information, sqlr, 1-63

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

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

Processor, storing temporary files, instll32, 28

Product configuration, instll32, 19

Product icons, sqls, Intro-11

Program block, sqlr, Glossary-15

Program variables,

inserting, sqls, 1-559

preparing, sqls, 1-560

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

column with dot notation, sqls, 1-888

field with dot notation, sqls, 1-888

promotable,

Promotable lock, sqlt, 7-10

SeeLock,

Properties page, vis_ug, 1-18, 7-8, 7-9

Property cells, vis_ug, 7-12, 7-9

Property expressions,

and global parameters, vis_ug, 11-9

and the Object Inspector, vis_ug, 1-18

description of, vis_ug, 7-12

example of, vis_ug, 7-13

example of specifying color using, vis_ug, 7-13

formatting numbers in, vis_ug, 7-12

functions in, vis_ug, 7-12

operators in, vis_ug, 7-12

required syntax for, vis_ug, C-1

using columns in, vis_ug, 7-12

using resources in, vis_ug, 11-5

Property functions,

defining, vis_ug, 7-14

types of, vis_ug, 7-14

Protected routine, sqlr, 1-48

Protocols, instll32, 4

Pseudocode view, vis_ug, 1-17, 12-8

PSORT_DBTEMP environment variable, sqlr, 3-60

PSORT_NPROCS environment variable, sqlr, 3-61

PUBLIC keyword,

privilege granted to all users, sqlt, 11-6

Publishing worlds,

as ActiveX controls, vis_ug, 1-4

connecting to a database from, vis_ug, 13-4

description of, vis_ug, 13-3

HTML test page for, vis_ug, 13-3

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

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

USING SQL DESCRIPTOR clause, sqls, 1-561