File Name
Syntax
ApplyColumnReplacements( VAL tbName: STRING, REF columnList: LIST OF ColumnRecord)
Parameters
tbName: name of the table for column name aliases
columnList: list of column records to be replaced
with an alias from the EACOLUMNS table
Returns
Nothing
Side Effects
None
Description
This procedure will replace the database column names with the appropriate column alias set up in the application configuration.
Dialog Forms Called
None
File Name
Syntax
CreateSearchString( VAL parentWindow: Window, VAL controlName: STRING, VAL TBName: String, REF condition: String, REF orderBy: String): BOOLEAN
Parameters
parentWindow: handle of the parent window
controlName: name of dialog control
TBName: name of the table to search
condition: where clause condition to use in search
orderBy: order by clause containing the fields by which to
order the search.
Returns
TRUE: Success
FALSE: Failure
Side Effects
None
Description
This function allows the user to create a search string that can be used multiple times. In the Tivoli Service Desk applications this function is called where passing in record data for the "Work With" dialog boxes, so the search criteria can be maintained for the duration of the "Work With" inquiry.
Dialog Forms Called
search.dfc[searchstring]
File Name
Syntax
FulcrumRecToSyntax(VAL ColumnName: STRING, VAL FulcrumRec: FulcrumRecord): STRING
Parameters
ColumnName - ame of column to search.
FulcrumRec - fulcrum record containing additional search
parameters.
Returns
The appropriate search syntax used by Fulcrum or
Intelligent Miner for Text.
Side Effects
This function requires that Intelligent Miner for Text is installed and properly configured.
Description
This procedure returns the syntax needed to do a search using Intelligent Miner for Text.
Dialog Forms Called
None
File Name
Syntax
GetColumnList ( VAL tbName: STRING, REF columnList: List of STRING)
Parameters
tbName - name of the table for column name aliases
columnList - list of column names.
Returns
Nothing
Side Effects
None
Description
This procedure returns the names of the columns for a given table in the column list that is passed to this procedure.
Dialog Forms Called
None
File Name
Syntax
GetTableList ( REF tableList: List of STRING)
Parameters
tableList - list of table names
Returns
Nothing
Side Effects
This procedure uses $QUAL, to limit the list to the tables that were created under the current qualifier. The qualifer is set in the Configuration Editor.
Description
This procedure will return the names of all the tables in a database that were created under the current qualifier.
Dialog Forms Called
None
File Name
Syntax
QueryColumnWidth( VAL tbName: STRING, VAL columnName: STRING): INTEGER
Parameters
tbName - name of the table for column name aliases
columnName - column for which to find length.
Returns
Integer
Side Effects
None
Description
This procedure returns the length of a column given the column name, and table name.
Dialog Forms Called
None