![HP NonStop SQL/MX Messages Manual Download Page 68](http://html.mh-extra.com/html/hp/nonstop-sql-mx/nonstop-sql-mx_messages-manual_165150068.webp)
Data Definition Language (DDL) Messages (1000
through 1999)
HP NonStop SQL/MX Messages Manual — 640324-001
3- 42
Recovery. Specify a data type for the column.
SQL 1180
Where
schema-name
is the schema in which the object is being created.
Where
subvol-name
is the designated subvolume name for that schema.
Cause. One or more LOCATION clauses in the CREATE or MODIFY statement
contained a Guardian location whose subvolume did not match the designated
subvolume for the schema in which the object was being created.
Effect. The object was not created.
Recovery. Either correct the invalid LOCATION clauses or remove them and allow the
system to generate the Guardian locations.
SQL 1181
Where
Guardian name
is the name of the table, index, view, or routine being
dropped.
Where
error
is the returned file system error number.
Cause. The object you attempted to drop resulted in file system error
error
.
Effect. The DDL DROP operation fails.
Recovery. See previous messages in this SQL/MX operation to determine the
necessary corrective actions. Also, use the file system error
error-number
to
analyze the cause. Fix the error and resubmit.
SQL 1182
Where
error
is the error returned.
Where
Guardian name
is the name of the file.
Cause. See the Guardian Procedure Errors and Messages Manual for a description of
file system error
error
.
Effect. The operation fails.
1180 The required subvolume name for locations in schema
schema-name
is
subvol-name
.
1181 Label
Guardian
name
could not be dropped. (file error
error)
.
1182 Error
error
was returned by the file system on resource
fork
Guardian name
.
Summary of Contents for NonStop SQL/MX
Page 4: ......
Page 8: ...Contents HP NonStop SQL MX Messages Manual 640324 001 iv ...
Page 26: ...General Messages 0 through 999 HP NonStop SQL MX Messages Manual 640324 001 2 2 ...
Page 130: ...SQL MX MXCMP Messages 2000 through 2999 HP NonStop SQL MX Messages Manual 640324 001 4 34 ...
Page 242: ...Normalizer Messages 5000 through 5999 HP NonStop SQL MX Messages Manual 640324 001 7 2 ...
Page 246: ...Optimizer Messages 6000 through 6999 HP NonStop SQL MX Messages Manual 640324 001 8 4 ...
Page 248: ...Generator Messages 7000 through 7999 HP NonStop SQL MX Messages Manual 640324 001 9 2 ...
Page 614: ...Utility Messages 20000 through 23099 HP NonStop SQL MX Messages Manual 640324 001 18 138 ...
Page 752: ...Non SQLCODE Error Messages HP NonStop SQL MX Messages Manual 640324 001 A 14 MXGNAMES Utility ...