Enlighten - Information - How to get the number of objects returned by the OLIA

This page describes how to get the number of objects returned by the OLIA.

The number of objects returned by OLIA can be obtained by following the steps below:

1. Change the temporary table SESSIONTMPOLIA to a permanent table by dropping it and recreating it without the keyword temporary.
   For example in CAST version 6.3.1, run:
   Drop table SESSIONTMPOLIA
   /
   /****************** CREATE ORDER ******************/
   Create table SESSIONTMPOLIA
   (
   IDCNX NUMBER NULL ,
   IDSOURCE NUMBER NULL ,
   IDTARGET NUMBER NULL ,
   ACCTYPLO NUMBER NULL ,
   ACCTYPHI NUMBER NULL ,
   ACCTYPLO2 NUMBER NULL ,
   ACCTYPHI2 NUMBER NULL ,
   INTERNALLEVEL NUMBER NULL ,
   WAYS NUMBER NULL
   )
   ON COMMIT PRESERVE ROWS
   /
2. Connect to Enlighten
3. Run a call hierarchy 
4. WIthout clicking on the Continue button in the Preview Call hierarchy window, get the number of links by executing the following query:
   Select count ( * ) from SESSIONTMPOLIA
5. Clean the table before running a new call hierarchy by executing the following query:
   Truncate table SESSIONTMPOLIA