Rowsets messages (30000 through 30999)

SQL 30001

30001 A rowset must be composed of host variable arrays.

Cause

You attempted to create a rowset that is not composed of host variable arrays.

Effect

The operation fails.

Recovery

Correct the syntax and resubmit.

SQL 30002

30002 The given rowset size ( num1) must be smaller or equal to the smallest dimension (num2) of the arrays composing the rowset.

Where,

num1 is the size of the rowset;

num2 is the smallest dimension of the rowset arrays.

Cause

You specified a rowset size larger than the smallest dimension, num2 , of the rowset arrays.

Effect

The operation fails.

Recovery

Correct the syntax and resubmit.

SQL 30003

30003 Rowset size must be an integer host variable or constant.

Cause

You specified a rowset size with a value other than an integer host variable or constant.

Effect

The operation fails.

Recovery

Correct the syntax and resubmit.

SQL 30004

30004 The dimension of the arrays composing the rowset must be greater than zero. A value of num was given.

Where num is the rowset size.

Cause

You specified a value for rowset arrays that is invalid. It must be greater than zero.

Effect

The operation fails.

Recovery

Correct the syntax and resubmit.

SQL 30005

30005 The dimensions of the arrays composing the rowset are different. The smallest dimension is assumed.

Cause

You specified different values for the dimensions of a rowset array.

Effect

NonStop SQL/MX uses the smallest dimension for the array.

Recovery

If this is not the value you want to use, correct the syntax and resubmit.

SQL 30006

30006 Both rowset and scalar host variables occur in the output list. Either all output host variables must be scalar or all output host variables must be rowsets.

Cause

Stated in the message.

Effect

The operation fails.

Recovery

Refine your SELECT statement and resubmit.

SQL 30007

30007 Incompatible assignment from type type to type type

Cause

You attempted to perform an assign statement using incompatible types.

Effect

The operation fails.

Recovery

Correct the syntax and resubmit.

SQL 30008

30008 Rowset index is out of range.

Cause

NonStop SQL/MX received an internal error from a rowset.

Effect

The operation fails.

Recovery

None. Contact your service provider.

SQL 30009

30009 Trying to add more elements than maximum rowset size.

Cause

NonStop SQL/MX received an internal error from a rowset.

Effect

The operation fails.

Recovery

None. Contact your service provider.

SQL 30010

30010 An internal error occurred. Rowset is corrupted.

Cause

NonStop SQL/MX received an internal error from a rowset.

Effect

The operation fails.

Recovery

None. Contact your service provider.

SQL 30011

30011 More than one INTO statement in the same query is not supported.

Cause

You attempted to use more than one INTO statement in one query.

Effect

The operation fails.

Recovery

Correct the syntax and resubmit.

SQL 30012

30012 Rowset index name must be specified last in the derived column list of name.

Cause

You did not specify the name of the rowset index in the derived column list given in the message.

Effect

The operation fails.

Recovery

Correct the syntax and resubmit.

SQL 30013

30013 Host variable used to set input size of rowset has zero or negative value.

Cause

You specified a hostvar with a zero or negative value for the input size of the rowset.

Effect

The operation fails.

Recovery

Correct the syntax and resubmit.

SQL 30014

30014 Host variable used to set input size of rowset is not of type short, int, or long.

Cause

You specified a hostvar for the input size of the rowset that is not of type short, int, or long.

Effect

The operation fails.

Recovery

Correct the syntax and resubmit.

SQL 30020

30020 Embedded update/delete cannot be used with SELECT...INTO and rowset.

Cause

You attempted to use an embedded UPDATE or DELETE with SELECT...INTO and rowset.

Effect

The operation fails.

Recovery

Correct the syntax and resubmit.

SQL 30021

30021 Rowsets cannot be used in the SET clause if there are no corresponding rowsets in the WHERE clause.

Cause

You attempted to use a rowset in the SET clause of an UPDATE statement when a corresponding rowset is not present in the WHERE clause.

Effect

The operation fails.

Recovery

Correct the syntax and resubmit.

SQL 30026

30026 NOT ATOMIC rowset INSERT is not supported on a table that has dependent indexes that are not offline. Dependent index index-name exists for table table-name.

Where,

index-name is the name of the dependent index;

table-name is the name of the table containing the dependent index.

Cause

You attempted to use NOT ATOMIC inserts on a table that has at least one dependent index. Dependent indexes might have been created by the system to enforce a uniqueness or primary key constraint.

Effect

The operation fails.

Recovery

Do not attempt recovery. Contact your service provider.

SQL 30027

30027 NOT ATOMIC INSERT is not supported on a table that is the subject table of BEFORE triggers. BEFORE trigger trigger-name has table table-name as its subject table.

Where,

trigger-name is the name of the BEFORE trigger;

table-name is the name of the subject table.

Cause

You attempted to use NOT ATOMIC inserts on a table that is the subject table of at least one BEFORE trigger.

Effect

The operation fails.

Recovery

Contact your service provider.

SQL 30028

30028 NOT ATOMIC INSERT is not supported on a table that is the referencing table of referential integrity constraints. Referential integrity constraint constraint-name has table table-name as its referencing table.

Where,

constraint-name is the name of the referential integrity constraint;

table-name is the name of the referencing table.

Cause

You attempted to use NOT ATOMIC inserts on a table that is the referencing table of referential integrity constraints.

Effect

The operation fails.

Recovery

Contact your service provider.

SQL 30029

30029 NOT ATOMIC INSERT is not supported on a table that is the subject table of enabled AFTER triggers.

Cause

You attempted to use NOT ATOMIC inserts on a table that is subject table of at least one enabled AFTER trigger.

Effect

The operation fails.

Recovery

Contact your service provider.

SQL 30033

30033 NOT ATOMIC INSERT is not supported on table table-name because it is the subject table of the materialized view mv-name.

Cause

You attempted a NOT ATOMIC INSERT operation on a table which has a dependent materialized view.

Effect

The operation fails.

Recovery

Do not perform a NOT ATOMIC INSERT on a table which has a dependent materialized view.

SQL 30035

30035 All rows in the NOT ATOMIC INSERT raised an error. No rows have been inserted.

Cause

All rows in the NOT ATOMIC inserts raised nonfatal errors.

Effect

No rows are inserted. This is a warning message only.

Recovery

Contact your service provider.

SQL 30037

30037 The search-condition for a DELETE [FIRST N] statement contains a rowset.

Cause

The search-condition for a DELETE [FIRST N] statement contains a rowset.

Effect

The statement does not compile.

Recovery

Remove the rowset host variable or parameter from the search-condition.