SPD Server supports
the creation of SQL views. A view is a virtual table based on the
result set of an SQL statement. An SPD Server view can reference only
SPD Server tables. You should use SPD Server explicit pass-through
SQL syntax to create SPD Server views, as follows:
EXECUTE(Create view <viewname> as Select) BY [sasspds|alias];
Creating an SQL view
results in a view file that is created in the specified domain with
the name <viewname>.view.0.0.0.spds9. After an SQL view is created,
the SPD Server view can be used in SPD Server SQL queries as a table.