| 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 |
This may have already been asked but I could not find it. Regarding the data type conversions that the exporter performs, with ULTRIX/SQL how does it export/translate: 1. "SET OF" attributes? 2. User defined data types? 3. Enumerated data types? Carl
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 1258.1 | data type conversion table | TOOK::SHMUYLOVICH | Wed Jul 17 1991 10:48 | 59 | |
> Regarding the data type conversions that the exporter performs, with
>ULTRIX/SQL how does it export/translate:
>
> 1. "SET OF" attributes? --------> not supported
>
> 2. User defined data types? ------> what do you mean by "user defined"
datatypes?
>
> 3. Enumerated data types? ------> INTEGER
The following table represents the conversion of the MCC data types to
the the equivalent SQL data types used by the Exporter FM.
The Exporter FM does NOT export attributes whose data types are not listed
in this table .
-------------------------------------------------------------------------------
| | SQL data type | | |
| MCC data type |-----------------| SQL field length | Comment |
| | VMS | Ultrix | | |
|-----------------------------------------------------------------------------|
|MCC_K_DT_BOOLEAN |SMALLINT|SMALLINT| - | |
|MCC_K_DT_INTEGER8 |SMALLINT|SMALLINT| - | |
|MCC_K_DT_INTEGER16 |SMALLINT|SMALLINT| - | |
|MCC_K_DT_INTEGER32 |INTEGER |INTEGER | - | |
|MCC_K_DT_INTEGER64 |QUADWORD|INTEGER | - | |
|MCC_K_DT_UNSIGNED8 |SMALLINT|SMALLINT| - | |
|MCC_K_DT_UNSIGNED16 |INTEGER |INTEGER | - | |
|MCC_K_DT_UNSIGNED32 |QUADWORD|INTEGER | - | |
|MCC_K_DT_UNSIGNED64 |QUADWORD|INTEGER | - | |
|MCC_K_DT_COUNTER16 |INTEGER |INTEGER | - | |
|MCC_K_DT_COUNTER32 |QUADWORD|INTEGER | - | |
|MCC_K_DT_COUNTER48 |QUADWORD|INTEGER | - | |
|MCC_K_DT_COUNTER64 |QUADWORD|INTEGER | - | |
|MCC_K_DT_COUNTER16 |INTEGER |INTEGER | - | |
|MCC_K_DT_COUNTER32 |QUADWORD|INTEGER | - | |
--->|MCC_K_DT_ENUMERATION |QUADWORD|INTEGER | - | |
|MCC_K_DT_FILE_SPEC |CHAR |CHAR | 255 | |
|MCC_K_DT_LATIN1STRIN |CHAR |CHAR | 132 | |
|MCC_K_DT_SIMPLE_NAME |CHAR |CHAR | 255 |dns$k_simplestrmax
|MCC_K_DT_FULL_NAME |CHAR |CHAR | 512 |dns$k_fullstrmax |
|MCC_K_DT_VERSION |CHAR |CHAR | 12 | |
|MCC_K_DT_PHASE4NAME |CHAR |CHAR | 7 | |
|MCC_K_DT_PHASE4ADDRESS|CHAR |CHAR | 7 | |
|MCC_K_DT_REAL |FLOAT |FLOAT | - | |
|MCC_K_DT_BIN_ABS_TIM |TIME |DATE | - | |
|MCC_K_DT_BIN_REL_TIM |TIME |DATE | - | |
|MCC_K_DT_ADDRESS_DTE |CHAR |CHAR | 44 | |
|MCC_K_DT_ID802 |CHAR |CHAR | 17 | |
|MCC_K_DT_ID802_SNAP |CHAR |CHAR | 14 | |
|MCC_K_DT_ID802_SAP |CHAR |CHAR | 2 | |
|MCC_K_DT_IDENETV2_TYPE|CHAR |CHAR | 5 | |
|MCC_K_DT_IPADDRESS |CHAR |CHAR | 15 | |
|MCC_K_DT_INTERNET_NAME|CHAR |CHAR | 255 | |
-------------------------------------------------------------------------------
This table represents the latest data type conversion rules.
Now on Ultrix MCC_K_DT_BIN_ABS_TIM and MCC_K_DT_BIN_REL_TIM data types are
translated to "DATA".
| |||||
| 1258.2 | Bridge Address is SET OF ID802 | CHRISB::BRIENEN | DECmcc Bridge|Station|SNMP Management. | Wed Jul 17 1991 11:57 | 10 |
One of the implications of this EXPORTER (and HISTORIAN) limitation is that the Bridge identifier named ADDRESS does not get export (but NAME does). Note that for LAN Bridge 150, LAN Bridge 200, DECbridge 5xx, and DECbridge 6xx, individual port addresses are available under the LINE Child Entity (Characteristic Attribute = PORT ADDRESS). Unfortunately, this attribute doesn't apply to LAN Bridge 100. Chris | |||||