SAP Knowledge Base Article - Preview

3615211 - iqunload wrongly generates primary key on ReadOnly dbspace for a range partition table - SAP IQ

Symptom

  1. Create a table with range partitions
  2. Set a few dbspaces to ReadOnly and others to ReadWrite for the range partitions.
  3. Run "iqunload -n -r" to generate the DDL.
  4. In the generated CREATE TABLE statement, the primary key is created on one of the ReadOnly dbspaces, while this is not specified in the initial table.


Read more...

Environment

SAP IQ 16.1

Product

SAP IQ 16.1

Keywords

iqunload, "primary key", pkey, "read only", readonly, "read write", readwrite", range, partitions, partitioned , KBA , BC-SYB-IQ , Sybase IQ , Known Error

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.