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

From Wiki_dbSQWare
Jump to navigation Jump to search
Newer edit →
Exploit (talk | contribs)
0 edits
m Updated by Expdbtools
 
Exploit (talk | contribs)
0 edits
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 00:26, 16 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 =>


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"