com.tivoli.twg.inventory
Class TWGSystemLocationTable

java.lang.Object
  extended bycom.tivoli.twg.engine.TWGObject
      extended bycom.tivoli.twg.engine.TWGPersistentObject
          extended bycom.tivoli.twg.engine.TWGDatabaseTable
              extended bycom.tivoli.twg.inventory.TWGSystemLocationTable

public class TWGSystemLocationTable
extends TWGDatabaseTable

SQL database table for System Location information

Primary key - MANAGED_OBJ_ID

TWG_SYSTEM_LOCATION
Field Name Data Type Description NT/2000 95/98 OS/2 Netware AS/400 SNMP AIX HPUX Solaris Unixware Linux
MANAGED_OBJ_ID INT Managed object id X X X X X X X X
CITY CHAR(32) City X X X X X X X X
STATE CHAR(32) State X X X X X X X X
ZIPCODE CHAR(16) Zip code X X X X X X X X
COUNTRY CHAR(32) Country X X X X X X X X
ROOM_NUMBER CHAR(32) Room number X X X X X X X X
BUILDING CHAR(32) Building X X X X X X X X
FLOOR CHAR(32) Floor X X X X X X X X
LATITUDE CHAR(32) Latitude X X X X X X X X
LONGITUDE CHAR(32) Longitude X X X X X X X X
USER_DATA1 CHAR(255) User specific data 1 X X X X X X X X
USER_DATA2 CHAR(255) User specific data 2 X X X X X X X X


Note: For NT/2000 and 95/98, these fields are populated only if the client manually updates twguser.ini in \TivoliWg\data
Note: For OS/2, these fields are populated only if the client manually updates twguser.ini in \TivoliWg
Note: For AIX, these fields are populated only if the client manually updates TWGUser.properties in /usr/opt/tivoliwg/data
Note: For HPUX, Solaris, Unixware, Linux, these fields are populated only if the client manually updates TWGUser.properties in /opt/tivoliwg/data


Field Summary
static java.lang.String BUILDING
           
static java.lang.String CITY
           
static java.lang.String COUNTRY
           
static java.lang.String FLOOR
           
static java.lang.String LATITUDE
           
static java.lang.String LONGITUDE
           
static java.lang.String MANAGED_OBJ_ID
           
static java.lang.String ROOM_NUMBER
           
static java.lang.String SHORT_TABLE_NAME
           
static java.lang.String STATE
           
static java.lang.String TABLE_NAME
           
static java.lang.String TABLE_VERSION
           
static java.lang.String USER_DATA1
           
static java.lang.String USER_DATA2
           
static java.lang.String ZIPCODE
           
 
Fields inherited from class com.tivoli.twg.engine.TWGDatabaseTable
CLASSNAME, DbKeyWords, DEFAULT_TABLE_BUNDLE_NAME, validChars
 
Fields inherited from class com.tivoli.twg.engine.TWGPersistentObject
CLASS_NAME, SIZEOF_BYTE, SIZEOF_CHAR, SIZEOF_DOUBLE, SIZEOF_FLOAT, SIZEOF_INT, SIZEOF_LONG, SIZEOF_SHORT
 
Constructor Summary
TWGSystemLocationTable()
           
 
Method Summary
 void create()
          Abstract method must be overriden by subclass to define the table.
 java.lang.String getTableVersion()
          Abstract method must be overriden by subclass to get the version for table
 
Methods inherited from class com.tivoli.twg.engine.TWGDatabaseTable
deleteManagedObject, deleteTable, findTableByClassName, flatten, getAllFullColumnNames, getAllTrue, getAllTrueForSame, getAnyTrue, getBundleName, getBundleString, getColumn, getColumnByColumnRealName, getColumnLength, getColumnLength, getColumnLengths, getColumns, getColumnType, getColumnType, getColumnTypes, getDatabase, getDefaultValue, getDefaultValue, getDefaultValues, getDisplayColumnName, getDisplayFullColumnNames, getDisplayName, getDisplayValues, getEachTrueForAtLeastOne, getFilterColumns, getFilterPrompt, getFilterSQL, getGraphicName, getKey, getMatchingMoids, getMultiLocaleBundle, getMyClassName, getNumberOfColumns, getRealColumnName, getRealColumnName, getRealColumnNames, getRealName, getShortClassName, getTable, getTableBy, getTableByRealTableName, getTableInfo, getTableMultiLocaleBundle, getTableName, getTables, getTokenColumnNames, getTokenName, insertOrDeleteRow, insertRow, isFilterColumn, isMappedColumn, restoreData, saveData, setShortTableName, toString, TWGInitTable, userTableFixClassName
 
Methods inherited from class com.tivoli.twg.engine.TWGPersistentObject
Destroy, enableAsyncWrites, fromPersistID, initialize, isNewPersistentStore, isSaveRequired, PersistID, restore, restoreAll, save, save, setSaveRequired, terminate, toPersistID
 
Methods inherited from class com.tivoli.twg.engine.TWGObject
AllObjects, AllObjects, Delete, DumpTWGObjects, FindObject, isDeleted, isNewObject, isPersistent, isPersistent, isValid, isValid, ObjectID, setDistinctObjectID, SetObjectID
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Field Detail

TABLE_NAME

public static final java.lang.String TABLE_NAME
See Also:
Constant Field Values

SHORT_TABLE_NAME

public static final java.lang.String SHORT_TABLE_NAME
See Also:
Constant Field Values

MANAGED_OBJ_ID

public static final java.lang.String MANAGED_OBJ_ID
See Also:
Constant Field Values

CITY

public static final java.lang.String CITY
See Also:
Constant Field Values

STATE

public static final java.lang.String STATE
See Also:
Constant Field Values

ZIPCODE

public static final java.lang.String ZIPCODE
See Also:
Constant Field Values

COUNTRY

public static final java.lang.String COUNTRY
See Also:
Constant Field Values

ROOM_NUMBER

public static final java.lang.String ROOM_NUMBER
See Also:
Constant Field Values

BUILDING

public static final java.lang.String BUILDING
See Also:
Constant Field Values

FLOOR

public static final java.lang.String FLOOR
See Also:
Constant Field Values

LATITUDE

public static final java.lang.String LATITUDE
See Also:
Constant Field Values

LONGITUDE

public static final java.lang.String LONGITUDE
See Also:
Constant Field Values

USER_DATA1

public static final java.lang.String USER_DATA1
See Also:
Constant Field Values

USER_DATA2

public static final java.lang.String USER_DATA2
See Also:
Constant Field Values

TABLE_VERSION

public static final java.lang.String TABLE_VERSION
See Also:
Constant Field Values
Constructor Detail

TWGSystemLocationTable

public TWGSystemLocationTable()
Method Detail

create

public void create()
            throws TWGDbException
Description copied from class: TWGDatabaseTable
Abstract method must be overriden by subclass to define the table.

Specified by:
create in class TWGDatabaseTable
Throws:
TWGDbException

getTableVersion

public java.lang.String getTableVersion()
Description copied from class: TWGDatabaseTable
Abstract method must be overriden by subclass to get the version for table

Specified by:
getTableVersion in class TWGDatabaseTable
Returns:
the version id for this table