Skip to content

Home

Jump to bottom
Vern Huber edited this page Nov 7, 2019 · 1 revision

​utils - Misc Utilities

This page documents the SW Change Management repository named [ **utils** ], currently in Subversion.
The folders under [ utils ] are as follows:

[ C# ] - utilities common to the C# code base.

  • Code not yet committed, but when finalized, will hold a wrapper function that will call the SQL Server dbo.uis_sendmail() utility.  This frees the application code from needing to worry about DB connection information - and use a standardized email format.

[ oracle ] - utilities common to the Oracle environment.

  • README_utils.docx - README file providing additional details regarding the code in this directory.

  • uis_utils.UIS_SYS_PARAM_LKP : table for holding parameter data specific to an area/application as well as data global across areas/applications.

  • uis_utils.uis_sendmail.send_html() - procedure used to send standardized emails from an Oracle DB.

[ sqlserver ] - utilities common to the MS SQL Server environment

  • README_utils.docx - README file providing additional details regarding the code in this directory.

  • msdb.dbo.UIS_SYS_PARAM_LKP : table for holding parameter data specific to an area/application as well as data global across areas/applications.

  • msdb.dbo.uis_sendmail() - procedure used to send standardized emails from SQL Server.

Note: UIS_SYS_PARAM_LKP is a table that should exist in both the SQL Server and Oracle environments and used by applications in order to make then dynamically data driven.

Clone this wiki locally