HP 3000 Manuals HP 3000 Manuals
IMAGE Command
The IMAGE command is used to specify the database and the information
used by the schema processor when generating a schema and root file.
Syntax
IMAGE [;DATABASE=data-base-name]
[;CONTROL=(control-list)]
[;SCHEMA=schema-file-name]
[;OUTPUT=output-listing]
[;NAME=primary-or-alias]
[;CONFLICT=action-on-conflict]
[;COMMENT=comment-option]
[;ORDER=order-by-set-type-option]
{.}
Parameters
data-base-name: Primary name of the database for which a schema
and root file are to be created. A definition
for this database must already exist in the
dictionary.
control-list: The options used by the schema processor when
the schema is processed. These options are the
same ones as described for the $CONTROL COMMAND
in the IMAGE/V Reference Manual, except for
BLOCKMAX. Note that the BLOCKMAX option is
defined differently here.
BLOCKMAX=nnnn sets the maximum physical
block length (in words) for
a data set. If you do not
include this parameter, the
default value for Image is
used. If you enter
BLOCKMAX= without a value,
the value declared in the
dictionary is used."
Enter the options separated by commas as
described in the IMAGE/V Reference Manual. You
need not enter the word '$control' as it will
be assigned automatically by SDDBC. SDDBC does
not scan for invalid options. Once you specify
to create the schema and root file, the invalid
options are detected by the Schema Processor.
schema-file-name: The schema will be written to the specified
file. If the file does not exist, a new file
is created. If the file exists, you will be
asked for permission to overwrite it. The
default is to write the schema to the temporary
file SDSCHEMA.
output-listing: Specifies where the output listing of the
schema generated by DBSCHEMA should be sent.
Valid values are:
TERMINAL sends the listing to the
terminal.
PRINTER sends the listing to the
line printer.
NULL suppresses the listing.
filename sends the listing to the
specified file. If the
file does not exist, a new
file is created. If the
file exists, you will be
asked for permission to
overwrite it.
*filename sends the listing to the
file identified in the back
referenced file equation.
The default is to send the listing to the
terminal.
primary-or-alias: Use primary names or alias names defined in
System Dictionary as Image data names in
Schema. Valid values are:
PRIMARY
ALIAS
If PRIMARY is specified, all names written to
the schema file will be the primary names. If
alias is specified, then IMAGE-ALIAS names will
be used. If this parameter is not specified,
the default is to use IMAGE-ALIAS names. See
Chapter 4 for more details on IMAGE-ALIAS
names.
action-on-conflict: The length of a System Dictionary name can be
up to 32 characters long. But an Image data
name can only be 16 characters long maximum.
Thus, when generating the schema, dictionary
names longer than 16 characters will be
truncated to 16 characters. Conflicts can
result when names are truncated. There are
three options available to handle the
conflicting names. Valid options are:
PROMPT
TERMINATE
SUBSTITUTE
If the PROMPT option is chosen, you will be
prompted for new names when a conflict occurs.
Responses to the prompts issued for conflicts
will be read from $STDINX. Option TERMINATE
will terminate the creation process when a
conflict occurs. Option SUBSTITUTE allows
SDDBC to assign unique names whenever a
conflict occurs, by overriding the last
character(s) of the conflicting name with a
unique number starting from 1. Whenever a name
longer than 16 characters is truncated, or a
substitution occurs, SDDBC will write a warning
message of the name change giving the System
Dictionary name and the new truncated name. If
you do not specify anything, the default is
SUBSTITUTE.
comment-option: Option to generate comment lines or not. Valid
values are:
TRUE
FALSE
If not specified, default is TRUE.
order-by-set- Option to generate data sets by data set type
type-option: in the order of AUTOMATIC, MANUAL, and DETAIL.
The valid values are:
TRUE
FALSE
If not specified, the default is TRUE. If this
option is set to FALSE, the data sets will be
generated in the order they are retrieved.
Example:
> IMAGE DATABASE=supply;
>> CONTROL=(LIST,ERRORS=10,TABLE);
>> SCHEMA=schemab;
>> OUTPUT=terminal;
>> NAME=ALIAS.
>