Difference between revisions of "SQWareProduction:mssql:lib:sqwmsq Global.lib"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by Expdbtools)
 
m (Updated by Expdbtools)
Line 1: Line 1:
−
Librairie de fonctions shell $gvsqw_MssBin/../lib/sqwmsq_Global.lib:<br>
+
shell functions librairy $gvsqw_MssBin/../lib/sqwmsq_Global.lib:<br>
−
central lib of generic fonctions
+
{{SQWareProduction_sqwmsq_Global.lib_presentation}}
 
<br>
 
<br>
−
gfsqw_BatchDuration
+
Functions explanation:
 +
<pre>
 
gfsqw_BatchDuration
 
gfsqw_BatchDuration
−
gfsqw_BeginningCom
+
gfsqw_BatchDuration =>
 +
gfsqw_BeginningCom =>
 
   gfsqw_Colors
 
   gfsqw_Colors
−
gfsqw_Colors
+
gfsqw_Colors =>
−
gfsqw_EndMailError
+
gfsqw_ConvertBackslashToSlash =>
 +
gfsqw_ConvertSlashToBackslash =>
 +
gfsqw_DisplaySample =>
 +
gfsqw_EndMailError =>
 
gfsqw_EndMailError 31 "You do not have write permission on $gvsqw_TmpDir !"
 
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 31 "You do not have write permission on $lvsqw_RootTmp !"
−
gfsqw_EndMailError 33 "Database $lvsqw_DbName on $lvsqw_InstanceParam does not exist or pb connection !"
+
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</pre>"
−
gfsqw_EndTrt
+
gfsqw_EndMailError 99 "Error, failed to connect to $lvsqw_InstanceParam !!!<br>\n<pre class='edt'>\n$cat $gvsqw_TmpFile => \n</pre>"
−
gfsqw_EvalGlobalVar
+
gfsqw_EndTrt =>
−
gfsqw_ExecSql
+
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_ExecSql "sp_helpdb '$lvsqw_DbName'" >$gvsqw_TmpFile
−
gfsqw_exec_xp_cmdshell
+
gfsqw_ExecXpCmdShell =>
−
gfsqw_exec_xp_cmdshell_msg
+
gfsqw_ExecXpCmdShell_msg =>
−
gfsqw_GenDatabasesList
+
gfsqw_FormatHtmlMessages =>
−
gfsqw_Init
+
gfsqw_FormatHtmlMessages $gvsqw_TmpFile.nonparam >> $gvsqw_TmpFile.mail
 +
gfsqw_GenDatabasesList =>
 +
gfsqw_GenInfoMail
 +
gfsqw_GenInfoMail =>
 +
gfsqw_GetVersion =>
 +
gfsqw_HeadFile =>
 +
gfsqw_HtmlTablesCode =>
 +
gfsqw_Init =>
 
gfsqw_JobEnd
 
gfsqw_JobEnd
−
gfsqw_ManageParfile
+
gfsqw_ManageParfile =>
−
gfsqw_Ptree
+
gfsqw_Ptree =>
−
gfsqw_Purge
 
 
gfsqw_Purge
 
gfsqw_Purge
−
gfsqw_TempFile
+
gfsqw_Purge =>
 +
gfsqw_SourceOverloadLibs =>
 +
gfsqw_SourceOverloadLibs 'sqwmsq_InsertIndicators.lib'
 +
gfsqw_SourceOverloadLibs 'sqwmsq_SetEnv.lib'
 +
gfsqw_SourceOverloadLibs $lvsqw_SpecificLib
 +
gfsqw_TempFile =>
 +
</pre>
 
<br>
 
<br>
 
{{SQWareProductionSurchargeLib|mssql|Mss|sqwmsq_Global.lib}}
 
{{SQWareProductionSurchargeLib|mssql|Mss|sqwmsq_Global.lib}}
 
<br>
 
<br>

Revision as of 23:26, 15 December 2010

shell functions librairy $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_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_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_TmpFile.mail 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_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 .


Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareProduction:mssql:lib:sqwmsq_Global.lib&oldid=1068"