Routines for sms_db.kb


ConnectSMS

File Name

sms_db.kb

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


CountSMSIDs

File Name

sms_db.kb

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


DoesLanguageViewExist

File Name

sms_db.kb

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


DoesSoftwareTableExist

File Name

sms_db.kb

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


FetchAssetsByScanDate

File Name

sms_db.kb

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


FindSMSGroupKey

File Name

sms_db.kb

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


GetABlockOfSMSIDs

File Name

sms_db.kb

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


SMS_DeleteMigFileRec

File Name

sms_db.kb

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


SMS_GetArchitectureKey

File Name

sms_db.kb

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


SMS_GetAttributeDataTypes

File Name

sms_db.kb

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


SMS_GetAuditedSWComm

File Name

sms_db.kb

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


SMS_GetAuditedSWSpec

File Name

sms_db.kb

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


SMS_GetDiskComm

File Name

sms_db.kb

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


SMS_GetDiskSpec

File Name

sms_db.kb

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


SMS_GetEFMAttributeMap

File Name

sms_db.kb

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


SMS_GetEFMStringValidationData

File Name

sms_db.kb

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


SMS_GetEnvironmentSpec

File Name

sms_db.kb

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


SMS_GetGroupMapList

File Name

sms_db.kb

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


SMS_GetIdentificationSpec

File Name

sms_db.kb

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


SMS_GetIdentificationSpecOrder

File Name

sms_db.kb

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


SMS_GetMachineData

File Name

sms_db.kb

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


SMS_GetMappingData

File Name

sms_db.kb

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


SMS_GetMifRecList

File Name

sms_db.kb

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


SMS_GetMigFileList

File Name

sms_db.kb

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


SMS_GetMigMappingList

File Name

sms_db.kb

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


SMS_GetNetcardComm

File Name

sms_db.kb

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


SMS_GetNetcardSpec

File Name

sms_db.kb

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


SMS_GetNetworkComm

File Name

sms_db.kb

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


SMS_GetNetworkSpec

File Name

sms_db.kb

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


SMS_GetOsComm

File Name

sms_db.kb

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


SMS_GetOsSpec

File Name

sms_db.kb

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


SMS_GetPCMemorySpec

File Name

sms_db.kb

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


SMS_GetProcessorComm

File Name

sms_db.kb

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


SMS_GetServicesComm

File Name

sms_db.kb

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


SMS_GetSites

File Name

sms_db.kb

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


SMS_GetSysTypes

File Name

sms_db.kb

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


SMS_GetTableFieldList

File Name

sms_db.kb

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


SMS_GetUserInformationComm

File Name

sms_db.kb

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


SMS_GetUserInformationSpec

File Name

sms_db.kb

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


SMS_GetVideoComm

File Name

sms_db.kb

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


SMS_GetWorkstationStatus

File Name

sms_db.kb

Syntax

None

Parameters

None

Returns

None

Side Effects

None

Description

None

Dialog Forms Called

None


SMS_InsertMigFileRec

File Name

sms_db.kb

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


SMS_LoadGroupKeysFromGroupMap

File Name

sms_db.kb

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


SMS_UpdateMigFileRec

File Name

sms_db.kb

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