HP Neoview Release 2.4 Software - Manual (Page 44)

sourcename pipe pipename [options source-options]
Specifies a named pipe as the data source/target. pipename is the name of the pipe.
sourcename { jdbc } { sql sqltext | table tablename } [options source-options]
Specifies an SQL table or query accessed through a JDBC data connection to the Neoview
system.
jdbc, sql, and table are keywords.
The Transporter client does not support ODBC sources.
Neoview SQL views and synonyms are not supported for JDBC table extracts.
tablename is a one, two, or two-part table name in the format
[[catalog.][schema.]]table . For a load operation, tablename can be a synonym
or insertable view.
If schema or table is double-quoted (""), it is interpreted as an HP Neoview SQL
delimited identifier. If schema or table is not double-quoted, it is interpreted as an HP
Neoview SQL regular 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.
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 jdbc 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 jdbc table sch.dept
• Specify a source named “table2” to access an SQL table with a delimited schema
and table name:
44 Control File Organization and Syntax