INTEGRATION BROKER TABLES.

INTEGRATION BROKER TABLES.
--------------IB Gateway----------
Select * From PSGATEWAY ;
Select * From PSCONN ;
Select * From PSNODECONPROP ;
Select * From PSCONNPROP ;
Select * From PSCONNPROPIDVW;
Select * From PSCONPROPNAMEVW;
Select * From PSCONPROPVALVW ;
Select * From PSCONPROPDATAVW;
-----------Routings----------
Select * From PSIBRTNGDEFN where ROUTINGDEFNNAME like 'CG%';
Select * From PSRTNGDFNCONPRP where ROUTINGDEFNNAME like 'CG%';
Select * From PSRTNGDFNPARMVW  where ROUTINGDEFNNAME like 'CG%';
Select * From PSRTNGDFNPROP  where ROUTINGDEFNNAME like 'CG%';
Select * From PSRTNGDFNPARM  where ROUTINGDEFNNAME like 'CG%';
Select * From PSIBRTNGDEFN  where ROUTINGDEFNNAME like 'CG%';
---Service-------------
Select * From PSAUTHWS ;
Select * From PSSERVICE;
Select * From PSIBWSDL ;
Select * From PSOPRVERDFN ;
select * from PSIBMSGSERV_VW ;
select * from PSIBRTNGSERV_VW ;-- IB Service Routings
Select * From PSOPERATION;
Select * From PSSERVICEOPR_VW;
Select * From PSOPRVERDFNPARM;
Select * From PSOPERATIONAC;-- IB Service App. Class
Select * From PSHUBNODEVW ;---Routings---
Select * From PSIBRTNGDEFN;
Select * From PSRTNGDFNPARM ;
Select * From PSRTNGDFNCONPRP ;
Select * From PSOPRGENRTGPARM0;-- IB Service Routing Parameters
-----QUES---------------
Select * From PSQUEUEDEFN;
Select * From PSOPRVERDFN;
Select * From PSOPRVERDFNPARM;
Select * From PSSRVQUEUE_VW;
------MSG DEFN-------
Select * From PSMSGVER;
 Select * From PSMSGDEFN;
Select * From PSMSGPARTS ;
Select * From PSMSGPARTS_VW;
Select * From PSOPRVERDFNM_VW;
------NODE-------------
Select * From PSMSGNODEDEFN;
Select * From PSNODECONPROP;
Select * From PSNODEURITEXT;
Select * From PSIBRTNGDEFN ;
Select * From PSNODEPROP ;
Select * From PSMSGATTR ;
 ---Schemas---
Select * FROM PSIBMSGSCHEMA;
Select * FROM PSIBSCMADFN;
Select * FROM PSIBSCMADATA;
--Connectors-----
Select * From PSCONN ;
-------MSG--------
Select * From PSCONPROPVALVW ;
Select * From PSCONNPROPIDVW;
Select * from PSNODEVW;
Select * from PS_AMM_ARCH_PUB ;
Select * from PSAUTHWS_VW;
Select * from PSAUTHWS_VW1;
Select * from PSAUTHWS_VW2 ;
Select * from PSIBUSERCOMP;
---------------------------
Select * From PSCONTNAMEVW;
Select * From PSCODESETGROUP;
Select * From PSCONNGATEWAYVW;
Select * From PSCONNIDVW;
-----Handlers----
Select * from PSOPRHDLR;

READ TRACE as described below.

 READ TRACE as described below.

 PSAPPSRV.1033 1-525 16.50.10 0.000 Cur#1.CRMDEV1 RC=0 Dur=0.000 COM Stmt=SELECT
"1-525"    >>>sequential line counter for the process.
"16.50.10" >>>time stamp
"0.000"    >>>time  elapsed since the previous line was written to the trace file.
"Cur#1"    >>> number of the cursor for the statement
"CRMDEV1"  >>>name of the instance in which the statement was executed.
"RC=0"     >>> Return Code
"Dur=0.000">>>duration of the statement.
.

PEOPLECODE HELP BITS 4

Function Delay(&seconds As number, &BoId As number) Returns boolean;
        ;
   &jCls = GetJavaClass("java.lang.Thread");
        &WaitTill = AddToDateTime(%Datetime, 0, 0, 0, 0, 0, &seconds);
   While &WaitTill > %Datetime
         /*Check every one Second time*/
      SQLExec("Select count(*) from Table ABC where COL= :1", &id, &IdCheck);
      If &IdCheck> 0 Then
         Return True;
      Else
   GetJavaClass("java.lang.Thread").sleep(2000); /*Sleep takes Millis.2000 millis equals 2 seconds*/
    End-If;
   End-While;
   Return False;
End-Function;