HP Neoview Release 2.5 Software - Manual (Page 46)

sourcename file filename [options source-options]
Specifies a data file as the data source/target. filename specifies the location of the file,
including both the path and the file name.
Transporter assumes the data file is uncompressed.
Example:
Specify a plain data file, datafile_1.dat, in the current directory with source name
data1
:
data1 file "./datafile_1.dat"
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 were 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 were set to 1.
• SQL constructs that cannot be parallelized include:
— embedded updates or deletes
— rowset parameters
46 Control File Organization and Syntax