SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
R-1
R
RECLENGTH File Attribute
RECLENGTH is a file attribute that specifies the number of physical bytes of space
reserved for each row of a table. RECLENGTH applies only to relative tables.
length
is an integer that specifies the number of bytes to reserve for each record.
RECLENGTH must be at least as great as the total length of all columns in the
column list when the table is created and cannot exceed BLOCKSIZE minus 24.
(For a table with a block size of 4096, for example, the maximum record length is
4072.)
The default is the length of the table's columns.
Considerations—RECLENGTH

RECLENGTH reserves space in a relative table so columns can be added later.
You cannot add columns to a relative table if the combined length of the new and
existing columns exceeds the table's RECLENGTH. You cannot change
RECLENGTH after the table has been created.

Specifying a large RECLENGTH value allows you to add columns later, but wastes
disk space until you do. Each row written to the table is allotted the specified
space, regardless of the actual length of the current column list.
RELEASE Statement
RELEASE is a dynamic SQL statement that deallocates space in a host program for a
dynamic SQL statement that is referenced through a host variable and not declared as
a literal in the program.
After a statement is released, references to the statement or to an associated cursor
produce errors.
:host-identifier
is a host variable of SQL type CHAR or VARCHAR that contains the statement
name as declared in the host program. host-identifier must conform to the
naming conventions of the host language.
RECLENGTH length
RELEASE :host-identifier