Databases Reference
In-Depth Information
'application name
AppName
As String * ESB_APPNAMELEN
'database name
Name
As String * ESB_DBNAMELEN
'country dimension
Country
As String * ESB_MBRNAMELEN
'time dimension
Time
As String * ESB_MBRNAMELEN
'category dimension
Category
As String * ESB_MBRNAMELEN
'type dimension
Type
As String * ESB_MBRNAMELEN
'curr partition member
CrPartition
As String * ESB_MBRNAMELEN
' Database Type
DbType
As Integer
'database load status
Status
As Integer
nConnects As Integer
'number of users
connected
'number of blocks locked
nLocks
As Integer
'data loaded flag
Data
As Integer
End Type
There sure is a lot of information passed back from this call. Now do you remember
back a little bit that the variable name used in this API call is
DbInfo
? Yes, the
variable
DbInfo
, dimensioned using the variable structure above, now contains all
of the data that is listed in the
ESB_DBINFO_T
structure.
To read any of the information returned in this structure, the steps are very easy.
For instance, if you want to read how many users are connected to the database you
returned the information from just code:
variable = DbInfo.nConnects
and your
variable will now contain the number of users connected to the database. You can
also use
DbInfo.nConnects
elsewhere in your program depending on how you
dimensioned it.
Essbase API code sample blocks
It seems that for most good programmers, the only difference between programming
languages is the syntax of the code itself. Let's face it, logic is logic, and
If
means
If
and
End If
means
End If
in all programming languages. The syntax may vary
though, as we've all seen
End If
or
End-If
or
ENDIF
.
