SQWareProduction:mssql:lib:sqwmsq Global.lib

From Wiki_dbSQWare
Revision as of 21:29, 24 May 2011 by BatchUser (talk | contribs) (Updated by BatchUser)
Jump to: navigation, search

shell functions library $gvsqw_MssBin/../lib/sqwmsq_Global.lib:
central lib of generic fonctions for mssql
Functions explanation:

gfsqw_BatchDuration
gfsqw_BatchDuration => 
gfsqw_BeginningCom => 
   gfsqw_Colors
gfsqw_Colors => 
gfsqw_ConvertBackslashToSlash => 
gfsqw_ConvertSlashToBackslash => 
gfsqw_DisplaySample => 
gfsqw_EndMailError => 
			gfsqw_EndMailError 31 "You do not have write permission on $gvsqw_LogDir !"
		gfsqw_EndMailError 31 "You do not have write permission on $gvsqw_TmpDir !"
	gfsqw_EndMailError 31 "You do not have write permission on $lvsqw_RootTmp !!"
	gfsqw_EndMailError 33 "Error, database $lvsqw_DbName on $lvsqw_InstanceParam does not exist or pb connection !<br>\n<pre class='edt'>\n$cat $gvsqw_TmpFile => \n

" gfsqw_EndMailError 99 "Error, failed to connect to $lvsqw_InstanceParam !!!
\n

\n$cat $gvsqw_TmpFile => \n

"

gfsqw_EndMailError_sub gfsqw_EndMailError_sub => gfsqw_EndMailError_sub 2>&1 >> $gvsqw_LogFile gfsqw_EndTrt => gfsqw_EvalGlobalVar => gfsqw_ExecSql => gfsqw_ExecSql $gvsqw_TmpFile.sql 2>&1|grep lvsqw_HostName|cut -d= -f2|sed 's,\\,\\\\,'| read gvsqw_FullName gfsqw_ExecSql "select @@version" 2>&1| tr -d "\015" >$gvsqw_TmpFile gfsqw_ExecSql "sp_helpdb '$lvsqw_DbName'" >$gvsqw_TmpFile gfsqw_ExecXpCmdShell => gfsqw_ExecXpCmdShell_msg => gfsqw_FormatHtmlMessages => gfsqw_FormatHtmlMessages $gvsqw_TmpFile.nonparam >> $gvsqw_MailFile gfsqw_GenDatabasesList => gfsqw_GenInfoMail gfsqw_GenInfoMail => gfsqw_GetVersion => gfsqw_HeadFile => gfsqw_HtmlTablesCode => gfsqw_Init => gfsqw_JobEnd gfsqw_ManageParfile => gfsqw_Ptree => gfsqw_Purge gfsqw_Purge => gfsqw_SourceOverloadLibs => gfsqw_SourceOverloadLibs 'sqwmsq_InsertIndicators.lib' gfsqw_SourceOverloadLibs 'sqwmsq_SetEnv.lib' gfsqw_SourceOverloadLibs $lvsqw_SpecificLib gfsqw_StartLog => gfsqw_TempFile =>


Nuvola apps information.png
Note:
You can overload functions contained in $gvsqw_MssBin/../lib/sqwmsq_Global.lib

by function with same name in $gvsqw_MssBin/../lib_cust/sqwmsq_Global.lib for all your environnement
or by $HOME/sqwConfig/sqwmsq_Global.lib specifically for this user .