HP Neoview Release 2.3 Software User Manual
Page 41
•
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.
For an extract operation, the sql option can be used to specify a SELECT query instead
of a table name. The sql option cannot be used for a load operation.
When a SELECT query is specified for an extract operation, sqltext must be a
double-quoted ("") string. The string can span multiple lines. If double-quote characters
are required in the query text, they can be preceded by a backslash (\).
For example, a SELECT query spans multiple lines and includes a delimited schema name
that requires double-quoting:
extract source odbc sql "SELECT *
FROM \"SQL\".myTable
WHERE myColumn > 10"
Considerations for an extract operation where the sql option is used and
parallelstreams
is greater than one:
•
If the value of parallelstreams exceeds the number of configured CPUs on the
Neoview system, Transporter logs a warning message and performs the extract
operation as if parallelstreams was set to the number of CPUs.
•
There are certain queries that cannot be parallelized by SQL. If the specified query
cannot be parallelized, Transporter logs a warning message and performs the extract
operation as if parallelstreams was set to 1.
•
SQL constructs that cannot be parallelized include:
— embedded updates or deletes
— rowset parameters
— [FIRST/LAST N] syntax
— SQL table-valued functions
— stream access to tables
Examples
•
Specify a source named “table” to access SQL table sch.dept:
table1 odbc table sch.dept
•
Specify a source named “table2” to access an SQL table with a delimited schema
and table name:
table1 odbc table "SQL"."MyTable"
•
Specify a source names “query1” to access an SQL join query:
query1 jdbc sql
"select * from sch.dept
where number_of_employees > 10"
sourcename
jms jmsname [options source-options]
This specifies a Java Messaging Service (JMS) source. jmsname is a JMS name.
source-options
one or more occurrences of source-options, separated by a comma (,). The last
source-options
should not use the comma separator.
These options can be specified at the source level or provided for all sources as global options:
Options for file sources:
•
•
•
Control File Organization and Syntax
41