The SPDSCONV program
is a command-line utility. You use a set of command-line options and
parameters to specify the name and location of tables that you want
to convert, and then you specify the options that you want for your
conversion. If your SPD Server software is installed on a UNIX platform,
see the
SPD Server UNIX Installation Guide for information about setting up your environment before
you run SPDSCONV.
The command-line syntax
is as follows:
SPDSCONV <Options> [-a | table1 [table2]]
The order of options
and table names on the command line does not matter. All of the currently
available options are global options. Placing a global option before
or after a table does not change the option setting for that table
alone. Global options are always applied globally.
The SPDSCONV command
has the following options:
the directory path
that corresponds to an existing SPD Server LIBNAME domain. This pathname
should be the same as the PATHNAME= directory path in the libnames.parm
file.
the directory path
where SAS job files that are created during the conversion process
should be stored. The default logpath setting is the directory from
which the SPDSCONV command is issued.
converts all SPD Server
3.x compatible tables in the -d pathname directory to tables that are compatible
with SPD Server 4.5.
creates a SAS job in
the log directory for each SPD Server 3.
x table that contains an index. When you use the -j option, the SAS
job re-creates the indexes on the SPD Server 4.5 table. You must run
the SAS job after the SPDSCONV utility completes the conversion process.
Because re-creating an index recreation can be computation-intensive,
you should schedule SAS index re-creation jobs as a SAS batch job
during off-peak hours. The utility generates the name of the SAS job
file, which has the following format:
TableName_v4ix.sas
In the name, TableName
is the name of the table that is compatible with SPD Server 4.5. The
SAS job file contains the SAS language statements that are required
for re-creating the indexes that the SPD Server 3.
x table used. You need to edit the job file before
the job executes. Editing the file ensures that the correct SPD Server
4.5 LIBNAME is used with the PROC DATASETS statement.
creates verbose output
for the conversion process.