sassas-metadata

Get timeoutseconds value for a Stored Process server

As per documentation:

"timeoutseconds = seconds"

The TIMEOUTSECONDS parameter specifies the time interval that an OLAP server or a stored process server waits before it stops a client process and cleans up the server run-time environment context.

My question is - how do I obtain this value programmatically, eg as part of a Stored Process?

Solution

  • STPSRVGETN
    Returns the numeric value of a server property

    SAS Statements                                             Results
------------------------------------------------------     ---------------------
dsesstimeout=stpsrvgetn('default session timeout');
put dsesstimeout=;                                         dsesstimeout=900

sessmaxtimeout=stpsrvgetn('maximum session timeout');
put sessmaxtimeout=;                                       sessmaxtimeout=3600

session=stpsrvgetn('session timeout');
put session=;                                              session=900

maxconreqs=stpsrvgetn('maximum concurrent requests');
put maxconreqs=;                                           maxconreqs=1

deflrecl=stpsrvgetn('default output lrecl');
put deflrecl=;                                             deflrecl=65535

version=stpsrvgetn('version');                             
put version=;                                              version=9.4