Microframe Corporation 3007 Series Betriebsanweisung PDF herunterladen (Seite 55)

1-47

-1000 to -5300

index name: ALTER INDEX RENAME database1:table1:index1 TO

index2. However, the following statement causes an error because a

view name can be qualified only with a database name: ALTER

VIEW RENAME database1:table1:view1 to view2. A permissible

statement is ALTER VIEW RENAME database1:view1 to view2 or

ALTER VIEW RENAME view1 to view2.

-5243: Specified column number is not valid

The PSQL_MOVE keyword (used with ALTER TABLE) must specify

a column location greater than zero but less than the total number of

columns. For example, assume that table t1 has only two columns,

col1 and col2. Both of the following statement return an error:

ALTER TABLE t1 PSQL_MOVE col1 to 0

ALTER TABLE t1 PSQL_MOVE col1 to 3

The first statement attempts to move the column to position zero.

The second statements attempts to move the column to position

three, which is a number greater than the total number of columns

(two).

-5245: Procedure/view permissions not supported on this

metadata version

Permissions on views and stored procedures are permissible only on

databases with V2 metadata.

-5247: This feature is not supported for the current

metadata version

Certain functionality, such as trusted and non-trusted views and

stored procedures, are permissible only on databases with V2

metadata.

-5248: Invalid partial column

The last (or the only) column in a partial index is not of data type

CHAR or VARCHAR.

1 2 ... 50 51 52 53 54 55 56 57 58 59 60 ... 251 252

Keine Kommentare

Microframe Corporation 3007 Series Betriebsanweisung Seite 55