Sunday, October 23, 2011

How to find target load type(Whether it is 'Bulk' or 'Normal' ) in session properties?

SELECT E.SUBJ_NAME AS FOLDERNAME, 
D.TASK_NAME AS SESSIONNAME, 
A.SESSION_ID AS SESSIONID, 
B.INSTANCE_NAME AS INSTANCENAME, 
DECODE (C.ATTR_VALUE, '0', 'NORMAL', '1', 'BULK', NULL) 
AS TARGETLOADTYPE 
FROM INFA_REP.OPB_SESSION A, 
INFA_REP.OPB_SWIDGET_INST B, 
INFA_REP.OPB_EXTN_ATTR C, 
INFA_REP.OPB_TASK D, 
INFA_REP.OPB_SUBJECT E 
WHERE A.SESSION_ID = B.SESSION_ID 
AND A.SESSION_ID = C.SESSION_ID 
AND C.ATTR_ID = 3 
AND B.SESS_WIDG_INST_ID = C.SESS_WIDG_INST_ID 
AND A.SESSION_ID = D.TASK_ID 
AND D.SUBJECT_ID = E.SUBJ_ID 
AND E.SUBJ_NAME='FOLDER_NAME'

1 comment: