ALLBASE/SQL Reference Manual (36216-90216)

Chapter 6 205

Names

Host Variable Names

Host variables are used to pass information between an application program and

ALLBASE/SQL. They are ordinary application program variables that happen to be used

in SQL commands.

A host variable name must be preceded by a colon (:) when used in an SQL command.

When used elsewhere in an application program, no colon should be used.

Host variable names must conform to ALLBASE/SQL's rules for basic names; however,

they are allowed to be up to 30 bytes in length. In addition, host variable names must

conform to the rules of the language in which the application program is written.

Local Variable Names

Local variables are used to hold data within a procedure. A local variable is declared in a

DECLARE statement in the procedure, and it is preﬁxed with a colon (:) when used in any

other statement. Local variable names must conform to ALLBASE/SQL's rules for basic

names.

Parameter Names

Parameters are used to pass information between the database and a procedure. A

parameter is identiﬁed in the parameter list of a CREATE PROCEDURE statement, and it is

preﬁxed with a colon (:) when used in the body of the procedure. Parameter names must

conform to ALLBASE/SQL's rules for basic names.

DBEnvironment and DBECon File Names

The name of a DBEnvironment and the name of its DBECon ﬁle are identical. This name

uses the form shown here, follows HP-UX ﬁle naming conventions, and cannot exceed 128

characters, including slashes:

FileName

[.GroupName[.AccountName]]

This name must always be enclosed in single quotation marks when speciﬁed in SQL

commands. If athe group and account are not given, ALLBASE/SQL assumes the name

speciﬁed is in the current group and account.