SPD Server Table Options

SPD Server table options specify processing actions that apply only to a specific table. When you use a LIBNAME statement, specify the options in parentheses next to the table name. If you use an SQL pass-through statement, specify the options in brackets next to the table name.

Options to Enhance Performance

BYNOEQUALS=

specifies the index output order of table rows with identical values for the BY column.

NETPACKSIZE=

controls the size of an SPD Server network data packet.

SEGSIZE=

sizes the segment for index files associated with an SPD Server table.

Options for Other Functions

BYSORT=

performs an implicit sort of a table when a BY clause is encountered and there is no index available.

ENDOBS=

specifies the end row (observation) number in a user-defined range.

STARTOBS=

specifies the start row (observation) number in a user-defined range.

SORTSIZE=

specifies the amount of memory (in number of bytes, not kilobytes or megabytes) that SPD Server is able to allocate to complete a sorting request. The SORTSIZE= value declared must be less than the global SORTSIZE parameter specified in the spdsserv.parm server parameter file.

VERBOSE=

details all indexes associated with an SPD Server table. This option provides other information, such as table owner and ACL group.