Starting with 9.3, you
can use new stored process features, or you can choose to make your
stored processes compatible with 9.2. If your client does not support
new stored process features, then you might need to make your stored
processes compatible with 9.2. Stored processes that are compatible
with 9.2 can also be upgraded to use the new stored process features.
The following table shows the differences between stored processes
that are compatible with 9.2 and stored processes that use newer features:
Stored Process That
Are Compatible with 9.2
|
Stored Processes That
Use Newer Features
|
Are associated with
a specific logical server, which can be a stored process server or
a workspace server.
|
Are associated with
an application server context, and can be run by either a stored process
server or a workspace server. You can choose whether to restrict the
server type or let the client application make the server selection.
|
Store source code on
the application server.
|
Can store source code
either on the application server, or in metadata.
|
Allow execution on the
specified application server only.
|
Can allow execution
on other application servers, or on the specified application server
only.
|
Require the *ProcessBody;
comment if they are running on a workspace server.
|
Do not require the *ProcessBody;
comment, regardless of which server is used.
|
Must use the stored
process server to produce streaming output.
|
Can use either the stored
process server or the workspace server to produce streaming output.
|
Data sources and targets
can be generic streams or XML streams.
|
Data sources and targets
can be generic streams, XML streams, or data tables.
|
To make a stored process
compatible with 9.2, select a stored process in SAS Management Console.
Open the
Stored Process Properties dialog
box to make sure that none of the newer features are being used. (See
the product Help.) Right-click and select
Make Compatible. If the stored process runs on a workspace server, make sure that
the *ProcessBody; comment is included in the source code.
To upgrade a stored
process to use newer features, select a stored process that is compatible
with 9.2. Right-click and select
Upgrade.
Open the
Stored Process Properties dialog
box to make use of the newer features.