SPDSCONV Utility Examples

Suppose you have 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')"; 

Suppose you have an SPD Server 3.x table named CT010299 that belongs to the usmkt domain, and you want to convert CT010299 to SPD Server 4.4 use. The table CT010299 has no indexes and you want a verbose output of the table conversion.

SPDSCONV -v -d /mdat1/usmkt CT010299

Suppose you want to convert all tables in the sales domain. You also want SPDSCONV want to create SAS jobs that you can run to recreate the indexes after the table conversion completes. You want the SAS jobs put into the directory $HOME/salesv9. You also want a verbose output of the conversion.

SPDSCONV -v -d /mdat1/sales -l $HOME/salesv9 -j -a