Museum

Home

Lab Overview

Retrotechnology Articles

⇒ Online Manual

Media Vault

Software Library

Restoration Projects

Artifacts Sought

Related Articles

Format

Example

context-var

db-handle

relation-name

on-error

field-name

value-expr

record-descr

host-var

RDB/VMS Relational Database Operator PLACE — VMS CDD+_4.1A

 Returns the dbkey of a specified record.  The PLACE statement lets
 you determine the target page number for records that are to be
 loaded into the database.  The PLACE statement is similar in syntax
 to the STORE statement.  However, the PLACE statement does not
 actually store a record.

 The PLACE statement can result in significant performance
 improvements in database load procedures that specify PLACEMENT VIA a
 hashed index.  Use it only with records for which a hashed index has
 been defined.

 The PLACE statement is valid only in RDO and in Callable RDO.

Additional information available:

FormatExample

Format

 placE ─>context-var ──>
I

N
──┬────────>─────────┬──> relation-name ──────┐ └─>db-handle ─> . ─┘ │ │ ┌──────────────────────────────────<────────────────────────────────────┘ └─────────> 
U

S

I

N

G
───┬────────────────┬─────────────────────────────────┐ └──> on-error ───┘ │ ┌────────────────────────────────<──────────────────────────────────────┘ ├──┬──> context-var . field-name ───> typebox (=) ───> value-expr ───┬─>─┬───>────┐ │ └───────────────────────── typebox (;) <──────────────────────────┘ │ │ └─────> context-var . * ──────────> typebox (=) ──> record-descr ────>───┘ │ ┌──────────────────<──────────────────────<─────────────────────────────┘ └─┬─>─────────────────────────────>───────────────────────────────────┬─┐ ├─> 
G

E

T
──> host-var ──> typebox (=) ──> context-var ──> . ──> 
R

D

B

$

D

B

K

E

Y
─┤ │ └─> 
P

R

I

N

T
─────────────────────> context-var ──> . ──> 
R

D

B

$

D

B

K

E

Y
─┘ │ ┌───────────────────<──────────────────────────<────────────────────────┘ └──────────>────────────────────> 
E

N

D

P

L

A

C

E

Additional information available:

context-vardb-handlerelation-nameon-errorfield-namevalue-expr
record-descrhost-var

context-var

 A valid context variable.

db-handle

 A host language variable used to refer to the database.

relation-name

 The name of the relation into which the value would be stored.

on-error

 The ON ERROR clause, which specifies a host language statement or
 Rdb/VMS data manipulation statement to be performed if an Rdb/VMS
 error occurs.

field-name

 The name of the field in the relation where the value would be
 stored.

value-expr

 A valid Rdb/VMS value expression that specifies the value that would
 be stored.

record-descr

 A valid data dictionary record descriptor matching all the fields of
 the relation.  You can use a host language statement to include the
 relation definition in your program.  Each field of the record
 descriptor must match exactly the field names and data types of the
 fields in the Rdb/VMS relation referenced by the context variable.

host-var

 A user-defined host language variable, into which you may store the
 dbkey of the record that would be stored.  Use the GET...RDB$DB_KEY
 construct to assign the value of the dbkey to the host language
 variable.

Example

 The PLACE statement returns the dbkey of the specified record in the
 following example:

 RDO>   PLACE E IN EMPLOYEES
 cont>     USING E.EMPLOYEE_ID = "94789"
 cont>     PRINT E.RDB$DB_KEY
 cont>  END_PLACE

Typewritten Software • bear@typewritten.org • Edmonds, WA 98026