[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

2059.0. "Exporter FM and Node4 names ?" by ANNECY::BONNIER (Jean-Luc ... EIC/T&N Annecy France) Fri Jan 10 1992 04:29

I am running the DECmcc BMS T1.2.3 on a VAXstation.

I use intensively the Exporter FM to create different VMS/Rdb databases.

After an EXPORT NODE4 ANNECY LINE SVA-0 EXPORT TARGET ... command,
I'd like to get the Node4 Name (and not the address) with:

	SQL> SELECT Node4 FROM MCC_NODE4_LINE;

This command gives 48.135 and not ANNECY.

It was already true with BMS 1.1.

Is there another way to get the Nodename ?

Thanks in advance.
JLuc
T.RTitleUserPersonal
Name		DateLines
2059.1MCC_NODE4_LINE table does not contain Node4 nameTOOK::SHMUYLOVICHFri Jan 10 1992 09:3149

	Each Rdb table created by the Exporter FM contains identification 
 information for the corresponding entity and all attributes in all partitions.
 An entity identification information is built from the entity_out received
 in MCC_call with verb = Show and partition = Identifiers.

	Node4 has three valid identifiers:
			- Name,
			- Address,
			- Registered Name.

	When you do an MCC_call to Show attributes for Node4 or for Node4 
 children an instance for entity_out is always presented by a primary
 identifier. In the case of Node4 primary identifier is an address.
 For example,

	MCC> show node4 rudone line sva-0
	Using default ALL IDENTIFIERS

----->	Node4 4.773 Line sva-0
	AT 10-JAN-1992 09:11:47 Identifiers

	Examination of Attributes shows:
		                           Name = SVA-0	
	MCC>

	The only way you can find a Node4 name is to use MCC_NODE4 table
	(of course, you have to set up a corresponding exporting request).
	The MCC_NODE4 table contains a column NAME (an attribute from 
	identifiers partition).

	So your problem can be solved as follow:

	  1. To set up two exporting requests:
		 - for NODE4 ANNECY and
		 - for NODE4 ANNECY LINE SVA-0
	
	  2. Do 
		SQL> SELECT Node4 FROM MCC_NODE4_LINE;

	     and receive an Node4 Address.

	  3. Do 
		SQL> SELECT Name FROM MCC_NODE4 WHERE NODE4 = 48.135;


	Sam