File Name
Syntax
ConnectSMS( REF smsDataSource: INTEGER )
Parameters
currentDataSource - SMS datasource connection
Returns
BOOLEAN: TRUE if connection to SMS data source is
successful, FALSE if not.
Side Effects
Changes the current database connection from the TSD database to the SMS database
Description
This function will try to connect to the SMS database using the SMS data source passed in. If it does, then the current application connection becomes SMS and not the TSD default
Dialog Forms Called
None
File Name
Syntax
CountSMSIDs( REF smsHandle: INTEGER )
Parameters
smsHandle - The SMS database connetion used
to connect to the SMS database
Returns
INTEGER: The number of distinct IDENTIFICATION_SPEC records
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects a count of the distinct SMSID0 records found on the SMS IDENTIFICATION_SPEC table and returns this number using the return value of the function.
Dialog Forms Called
None
File Name
Syntax
DoesLanguageViewExist( VAL smsHandle: INTEGER )
Parameters
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
BOOLEAN: TRUE if the table exists, FALSE if not
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects SMS_EFM_LANG from the SMS platform sysobjects table and determines if the table exists or not. This is used to determine version of SMS platform.
Dialog Forms Called
None
File Name
Syntax
DoesSoftwareTableExist( VAL smsHandle: INTEGER )
Parameters
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
BOOLEAN: TRUE if the table exists, FALSE if not
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects Audited_Software_SPEC from the SMS platform sysobjects table and determines if the table exists or not. This is used to determine version of SMS platform.
Dialog Forms Called
None
File Name
Syntax
FetchAssetsByScanDate ( REF idSpecRecList: LIST OF IdentificationSpecRec, VAL scandate: DATE, REF smsHandle: INTEGER )
Parameters
idSpecList - List of IdentificationSpecRec to be populated
scandate - The date used as a filter in the select clause
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
By REFERENCE - idSpecList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Calls FindSMSGroupKey, SMS_GetWorkstationStatus, SMS_GetMachineData, and SMS_GetIdentificationSpecOrder in order to populate a list of IdentificationSpecRec
Dialog Forms Called
None
File Name
Syntax
FindSMSGroupKey( VAL GroupNameToFind: STRING )
Parameters
GroupNameToFind - Group to find in the GroupMapList
Returns
INTEGER: the index of the groupMapList that
cooresponds to the GroupNameToFind
Side Effects
None
Description
Calls FindSMSGroupKey, SMS_GetWorkstationStatus, SMS_GetMachineData, and SMS_GetIdentificationSpecOrder in order to populate a list of IdentificationSpecRec
Dialog Forms Called
None
File Name
Syntax
GetABlockOfSMSIDs( REF smsHandle: INTEGER, REF smsIDList: LIST OF STRING, REF SMSID0: STRING, VAL logicalUnitOfWork: INTEGER )
Parameters
smsHandle - The SMS database connetion used
to connect to the SMS database
smsIDList - list of SMSID0 to be returned
SMSID0 - used as a starting point for a query, can
be unknown and if so, this will start the query at the
beginning and in the natural order of the data
logicalUnitOfWork - the number of records to process or
also known as the number of records that constitues
a block of SMSID0s
Returns
INTEGER: database select return code
By REFERENCE: smsIDList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects the SMSID0 from the SMS Table identification_spec and a list of SMSID0s in the smsIDList parameter.
Dialog Forms Called
None
File Name
Syntax
SMS_DeleteMigFileRec( VAL where: STRING, REF advHandle: INTEGER )
Parameters
where - The where statement passed in used for the delete
advHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
Side Effects
Sets the connection temporarily to the TSD database connection then back to the orginal connection.
Description
Will delete a record from the TSD I_SMS_MIGRATION table
Dialog Forms Called
None
File Name
Syntax
SMS_GetArchitectureKey( REF ArchitectureKey: INTEGER, VAL Select: STRING, VAL Where: STRING, REF smsHandle: INTEGER )
Parameters
ArchitectureKey - integer, the architectureKey value
from the SMS ArchitectureMap table
Select - The select statement passed in.
where - The where statement passed in. Can be unknown
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
By REFERENCE: ArchitectureKey
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects a record from the SMS ArchitectureMap table, populate/passback the ArchitectureKey parameter
Dialog Forms Called
None
File Name
Syntax
SMS_GetAttributeDataTypes( REF DataType: STRING, VAL select: STRING, VAL where: STRING, REF advHandle: INTEGER )
Parameters
DataType - The dataType of the column in question
select - The select statement passed in.
where - The where statement passed in. Can be unknown
advHandle - The TSD database connetion used to connect to
the TSD database
Returns
INTEGER: The database return value
By REFERENCE: DataType
Side Effects
None
Description
Will select the datatype for the column based on the select and where statements from the TSD SAI_SYSCOLUMNS and pass this back in the DataType parameter
Dialog Forms Called
None
File Name
Syntax
SMS_GetAuditedSWComm( REF AuditedSWCommList: LIST OF AuditedSWCommRec, REF select: STRING, VAL where: STRING, REF smsHandle: INTEGER )
Parameters
AuditedSWCommList: LIST OF AuditedSWCommRec from the SMS
Audited_Software_COMM table
select - The select statement passed in.
where - The where statement passed in. Can be unknown
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
By REFERENCE: AuditedSWCommList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects multiple records from the SMS Audited_Software_COMM table based on the where statement passed in and populates/passes back the AuditedSWCommList
Dialog Forms Called
None
File Name
Syntax
SMS_GetAuditedSWSpec( REF AuditedSWSpecList: LIST OF AuditedSWSpecRec, REF select: STRING, VAL where: STRING, REF smsHandle: INTEGER )
Parameters
AuditedSWSpecList: LIST OF AuditedSWSpecRec from the SMS
Audited_Software_SPEC table
select - The select statement passed in.
where - The where statement passed in. Can be unknown
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
By REFERENCE: AuditedSWSpecList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects multiple records from the SMS Audited_Software_SPEC table based on the where statement passed in and populates/passes back the AuditedSWSpecList
Dialog Forms Called
None
File Name
Syntax
SMS_GetDiskComm( REF DiskCommList: LIST OF DiskCommRec, REF select: STRING, VAL where: STRING, REF smsHandle: INTEGER )
Parameters
DiskCommList: LIST OF DiskCommRec from the SMS
Disk_COMM table
select - The select statement passed in.
where - The where statement passed in. Can be unknown
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
By REFERENCE: DiskCommList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects multiple records from the SMS Disk_COMM table based on the where statement passed in and populates/passes back the DiskCommList and will order these records by Storage_Type0 is the where is unknown and the select = 'STORAGE' or if the where is known
Dialog Forms Called
None
File Name
Syntax
SMS_GetDiskSpec( REF DiskSpecList: LIST OF DiskSpecRec, REF select: STRING, VAL where: STRING, REF smsHandle: INTEGER )
Parameters
DiskSpecList: LIST OF DiskSpecRec from the SMS
Disk_SPEC table
select - The select statement passed in.
where - The where statement passed in. Can be unknown
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
By REFERENCE: DiskSpecList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects multiple records from the SMS Disk_SPEC table based on the where statement passed in and populates/passes back the DiskSpecList
Dialog Forms Called
None
File Name
Syntax
SMS_GetEFMAttributeMap( REF EFMEntityTableColumnList: LIST OF EFMEntityTableColumnRec, VAL where: STRING, REF advHandle: INTEGER )
Parameters
EFMEntityTableColumnList - List of EFMEntityTableColumnRec
where - The where statement passed in. Can be unknown
advHandle - The TSD database connetion used to connect to
the TSD database
Returns
INTEGER: The database return value
By REFERENCE: EFMEntityTableColumnList
Side Effects
Sets the connection temporarily to the TSD database connection then back to the orginal connection.
Description
Will select records from the TSD I_ATTRIBUTE_MAP table, populate/passback the EFMEntityTableColumnList record
Dialog Forms Called
None
File Name
Syntax
SMS_GetEFMStringValidationData( REF StringDataList: LIST OF STRING, REF select: STRING, VAL where: STRING, VAL from: STRING, REF advHandle: INTEGER )
Parameters
StringDataList - List of attributes from the SMS AttributeMap table
Select - The select statement passed in.
where - The where statement passed in. Can be unknown
from - the table which will be used in the select statement.
advHandle - The TSD database connetion used to connect to
the TSD database
Returns
INTEGER: The database return value
By REFERENCE: StringDataList
By REFERENCE: ColumnList
By REFERENCE: ValueTypeList
Side Effects
Sets the connection temporarily to the TSD database connection then back to the orginal connection.
Description
Selects multiple records from the TSD table identified in the from parameter and passes back a list of strings in the StringDataList as identified by the select and where parameters
Dialog Forms Called
None
File Name
Syntax
SMS_GetEnvironmentSpec( REF EnvironmentSpecList: LIST OF EnvironmentSpecRec, REF select: STRING, VAL where: STRING, REF smsHandle: INTEGER )
Parameters
EnvironmentSpecList: LIST OF EnvironmentSpecRec from the SMS
Environment_SPEC table
select - The select statement passed in.
where - The where statement passed in. Can be unknown
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
By REFERENCE: EnvironmentSpecList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects multiple records from the SMS Environment_SPEC table based on the where statement passed in and populates/passes back the EnvironmentSpecList
Dialog Forms Called
None
File Name
Syntax
SMS_GetGroupMapList( REF GroupMapList: LIST of GroupMap_MappingRec, VAL Select: STRING, VAL Where: STRING, REF smsHandle: INTEGER )
Parameters
GroupMapList - List of GroupMap_MappingRec
Select - The select statement passed in.
where - The where statement passed in. Can be unknown
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
By REFERENCE: GroupMapList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects multiple records from the SMS GroupMap table, populate/passback the GroupMapList parameter
Dialog Forms Called
None
File Name
Syntax
SMS_GetIdentificationSpec( REF idSpecList: LIST OF IdentificationSpecRec, REF select: STRING, VAL where: STRING, REF smsHandle: INTEGER )
Parameters
idSpecList - List of IdentificationSpecRec to be populated
select - The select statement passed in. Can be unknown.
where - The where statement passed in. Can be unknown
smsHandle - The SMS database connetion used
to connect to the SMS database
Returns
INTEGER: The database return value
By REFERENCE - idSpecList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects either all records or those defined by the select and the where statment passed in from the SMS Identification_SPEC table and populates a list of IdentificationSpecRec passed back in the parameter idSpecList
Dialog Forms Called
None
File Name
Syntax
SMS_GetIdentificationSpecOrder( REF idSpecList: LIST OF IdentificationSpecRec, REF select: STRING, VAL from: STRING, VAL where: STRING, VAL orderby: STRING, REF smsHandle: INTEGER )
Parameters
idSpecList - List of IdentificationSpecRec to be populated
select - The select statement passed in. Can be unknown.
from - The table to select data from
where - The where statement passed in. Can be unknown
orderby - the order by clause for the select statement. Can
be unknown
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
By REFERENCE - idSpecList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects either all records or those defined by the select, the where and the orderby statment passed in, the SMS table also passed in and populates a list of IdentificationSpecRec passed back in the parameter idSpecList
Dialog Forms Called
None
File Name
Syntax
SMS_GetMachineData( REF machineDataList: LIST OF MachineDataRec, REF select: STRING, VAL where: STRING, REF smsHandle: INTEGER )
Parameters
machineDataList: LIST OF MachineDataRec from the SMS
MachineDataTable table
select - The select statement passed in.
where - The where statement passed in. Can be unknown
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
By REFERENCE: machineDataList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects multiple records from the SMS MachineDataTable table based on the where statement passed in and populates/passes back the machineDataList
Dialog Forms Called
None
File Name
Syntax
SMS_GetMappingData(REF select: STRING, VAL from: STRING, VAL where: STRING, REF $SQLColumn_1: STRING, REF $SQLColumn_2: STRING, REF $SQLColumn_3: STRING, REF $SQLColumn_4: STRING, REF $SQLColumn_5: STRING, REF $SQLColumn_6: STRING, REF $SQLColumn_7: STRING, REF $SQLColumn_8: STRING, REF $SQLColumn_9: STRING, REF $SQLColumn_10: STRING, REF smsHandle: INTEGER )
Parameters
Select - The select statement passed in.
where - The where statement passed in. Can be unknown
from - the table which will be used in the select statement.
$SQLColumn_1 - String value representing column data
$SQLColumn_2 - String value representing column data
$SQLColumn_3 - String value representing column data
$SQLColumn_4 - String value representing column data
$SQLColumn_5 - String value representing column data
$SQLColumn_6 - String value representing column data
$SQLColumn_7 - String value representing column data
$SQLColumn_8 - String value representing column data
$SQLColumn_9 - String value representing column data
$SQLColumn_10 - String value representing column data
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
By REFERENCE: $SQLColumn_1
By REFERENCE: $SQLColumn_2
By REFERENCE: $SQLColumn_3
By REFERENCE: $SQLColumn_4
By REFERENCE: $SQLColumn_5
By REFERENCE: $SQLColumn_6
By REFERENCE: $SQLColumn_7
By REFERENCE: $SQLColumn_8
By REFERENCE: $SQLColumn_9
By REFERENCE: $SQLColumn_10
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects a record from the SMS table identified in the from parameter and passes back a list of strings in the $SQLColumn_x parameters as identified by the select and where parameters
Dialog Forms Called
None
File Name
Syntax
SMS_GetMifRecList( REF mifRecList: LIST OF SmsMifRec, REF select: STRING, VAL where: STRING, REF smsHandle: INTEGER )
Parameters
mifRecList: LIST OF SmsMifRec from the SMS
SMS_EFM_LANG table
select - The select statement passed in.
where - The where statement passed in. Can be unknown
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
By REFERENCE: mifRecList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects multiple records from the SMS SMS_EFM_LANG table based on the where statement passed in and populates/passes back the mifRecList parameter
Dialog Forms Called
None
File Name
Syntax
SMS_GetMigFileList( REF MigMapFileList: LIST OF MigMapFileRec, VAL where: STRING, REF advHandle: INTEGER )
Parameters
MigMapFileList - List of MigMapFileRec to be populated
from the TSD I_SMS_MIGRATION table
where - The where statement passed in. Can be unknown
advHandle - The TSD database connetion used to connect to
the TSD database
Returns
INTEGER: The database return value
Side Effects
Sets the connection temporarily to the TSD database connection then back to the orginal connection.
Description
Will select all records from the TSD I_SMS_MIGRATION table, populate/passback the MigMapFileList record
Dialog Forms Called
None
File Name
Syntax
SMS_GetMigMappingList( REF EFMSMS_MappingList: LIST OF EFMSMS_MappedRec, VAL where: STRING, REF advHandle: INTEGER )
Parameters
EFMSMS_MappingList - List of EFMSMS_MappedRec to be populated
from the TSD I_SMS_MIG_MAP table
where - The where statement passed in. Can be unknown
advHandle - The TSD database connetion used to connect to
the TSD database
Returns
INTEGER: The database return value
Side Effects
Sets the connection temporarily to the TSD database connection then back to the orginal connection.
Description
Will select all records from the TSD I_SMS_MIG_MAP table, populate/passback the EFMSMS_MappingList record
Dialog Forms Called
None
File Name
Syntax
SMS_GetNetcardComm( REF NetcardCommList: LIST OF NetcardCommRec, REF select: STRING, VAL where: STRING, REF smsHandle: INTEGER )
Parameters
NetcardCommList: LIST OF NetcardCommRec from the SMS
Netcard_COMM table
select - The select statement passed in.
where - The where statement passed in. Can be unknown
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
By REFERENCE: NetcardCommList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects multiple records from the SMS Netcard_COMM table based on the where statement passed in and populates/passes back the NetcardCommList
Dialog Forms Called
None
File Name
Syntax
SMS_GetNetcardSpec( REF NetcardSpecList: LIST OF NetcardSpecRec, REF select: STRING, VAL where: STRING, REF smsHandle: INTEGER )
Parameters
NetcardSpecList: LIST OF NetcardSpecRec from the SMS
Netcard_COMM table
select - The select statement passed in.
where - The where statement passed in. Can be unknown
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
By REFERENCE: NetcardSpecList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects multiple records from the SMS Netcard_COMM table based on the where statement passed in and populates/passes back the NetcardSpecList
Dialog Forms Called
None
File Name
Syntax
SMS_GetNetworkComm( REF NetworkCommList: LIST OF NetworkCommRec, REF select: STRING, VAL where: STRING, REF smsHandle: INTEGER )
Parameters
NetworkCommList: LIST OF NetworkCommRec from the SMS
Network_COMM table
select - The select statement passed in.
where - The where statement passed in. Can be unknown
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
By REFERENCE: NetworkCommList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects multiple records from the SMS Network_COMM table based on the where statement passed in and populates/passes back the NetworkCommList
Dialog Forms Called
None
File Name
Syntax
SMS_GetNetworkSpec( REF NetworkSpecList: LIST OF NetworkSpecRec, REF select: STRING, VAL where: STRING, REF smsHandle: INTEGER )
Parameters
NetworkSpecList: LIST OF NetworkSpecRec from the SMS
Network_SPEC table
select - The select statement passed in.
where - The where statement passed in. Can be unknown
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
By REFERENCE: NetworkSpecList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects multiple records from the SMS Network_SPEC table based on the where statement passed in and populates/passes back the NetworkSpecList
Dialog Forms Called
None
File Name
Syntax
SMS_GetOsComm( REF osCommList: LIST OF OSCommRec, REF select: STRING, VAL where: STRING, REF smsHandle: INTEGER )
Parameters
osCommList: LIST OF OSCommRec from the SMS
Operating_System_COMM table
select - The select statement passed in.
where - The where statement passed in. Can be unknown
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
By REFERENCE: osCommList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects multiple records from the SMS Operating_System_COMM table based on the where statement passed in and populates/passes back the osCommList and will order it by Operating_System_Name0 if select string equals 'OPERATING'
Dialog Forms Called
None
File Name
Syntax
SMS_GetOsSpec( REF osSpecList: LIST OF OsSpecRec, REF select: STRING, VAL where: STRING, REF smsHandle: INTEGER ): INTEGER
Parameters
osSpecList: LIST OF OsSpecRec from the SMS
Operating_System_SPEC table
select - The select statement passed in.
where - The where statement passed in. Can be unknown
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
By REFERENCE: osSpecList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects multiple records from the SMS Operating_System_SPEC table based on the where statement passed in and populates/passes back the osSpecList parameter
Dialog Forms Called
None
File Name
Syntax
SMS_GetPCMemorySpec( REF PCMemorySpecList: LIST OF PCMemorySpecRec, REF select: STRING, VAL where: STRING, REF smsHandle: INTEGER )
Parameters
PCMemorySpecList: LIST OF PCMemorySpecRec from the SMS
PC_Memory_SPEC table
select - The select statement passed in.
where - The where statement passed in. Can be unknown
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
By REFERENCE: PCMemorySpecList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects multiple records from the SMS PC_Memory_SPEC table based on the where statement passed in and populates/passes back the PCMemorySpecList
Dialog Forms Called
None
File Name
Syntax
SMS_GetProcessorComm( REF ProcessorCommList: LIST OF ProcessorCommRec, REF select: STRING, VAL where: STRING, REF smsHandle: INTEGER )
Parameters
ProcessorCommList: LIST OF ProcessorCommRec from the SMS
Processor_COMM table
select - The select statement passed in.
where - The where statement passed in. Can be unknown
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
By REFERENCE: ProcessorCommList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects multiple records from the SMS Processor_COMM table based on the where statement passed in and populates/passes back the ProcessorCommList
Dialog Forms Called
None
File Name
Syntax
SMS_GetServicesComm( REF ServicesCommList: LIST OF ServicesCommRec, REF select: STRING, VAL where: STRING, REF smsHandle: INTEGER )
Parameters
ServicesCommList: LIST OF ServicesCommRec from the SMS
Services_COMM table
select - The select statement passed in.
where - The where statement passed in. Can be unknown
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
By REFERENCE: ServicesCommList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects multiple records from the SMS Services_COMM table based on the where statement passed in and populates/passes back the ServicesCommList
Dialog Forms Called
None
File Name
Syntax
SMS_GetSites( REF SitesList: LIST OF SiteCodeRec, REF select: STRING, VAL where: STRING, REF smsHandle: INTEGER )
Parameters
SitesList: LIST OF SiteCodeRec from the SMS
Sites table
select - The select statement passed in.
where - The where statement passed in. Can be unknown
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
By REFERENCE: SitesList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects multiple records from the SMS Sites table based on the where statement passed in and populates/passes back the SitesList
Dialog Forms Called
None
File Name
Syntax
SMS_GetSysTypes( VAL select: STRING, REF SysTypeList: LIST OF sysTypeRec, REF smsHandle: INTEGER ): INTEGER
Parameters
select - The select statement passed in.
SysTypeList - List of sysTypeRec
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
By REFERENCE: SysTypeList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Will select all records from the SMS systypes table, populate/passback the SysTypeList record
Dialog Forms Called
None
File Name
Syntax
SMS_GetTableFieldList( REF AttributeList: LIST OF STRING, REF ColumnList: LIST OF STRING, REF ValueTypeList: LIST OF INTEGER, VAL Select: STRING, VAL Where: STRING, REF smsHandle: INTEGER )
Parameters
AttributeList - List of attributes from the SMS AttributeMap table
ColumnList - List of columns from the SMS AttributeMap table
ValueTypeList - List of valueTypes from the SMS AttributeMap table
Select - The select statement passed in.
where - The where statement passed in. Can be unknown
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
By REFERENCE: AttributeList
By REFERENCE: ColumnList
By REFERENCE: ValueTypeList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects multiple records from the SMS AttributeMap table, populate/passback the AttributeList, ColumnList, and ValueTypeList parameters
Dialog Forms Called
None
File Name
Syntax
SMS_GetUserInformationComm( REF UserInformationCommList: LIST OF UserInformationCommRec, REF select: STRING, VAL where: STRING, REF smsHandle: INTEGER )
Parameters
UserInformationCommList: LIST OF UserInformationCommRec from the SMS
User_Information_COMM table
select - The select statement passed in.
where - The where statement passed in. Can be unknown
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
By REFERENCE: UserInformationCommList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects multiple records from the SMS User_Information_COMM table based on the where statement passed in and populates/passes back the UserInformationCommList
Dialog Forms Called
None
File Name
Syntax
SMS_GetUserInformationSpec( REF UserInformationSpecList: LIST OF UserInformationSpecRec, REF select: STRING, VAL where: STRING, REF smsHandle: INTEGER )
Parameters
UserInformationSpecList: LIST OF UserInformationSpecRec from the SMS
User_Information_SPEC table
select - The select statement passed in.
where - The where statement passed in. Can be unknown
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
By REFERENCE: UserInformationSpecList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects multiple records from the SMS User_Information_SPEC table based on the where statement passed in and populates/passes back the UserInformationSpecList
Dialog Forms Called
None
File Name
Syntax
SMS_GetVideoComm( REF VideoCommList: LIST OF VideoCommRec, REF select: STRING, VAL where: STRING, REF smsHandle: INTEGER )
Parameters
VideoCommList: LIST OF VideoCommRec from the SMS
Video_COMM table
select - The select statement passed in.
where - The where statement passed in. Can be unknown
smsHandle - The SMS database connetion used to connect to
the SMS database
Returns
INTEGER: The database return value
By REFERENCE: VideoCommList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects multiple records from the SMS Video_COMM table based on the where statement passed in and populates/passes back the VideoCommList
Dialog Forms Called
None
File Name
Syntax
None
Parameters
None
Returns
None
Side Effects
None
Description
None
Dialog Forms Called
None
File Name
Syntax
SMS_InsertMigFileRec( REF MigMapRec: MigMapFileRec, REF EFMSMS_MappingList: LIST OF EFMSMS_MappedRec, REF advHandle: INTEGER ): INTEGER IS
Parameters
MigMapRec - Record used for the insert to the TSD
I_SMS_MIGRATION table
EFMSMS_MappingList - List of EFMSMS_MappedRec used to
insert records into the TSD I_SMS_MIG_MAP table
advHandle - The TSD database connetion used to connect to
the TSD database
Returns
INTEGER: The database return value
Side Effects
Sets the connection temporarily to the TSD database connection then back to the orginal connection.
Description
Will insert records to the TSD I_SMS_MIGRATION and o the TSD I_SMS_MIG_MAP table when appropriate
Dialog Forms Called
None
File Name
Syntax
SMS_LoadGroupKeysFromGroupMap
Parameters
None
Returns
INTEGER: The database return value
By REFERENCE: machineDataList
Side Effects
Sets the connection temporarily to the SMS database connection then back to the orginal connection.
Description
Selects groupkey and groupname from the SMS groupmap table and determines the groupkey based on the groupname
Dialog Forms Called
None
File Name
Syntax
SMS_UpdateMigFileRec( REF MigMapRec: MigMapFileRec, REF EFMSMS_MappingList: LIST OF EFMSMS_MappedRec, VAL where: STRING, REF advHandle: INTEGER )
Parameters
MigMapRec - Record used for the updates and deletes to
the TSD I_SMS_MIGRATION table
EFMSMS_MappingList - List of EFMSMS_MappedRec used to
insert records into the TSD I_SMS_MIG_MAP table
where - The where statement passed in. Can be unknown
advHandle - The TSD database connetion used to connect to
the TSD database
Returns
INTEGER: The database return value
Side Effects
Sets the connection temporarily to the TSD database connection then back to the orginal connection.
Description
Will update, delete a record to the TSD I_SMS_MIGRATION and inserts into the TSD I_SMS_MIG_MAP table depending on the where statement passed in
Dialog Forms Called
None