Hp Neoview Release 2.4 Software Manual de usuario descargar pdf (Pagina 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

1 2 ... 39 40 41 42 43 44 45 46 47 48 49 ... 123 124

Comentarios a estos manuales

Sin comentarios

Hp Neoview Release 2.4 Software Manual de usuario Pagina 44

Comentarios a estos manuales

Relacionado con productos y manuales para Software Hp Neoview Release 2.4 Software