LogOnOff: odbc connect to ... load date(DDATE_LOGON, 'DD.MM.YYYY hh:mm:ss') as DDATE_LOGON, date(DDATE_LOGOFF, 'DD.MM.YYYY hh:mm:ss') as DDATE_LOGOFF, SAUTHID as SAUTHID, SPROGRAM as SPROGRAM, NRN as NRN ; SQL SELECT * FROM PARUS."UDO_V_LOGONOFF";
AppList: ODBC CONNECT TO ... load APPCODE as SPROGRAM, APPNAME as SAPPNAME ; sql select * from PARUS."V_APPLIST";
BpHist: odbc connect to ... //noconcatenate load date(REG_DATE, 'DD.MM.YYYY hh:mm:ss') as DREG_DATE, date(END_DATE, 'DD.MM.YYYY hh:mm:ss') as DEND_DATE, RESULT as NRESULT, UNITCODE as SUNITCODE, ACTION as SACTION, AUTHID as SAUTHID, PROGRAM as SPROGRAM, RN as NRN_BPHIST ; sql select * from PARUS."BPHIST" where REG_DATE >= trunc(sysdate);
TimeIntervals: replace load previous(DateTimeStamp) as TimeIntrvlBegin, DateTimeStamp as TimeIntrvlEnd resident TimeStamps where IsNull(previous(DateTimeStamp)) = 0;