Difference between revisions of "SQWareProduction:mssql:lib:sqwmsq Global.lib"
m (Updated by Expdbtools) |
m (Updated by Expdbtools) |
||
| Line 1: | Line 1: | ||
| − | + | shell functions librairy $gvsqw_MssBin/../lib/sqwmsq_Global.lib:<br> | |
| − | + | {{SQWareProduction_sqwmsq_Global.lib_presentation}} | |
<br> | <br> | ||
| − | + | 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 " | + | 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_ExecXpCmdShell => | |
| − | + | 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_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 =>
