Example: STARJOIN RESET Statements

The following example connects to SASSPDS. Then the code issues the "stj$" RESET option to display all available information as the server attempts to validate the join subtree for the SQL on a star schema. The STARMAGIC=16 setting disables the STARJOIN COMPOSITE join strategy (STARJOIN COMPOSITE joins are enabled by default in the server). The NOSTARJOIN=0 setting means that STARJOIN is enabled (or resets a disabled STARJOIN facility) and ensures that STARJOIN optimization occurs if the server SQL recognizes a valid server pattern or star schema. (The STARJOIN facility is enabled by default in the server.)

After you submit the following SQL statements, the code disconnects from SASSPDS and quits:

    proc sql;
      connect to sasspds
        (dbq="star"
         server=sunburn.5007
         user='anonymous');

      execute (reset
         DETAILS="stj$"
         STARMAGIC=16
         NOSTARJOIN=0)

      by sasspds;

      execute (
         ...
         SQL statements
         ...);
      by sasspds;

      disconnect from sasspds;
    quit;