beautypg.com

Optional arguments – HP Neoview Release 2.5 Software User Manual

Page 122

background image

—schema

If specified with table, the schema information to put into the generated control file. If
—schema

is specified without -table, control files are generated for all tables within the

schema that can be accessed without error.
Delimited schema names must start and end with a double-quote (“). Names containing
double quotes must be escaped with singe-quotes (').

—table

specifies the table name or names to be used in generating a control file. If specified without
either –schema or –cat, fully-qualify the table name or names.
Delimited table names must start and end with a double-quote (“).
Names containing inner double quotes must be escaped . If the name contains backslash
before double-quote the backslash must be escaped. Therefore:

Table name “np*”jap”” becomes “np*\”jap\””.

Table name “tabl\e”\”name” becomes “tabl\e”\\\”name”.

If not specified, both the -schema and -cat options are required, and control files are
generated for all available tables in the schema.
If specified with both -cat and -schema, specify only table names.

-sys

The Neoview system name of the load/extract server.

Optional Arguments

These arguments are optional:

—cat

The server catalog name. The default is NEO.
Requirement: This option must be used with the -schema option.

—file

Is the directory or file name where the control file(s) are created.

TIP:

The directory name must end with a forward slash (/).

If not specified, it defaults to table_name or schema_name in the local control file
directory under $NVTHOME/conf.
If used with a list of tables, but only one table is specified, the -single option is automatically
set to true.
If a filename is not specified, the control file is named after table name or schema name,
depending on the option specified and whether –single is true or false.

If –single is true and there are multiple table names, the control file is named after the
schema.

If –single is false, the control file is named after the table.

—temp

The name of the custom template file that is used to generate the control file(s). If unspecified,
it defaults to contemplate.txt in the control file directory underNVTHOME/conf.

-jobtype

The type of job for this control file, either load or extract.
The default value is load.

-single

Specifies whether to generate a single control file or separate control files for each table.
The default value is false.

122

Control File Editor and Control File Generator