MESSAGE PATH | Adaptive Server IQ 12.4.0 |
9.2.2 MESSAGE PATH
In the MESSAGE PATH clause of CREATE DATABASE you must specify an operating system file. The message file cannot be on a raw partition. This is a correction to the Adaptive Server IQ Reference.
9.2.3 Low_Disk functions as High_Group
LD (Low_Disk) has been changed to function like HG (High_Group). It is no longer supported by a separate index and therefore does not offer any benefit beyond using HG. LD is still a valid syntax and may be used for compatibility with older versions.
9.2.4 Column Limit Correction
In Chapter 13 of the Adaptive Server IQ Reference the limit is incorrectly specified as 999 columns. The correct limit is 10,000 columns.
9.2.5 Joint Virtual Table (JVT) definition
A Join Virtual Table is a denormalized table which looks like a regular table; it has a name, columns, rows, and indexes. Unlike a regular table, however, a JVT cannot be created, modified or deleted by the user. It is created by Adaptive Server IQ as a result of a Create Join Index for internal processing purposes. It is deleted when the user does a Drop Join Index.
Error messages relating to join virtual tables appear only when a user tries to use or modify a JVT directly.
9.2.6 IQ database file paths must be unique
When you create a database or a dbspace, the path for the Temporary Store must differ from the path for the IQ Store. If your CREATE DATABASE or CREATE DBSPACE command specifies the identical path and filename for these two stores, you receive an error. This requirement was omitted from the Adaptive Server IQ Reference and the Adaptive Server IQ Administration and Performance Guide.
You can cause a unique path in any of these ways:
•Specify a different extension for each file (for example, mydb.iq and mydb.iqtmp)
•Specify a different file name (for example, mydb.iq and mytmp.iq)
22 | Release Bulletin for Digital UNIX |