SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
F-6
File Attributes
5. Fill in the SQLDA and names buffer with the descriptions of the parameter
values (input parameters) in the SQL statement:
EXEC SQL DESCRIBE INPUT S1 INTO :SDAI
NAMES INTO :NAMESINPUT;
6. Fill in the SQLDA and names buffer with the descriptions of the SELECT
columns (output variables) in the SQL statement:
EXEC SQL DESCRIBE S1 INTO :SDAO NAMES INTO :NAMESOUTPUT;
7. Declare a cursor, C1, for the statement S1. Open the cursor using the
parameter values that were input and stored in :SDAI:
EXEC SQL DECLARE C1 CURSOR FOR S1;
EXEC SQL OPEN C1 USING DESCRIPTOR :SDAI;
8. Retrieve the column values stored in :SDAO:
EXEC SQL FETCH C1 USING DESCRIPTOR :SDAO;
File Attributes
File attributes describe the physical characteristics of a file or an SQL object, such as a
table or an index, that is stored in a file. The values you select for a file's attributes can
affect the storage and security for the object and the performance of applications that
use the object.
File attributes are set when a file is created. If you do not specify attribute values in the
statement that creates an SQL object (such as CREATE TABLE or CREATE INDEX),
SQL uses default values. Many attributes can be changed later (with statements such
as ALTER TABLE or ALTER INDEX), some attributes remain in effect for the life of the
object, and a few can change as a side effect of a command or a change to some
other attribute.
This table summarizes the file attributes important for SQL objects. Because SQL
objects reside in Guardian files, all the attributes listed are attributes of Guardian files.
For more information, see the descriptions of specific attributes.