[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference azur::mcc

Title:DECmcc user notes file. Does not replace IPMT.
Notice:Use IPMT for problems. Newsletter location in note 6187
Moderator:TAEC::BEROUD
Created:Mon Aug 21 1989
Last Modified:Wed Jun 04 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:6497
Total number of notes:27359

2262.0. "Exporter STATES/SUBSTATES ?" by ANNECY::BONNIER (Jean-Luc ... EIC/T&N Annecy France) Tue Feb 04 1992 13:33

On our project, we use intensively the Exporter FM with DECmcc BMS T1.2.4.

When analyzing the VMS/Rdb database, we need to know how to process
the following SQL parameters:

MCC_NODE4		STATE(integer)		possible values?
						meaning of these values ?
						(state on/off/...?)

MCC_NODE4_CIRCUIT	STATE(integer)		possible values?
			SUBSTATE(integer)	how does state work 
						with substate ?

MCC_NODE4_LINE		STATE(integer)		possible values?
			SUBSTATE(integer)	how does state work 
						with substate ?
MCC_NODE		STATE(quadword??)	possible values?

MCC_NODE_CSMACD_STATION	STATE(integer)		possible values?

MCC_NODE_ROUTING_CIRCUIT STATE(quadword??)	possible values?


Thanks.
Jean-Luc
T.RTitleUserPersonal
Name		DateLines
2262.1TOOK::SHMUYLOVICHTue Feb 04 1992 21:40146
	State and substate columns represent a corresponding attributes
for the specified entities. I do not know how they work.
The best place to look at is MRM or you can use the DAP utility to 
look how these attributes are defined in the data dictionary. I believe
that tool kit manual describes how to use DAP.
 
DAP> show class node4 attribute state Definition CONSTRUCTOR_DATA_TYPE

   Definition Name = CONSTRUCTOR_DATA_TYPE
   Type = T   Length = 31   Count = 1   Defined = TRUE   Class = S   Usage = ILV

         (
          1 = (
this  ------> 0 = %X    4F6E -- "On"  ----------------------> this
is a  ------> 1 = %X    4F6666 -- "Off"---------------------> is an 
value ------> 2 = %X    53687574 -- "Shut"------------------> "actual"
in RDB -----> 3 = %X    52657374726963746564 -- "Restricted"> values
            )         )


DAP> show class node4 attribute state Definition VALUE_DATA_TYPE

   Definition Name = VALUE_DATA_TYPE
   Type = L   Length = 4   Count = 1   Defined = TRUE   Class = S
   value[1] = 10 -------------------------------------------------> data type MCC_K_DT_ENUMERATION wich is converted to the
	                                                            integer. Quadword is a result of converting 
								    MCC_K_DT_INTEGER64 ( value 32) to RDB data type. Please 
								    check your data dictionary.

DAP> show class node4 subclass circuit attribute state Definition CONSTRUCTOR_DATA_TYPE

   Definition Name = CONSTRUCTOR_DATA_TYPE
   Type = T   Length = 31   Count = 1   Defined = TRUE   Class = S   Usage = ILV

         (
          1 = (
              0 = %X    4F6E -- "On"
              1 = %X    4F6666 -- "Off"
              2 = %X    53657276696365 -- "Service"
              3 = %X    436C6561726564 -- "Cleared"
            )         )


DAP> show class node4 subclass circuit attribute substate Definition CONSTRUCTOR_DATA_TYPE

   Definition Name = CONSTRUCTOR_DATA_TYPE
   Type = T   Length = 149   Count = 1   Defined = TRUE   Class = S   Usage = ILV

         (
          1 = (
              0 = %X    5374617274696E67 -- "Starting"
              1 = %X    5265666C656374696E67 -- "Reflecting"
              2 = %X    4C6F6F70696E67 -- "Looping"
              3 = %X    4C6F6164696E67 -- "Loading"
              4 = %X    44756D70696E67 -- "Dumping"
              5 = %X    54726967676572696E67 -- "Triggering"
              6 = %X    4175746F73657276696365 -- "Autoservice"
              7 = %X    4175746F6C6F6164696E67 -- "Autoloading"
              8 = %X    4175746F64756D70696E67 -- "Autodumping"
              9 = %X    4175746F74726967676572696E67 -- "Autotriggering"
              10 = %X    53796E6368726F6E697A696E67 -- "Synchronizing"
              11 = %X    4661696C6564 -- "Failed"
              12 = %X    4E6F6E65 -- "None"
            )         )


DAP> show class node4 subclass line attribute substate Definition CONSTRUCTOR_DATA_TYPE

   Definition Name = CONSTRUCTOR_DATA_TYPE
   Type = T   Length = 149   Count = 1   Defined = TRUE   Class = S   Usage = ILV

         (
          1 = (
              0 = %X    5374617274696E67 -- "Starting"
              1 = %X    5265666C656374696E67 -- "Reflecting"
              2 = %X    4C6F6F70696E67 -- "Looping"
              3 = %X    4C6F6164696E67 -- "Loading"
              4 = %X    44756D70696E67 -- "Dumping"
              5 = %X    54726967676572696E67 -- "Triggering"
              6 = %X    4175746F73657276696365 -- "Autoservice"
              7 = %X    4175746F6C6F6164696E67 -- "Autoloading"
              8 = %X    4175746F64756D70696E67 -- "Autodumping"
              9 = %X    4175746F74726967676572696E67 -- "Autotriggering"
              10 = %X    53796E6368726F6E697A696E67 -- "Synchronizing"
              11 = %X    4661696C6564 -- "Failed"
              12 = %X    4E6F6E65 -- "None"
            )         )


DAP> show class node attribute state Definition CONSTRUCTOR_DATA_TYPE

   Definition Name = CONSTRUCTOR_DATA_TYPE
   Type = T   Length = 28   Count = 1   Defined = TRUE   Class = S   Usage = ILV

         (
          1 = (
              0 = %X    44656164 -- "Dead"
              1 = %X    426F6F74696E67 -- "Booting"
              2 = %X    4F6666 -- "Off"
              3 = %X    4F6E -- "On"
            )         )


DAP> show class node attribute state Definition value_data_type

   Definition Name = VALUE_DATA_TYPE
   Type = L   Length = 4   Count = 1   Defined = TRUE   Class = S
   value[1] = 10

DAP> show class node subclass csmacd subclass station attribute state Definition CONSTRUCTOR_DATA_TYPE

   Definition Name = CONSTRUCTOR_DATA_TYPE
   Type = T   Length = 35   Count = 1   Defined = TRUE   Class = S   Usage = ILV

         (
          1 = (
              0 = %X    4F6666 -- "Off"
              1 = %X    496E697469616C697A696E67 -- "Initializing"
              2 = %X    4F6E -- "On"
              3 = %X    4661696C6564 -- "Failed"
            )         )


DAP> show class node subclass routing subclass circuit attribute state Definition CONSTRUCTOR_DATA_TYPE

   Definition Name = CONSTRUCTOR_DATA_TYPE
   Type = T   Length = 13   Count = 1   Defined = TRUE   Class = S   Usage = ILV

         (
          1 = (
              0 = %X    4F6666 -- "Off"
              1 = %X    4F6E -- "On"
            )         )


DAP> show class node subclass routing subclass circuit attribute state Definition value_data_type

   Definition Name = VALUE_DATA_TYPE
   Type = L   Length = 4   Count = 1   Defined = TRUE   Class = S
   value[1] = 10


	Regards, SAm