Manualshelf

SQL/MP Programming Manual for C

ManualsBrandsHP ManualsServerHP NonStop G-Series
301302303304305306307308309310
Maximizing Local Autonomy
HP NonStop SQL/MP Programming Manual for C—429847-008
C-3
Skipping Unavailable Partitions
Skipping Unavailable Partitions
Use the SKIP UNAVAILABLE PARTITION option of the CONTROL TABLE directive to
cause NonStop SQL/MP to skip a partition that is not available and to open the next
available partition that satisfies the search condition of a query. (NonStop SQL/MP also
returns warning message 8239 to the SQLCA structure.) The SKIP UNAVAILABLE
PARTITION option applies to static or dynamic SQL statements that refer to partitioned
tables and partitioned indexes of the tables.