mi_string* mi_tab_spaceloc(MI_AM_TABLE_DESC *tableDesc)

tableDesc

points to the table descriptor.

A user, usually a database system administrator, can assign a short name to an extspace with the onspaces utility. When a user creates a table, the CREATE TABLE statement can include an IN clause to specify one of the following:

• The name that is assigned with the onspaces utility
• A string that contains the actual location

To find out the string that the user specifies as the storage space, call the mi_tab_spaceloc() function.

For example, the mi_tab_spaceloc() function returns the string host=dcserver,port=39 for a storage space that the following commands specify:

onspaces -c -x dc39 -l "host=dcserver,port=39"
CREATE TABLE remote...
   IN dc39
   USING access_method 

A string identifies the extspace.

If the table resides in an sbspace, this function returns a NULL-valued pointer.