Communicator e3000 MPE/iX Release 6.5 Express 2 (Software Release C.65.02) (30216-90322)

Chapter 3 23

Technical Articles

Using the AS Clause in ALLBASE/SQL

partnumber;

If the alias name is speciﬁed as an identiﬁer it should conform to the following rules which

are the rules deﬁned for "Basic Names" in ALLBASE/SQL.

• The name can be up to 20 characters in length.

• The name can be made of any combination of letters (a to z, A to Z), decimal digits (0 to

9), $, #, @, or underscore (_). The ﬁrst character cannot be an underscore or a decimal

digit.

When the alias name is speciﬁed as a single-quoted identiﬁer or as a double-quoted

identiﬁer, it can containspaces and special characters in addition to the characters allowed

in the "Basic Names," as deﬁned above, and the name can be up to 20 characters in length.

The alias name cannot be only spaces and it should not be of zero length, i.e., it cannot be

speciﬁed as '' or as "".

Constraints

• The alias name cannot be used in the other clauses of the query.

• AS Clause cannot be used in sub-queries because the sub-query result is not returned to

the user and hence the alias name doesn't have any signiﬁcance here.

• AS Clause cannot be used in the Select Statement of Create View, Type 2 Insert or

Genplan because it doesn't have any signiﬁcance here.

New Error Messages

1172 Message AS Clause cannot be used in sub-queries. (DBERR

1172)

Cause This error occurs when AS Clause is speciﬁed in

sub-queries.

Action Remove the AS Clause from the sub-query.

1173 Message AS Clause cannot be used in the Select Statement

of Create View. (DBERR 1173)

Cause AS Clause is speciﬁed in the Select Statement of Create

View, Type 2 Insert or Genplan.

Action Remover AS Clause from Select Statement of Create View,

etc.

1174 Message Expected something between the single quotes.

(DBERR 1174)

Cause The alias name is speciﬁed as a single-quoted identiﬁer

that doesn't contain any characters, i.e., the alias name is

speciﬁed as ' '

Action Insert at least one legal character between the qoutes.

1175 Message The alias name cannot be only spaces. (DBERR

1175)