Communicator e3000 MPE/iX Release 7.0 Express 1 (Software Release C.70.01) (30216-90328)

ManualsBrandsHP ManualsSoftwareMPE/iX 6.5 Operating System

121

122

123

124

125

126

127

128

129

130

Chapter 6 127

Technical Articles

AS Clause Enhancement 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 contain spaces 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 "".

NOTE

Key word FROM can be used as Column alias names, only when it is enclosed

within Quotes ("FROM")

• SELECT COL1 FROM FROM TABLE; (Not Allowed)

• SELECT COL1 "FROM" FROM TABLE; (Allowed)

Constraints

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

2. Column Alias Name cannot be used in subqueries because the subquery result is not

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

3. Column Alias Name 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 Column Alias cannot be used in sub-queries. (DBERR 1172)

This error occurs when AS Clause is speciﬁed in sub-queries

AS Clause cannot be used in the Select Statement of Create View,

1173 Type 2 Insert or Genplan. (DBERR 1173)

This error occurs when AS Clause is speciﬁed in the Select Statement of Create View, Type

2 Insert or Genplan.

1174 Expected something between the single quotes. (DBERR 1174)

This error occurs when the alias name is speciﬁed as a single-quoted identiﬁer and the

identiﬁer doesn't contain any characters, i.e., the alias name is speciﬁed as ''”

1175 Column Alias name cannot be only spaces. (DBERR 1175)

This error occurs when the alias name is speciﬁed as a single-quoted identiﬁer or as a

double-quoted identiﬁer and the identiﬁer is made of only spaces.

1176 Column Alias Name cannot be used in the Select Statement of Create View, Type 2

Insert or Genplan. (DBERR 1176)

This error occurs when Alias Name is speciﬁed in the Select Statement of Create View,

Type 2 Insert or Genplan.