SPDSCONV Utility Examples

Example LIBNAME Parameter File

These examples assume that you use the following LIBNAME parameter file for your SPD Server installation:
LIBNAME=usmkt pathname=/mdat1/usmkt
 roptions="datapath=('/dat11/usmkt'
                    '/dat12/usmkt'
                    '/dat13/usmkt'/
                    '/dat14/usmkt')
 indexpath=('/ix11/usmkt'
            '/ix12/usmkt')";

LIBNAME=sales pathname=/mdat1/sales
 roptions="datapath=('/dat21/sales'
                    '/dat22/sales'
                    '/dat23/sales'/
                    '/dat24/sales')

 indexpath=('/ix21/sales'
            '/ix22/sales')"; 

Converting a Simple Table

Suppose you have an SPD Server 3.x table named CT010299 that belongs to the usmkt domain, and you want to convert CT010299 to use with SPD Server 4.5. Table CT010299 does not have indexes and you want a verbose output of the table conversion.
Issue the following command:
SPDSCONV -v -d /mdat1/usmkt CT010299

Converting Tables and Re-creating Indexes

Suppose you want to convert all tables in the sales domain. You also want SPDSCONV to create SAS jobs that you can run to re-create the indexes after the table conversion is complete. You want the SAS jobs put into the directory $HOME/salesv9. You also want a verbose output of the conversion.
Issue the following command:
SPDSCONV -v -d /mdat1/sales -l $HOME/salesv9 -j -a