Home > Class Reference > ENSLIB namespace > %TSQL.sys.processes
Private  Storage   

%TSQL.sys.processes


view class %TSQL.sys.processes
View Query:
select JobNumber as spid, 1 as kpid, null as blocked, ClientNodeName as clienthostname, ClientExecutableName as clientapplname, PidExternal as hostprocess, Routine As program_name, GlobalReferences as physical_io, MemoryUsed As memusage, CURRENT_TIMESTAMP as login_time, Priority as priority, ClientNodeName as clientname, State as status, $TSQL_HOST_NAME() as hostname, CurrentLineAndRoutine as cmd, OSUserName as nt_username, UserName as loginame, ClientIPAddress, CurrentDevice, CurrentSrcLine, InTransaction, JobType, LastGlobalReference, LinesExecuted, Location, MemoryAllocated, NameSpace, OpenDevices, Pid, StartupClientIPAddress, StartupClientNodeName, UserInfo from %SYS.ProcessQuery
Query analysis:
Col Schema Table Col Name Col Label Datatype ODBC Type Code Length Precision Scale
1%SYSProcessQueryJobNumberspid%Library.Integer44100
2kpid%Library.Integer4110
3blocked%Library.String12110
4%SYSProcessQueryClientNodeNameclienthostname%Library.String1250500
5%SYSProcessQueryClientExecutableNameclientapplname%Library.String1250500
6%SYSProcessQueryPidExternalhostprocess%Library.String1250500
7%SYSProcessQueryRoutineprogram_name%Library.String1250500
8%SYSProcessQueryGlobalReferencesphysical_io%Library.BigInt-58190
9%SYSProcessQueryMemoryUsedmemusage%Library.Integer44100
10login_time%Library.TimeStamp1116190
11%SYSProcessQueryPrioritypriority%Library.Integer44100
12%SYSProcessQueryClientNodeNameclientname%Library.String1250500
13%SYSProcessQueryStatestatus%Library.String1250500
14hostname%Library.String122552550
15%SYSProcessQueryCurrentLineAndRoutinecmd%Library.String1250500
16%SYSProcessQueryOSUserNament_username%Library.String1250500
17%SYSProcessQueryUserNameloginame%Library.String1250500
18%SYSProcessQueryClientIPAddressClientIPAddress%Library.String1250500
19%SYSProcessQueryCurrentDeviceCurrentDevice%Library.String1250500
20%SYSProcessQueryCurrentSrcLineCurrentSrcLine%Library.String1250500
21%SYSProcessQueryInTransactionInTransaction%Library.Integer44100
22%SYSProcessQueryJobTypeJobType%Library.Integer44100
23%SYSProcessQueryLastGlobalReferenceLastGlobalReference%Library.String1250500
24%SYSProcessQueryLinesExecutedLinesExecuted%Library.BigInt-58190
25%SYSProcessQueryLocationLocation%Library.String1250500
26%SYSProcessQueryMemoryAllocatedMemoryAllocated%Library.Integer44100
27%SYSProcessQueryNameSpaceNameSpace%Library.String1250500
28%SYSProcessQueryOpenDevicesOpenDevices%Library.String1250500
29%SYSProcessQueryPidPid%Library.Integer44100
30%SYSProcessQueryStartupClientIPAddressStartupClientIPAddress%Library.String1250500
31%SYSProcessQueryStartupClientNodeNameStartupClientNodeName%Library.String1250500
32%SYSProcessQueryUserInfoUserInfo%Library.String1216160

Inventory


Parameters Properties Methods Queries Indices ForeignKeys Triggers


Summary


This class has no methods or properties.