HP Neoview Release 2.4 Software User Manual
Page 38
a matching name is found. Subsequent columns with the matching name are not
accessible within this dataformat.
There are two workarounds for this problem:
— Derived columns of the query, for example, the results of Neoview SQL
expressions and aggregate functions, by default are identified by the name
“(EXPR)”. If multiple derived columns are produced by a single query, use an
AS
clause in the query text to associate a name with each derived column. For
example:
SELECT max(a) as MAX_A, min(a) as MIN_A
FROM myTable
— If multiple table columns produced by the query have the same 1-part column
name, use an AS clause in the query text to associate unique names with those
columns. For example, if tables T1 and T2 both have columns named A and B:
SELECT T1.B as T1_B, T2.B as T2_B
FROM T1, T2
WHERE T1.A = T2.A
For SQL table format, if fieldname is not double-quoted, it is interpreted as an HP
Neoview SQL regular identifier. If fieldname is double-quoted, it is interpreted as an
HP Neoview SQL delimited identifier.
Delimited identifiers differ from regular identifiers in many ways, including:
•
Delimited identifiers are case-sensitive.
•
Spaces within a delimited identifier are significant except for trailing spaces.
•
You can use reserved words as delimited identifiers.
See the HP Neoview SQL Reference Manual for details on SQL identifiers.
datatype
can be one of the supported data listed in
“Supported Data Types” (page 48)
.
For Neoview SQL table formats, datatype must be one of:
•
the data type of the associated table or query column
•
varchar
When a varchar datatype is specified for the target SQL fields, typeformats are not
considered for date, time, and timestamp values.
Only the simple data type name should be used. For example, if a table column named
FIRSTNAME is of data type varchar(8), you should specify “FIRSTNAME varchar”
instead of “FIRSTNAME varchar(8)”.
format formatname
one of the typeformats you defined in the typeformats section. This is optional and
not applicable for SQL columns.
options field-options
Defines options for the field. These field-options are supported:
•
•
38
Control File Organization and Syntax