Optional arguments – HP Neoview Release 2.5 Software User Manual
Page 122
—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