Controlling the SAS Embedded Process

The SAS Embedded Process starts when a query is submitted. The SAS Embedded Process continues to run until it is manually stopped or the database is shutdown. You might want to disable or shutdown the SAS Embedded Process without shutting down the database.

The following commands control the SAS Embedded Process.

Action performed	Command (by Teradata version)
Provides the status of the SAS Embedded Process.	CALL DBCEXTENSION.SERVERCONTROL ('status', :A); 1 CALL DBCEXTENSION.SERVERCONTROL ('SAS', 'status', :A); 2 CALL SQLJ.SERVERCONTROL ('SAS', 'status', :A); 3
Shuts down the SAS Embedded Process. Note: You cannot shut down until all queries are complete.	CALL DBCEXTENSION.SERVERCONTROL ('shutdown', :A); 1 CALL DBCEXTENSION.SERVERCONTROL ('SAS', 'shutdown', :A); 2 CALL SQLJ.SERVERCONTROL ('SAS', 'shutdown', :A); 3
Stops new queries from being started. Queries that are currently running continue to run until they are complete.	CALL DBCEXTENSION.SERVERCONTROL ('disable', :A); 1 CALL DBCEXTENSION.SERVERCONTROL ('SAS', 'disable', :A); 2 CALL SQLJ.SERVERCONTROL ('SAS', 'disable', :A); 3
Enables new queries to start running.	CALL DBCEXTENSION.SERVERCONTROL ('enable', :A);1 CALL DBCEXTENSION.SERVERCONTROL ('SAS', 'enable', :A);2 CALL SQLJ.SERVERCONTROL ('SAS', 'enable', :A); 3
1For Teradata 13.10 and 14.00 only. Note that the Cmd parameter (for example, 'status') must be lowercase.
2For Teradata 14.10 only. Note that the Languagename parameter, 'SAS', is required and must be uppercase. The Cmd parameter (for example, 'status'), must be lowercase.
3For Teradata 15 only. Note that the Languagename parameter, 'SAS', is required and must be uppercase. The Cmd parameter (for example, 'status'), must be lowercase.