VIEW: APPLSYS.AD_SESSIONS#

Source

View Text - Preformatted

select SESSION_ID SESSION_ID, UTILITY_NAME UTILITY_NAME, APPL_TOP_ID APPL_TOP_ID, INVOKDIR INVOKDIR, STATUS STATUS, PRIORITY PRIORITY, OS_PROCESS_ID OS_PROCESS_ID, OS_USER_NAME OS_USER_NAME, START_DATE START_DATE, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, APPL_TOP_PATH APPL_TOP_PATH, CONTEXT_INFO CONTEXT_INFO, WAIT_LOOP_TIME WAIT_LOOP_TIME, CONTROL_CODE CONTROL_CODE, ANY_CHANGE_WHILE_INACTIVE_FLAG ANY_CHANGE_WHILE_INACTIVE_FLAG, JS_TOTAL_JOBS JS_TOTAL_JOBS, JS_COMPLETED_JOBS JS_COMPLETED_JOBS, JS_REMAINING_JOBS JS_REMAINING_JOBS, JS_CURR_PHASE JS_CURR_PHASE, JS_JOBS_REM_IN_CURR_PHASE JS_JOBS_REM_IN_CURR_PHASE, JS_JOBS_ASS_IN_CURR_PHASE JS_JOBS_ASS_IN_CURR_PHASE, JS_JOBS_READY_IN_CURR_PHASE JS_JOBS_READY_IN_CURR_PHASE, JS_JOBS_WAITING_IN_CURR_PHASE JS_JOBS_WAITING_IN_CURR_PHASE, RUN_ON_NODE RUN_ON_NODE, LOCKS_OVERRIDDEN_BY LOCKS_OVERRIDDEN_BY, TOPDIR TOPDIR from "APPLSYS"."AD_SESSIONS"

View Text - HTML Formatted

SELECT SESSION_ID SESSION_ID
, UTILITY_NAME UTILITY_NAME
, APPL_TOP_ID APPL_TOP_ID
, INVOKDIR INVOKDIR
, STATUS STATUS
, PRIORITY PRIORITY
, OS_PROCESS_ID OS_PROCESS_ID
, OS_USER_NAME OS_USER_NAME
, START_DATE START_DATE
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, APPL_TOP_PATH APPL_TOP_PATH
, CONTEXT_INFO CONTEXT_INFO
, WAIT_LOOP_TIME WAIT_LOOP_TIME
, CONTROL_CODE CONTROL_CODE
, ANY_CHANGE_WHILE_INACTIVE_FLAG ANY_CHANGE_WHILE_INACTIVE_FLAG
, JS_TOTAL_JOBS JS_TOTAL_JOBS
, JS_COMPLETED_JOBS JS_COMPLETED_JOBS
, JS_REMAINING_JOBS JS_REMAINING_JOBS
, JS_CURR_PHASE JS_CURR_PHASE
, JS_JOBS_REM_IN_CURR_PHASE JS_JOBS_REM_IN_CURR_PHASE
, JS_JOBS_ASS_IN_CURR_PHASE JS_JOBS_ASS_IN_CURR_PHASE
, JS_JOBS_READY_IN_CURR_PHASE JS_JOBS_READY_IN_CURR_PHASE
, JS_JOBS_WAITING_IN_CURR_PHASE JS_JOBS_WAITING_IN_CURR_PHASE
, RUN_ON_NODE RUN_ON_NODE
, LOCKS_OVERRIDDEN_BY LOCKS_OVERRIDDEN_BY
, TOPDIR TOPDIR
FROM "APPLSYS"."AD_SESSIONS"