Working with Stored Processes :: SAS(R) Data Integration Studio 4.5: User's Guide

Overview

You can create two types of stored processes in SAS Data Integration Studio:

Version 1.0 stored processes, which are the IOM Direct Interface Stored Processes that were introduced in SAS 8.
Version 2.0 stored processes, which are the SAS Stored Processes that were introduced in SAS 9.

The following table compares the compatibility and features available in the two versions of stored processes.

Stored Process Feature Comparison

Version 1.0	Version 2.0
Compatible with server versions prior to SAS 9.3 and SAS 9.3 servers.	Compatible with SAS 9.3 servers only.
Associated with a specific logical server, which can be a SAS Stored Process Server or a SAS Workspace Server.	Associated with an application server context, and can be run by either a SAS Stored Process Server or a SAS Workspace Server. You can choose whether to restrict the server type or let the client application make the server selection.
Stores source code on the application server.	Stores source code either on the application server or in metadata.
Allows execution on the specified application server only.	Allows execution on other application servers or on the specified application server only.
Requires the *ProcessBody; comment if they are running on a workspace server.	Does not require the *ProcessBody; comment, regardless of which server is used.
Must use the stored process server to produce streaming output.	Uses 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.

You can perform the following tasks with stored processes:

View the Version Number for a Stored Process

To view the version number for an existing stored process, perform the following steps:

From the desktop, verify that the ViewBasic Properties option is selected.
Navigate to a folder that contains stored processes.
Select a stored process. You can then view the version number in the Basic Properties pane, as shown in the following figure.

Basic Properties for a Stored Process

Deploy a Job as a Version 1.0 or Version 2.0 Stored Process

You can deploy an existing job as a version 1.0 or version 2.0 stored process. For information, see the stored process topics in Deploying Jobs as Stored Processes.

Create a Version 2.0 Stored Process

To create a new version 2.0 stored process that is not based on a SAS Data Integration Studio job, right-click a folder in the Folders tree and select Stored Process from the New menu. You can also select Stored Process in the New item on the toolbar. Either method displays the New Stored Process wizard.

For detailed information about creating a stored process, navigate to the Execution page of the wizard. Then, click Manage to display the Manage Source Code Repositories window. Finally, click Help. Open the Stored Process Management folder to review the available topics.

Convert a Stored Process from One Version to Another

You can convert a stored process from one version to another. For example, you might deploy a job as a version 1.0 stored process, but later you might want to take advantage of the version 2.0 features. In that case, you can deploy the job as a version 1.0 stored process. Then, you can upgrade that stored process to version 2.0 and access the new features.

To convert a version 1.0 stored process to version 2.0, right-click the stored process and select Upgrade. You can verify that the version number in the Usage Version field in the Basic Properties pane has been changed to 2.0. You can open the Properties window of the upgraded stored process and enable the 2.0 features on the Execution tab.

You might also want to convert a version 2.0 stored process to a version 1.0 stored process in order to run it on an older server (a server with a version prior to SAS 9.3). To convert a version 2.0 stored process, select the stored process. Open the Properties window to verify that no features that are unique to version 2.0 are being used. Then, right-click the stored process and select Make Compatible. If the stored process runs on a SAS Workspace server, make sure that the *ProcessBody; comment is included in the source code. You can verify that the version number in the Usage Version field in the Basic Properties pane has been changed to 1.0.