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

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
Line 7: Line 7:
 
gfsqw_BatchDuration =>  
 
gfsqw_BatchDuration =>  
 
gfsqw_BeginningCom =>  
 
gfsqw_BeginningCom =>  
  gfsqw_Colors
 
 
gfsqw_Colors =>  
 
gfsqw_Colors =>  
 
gfsqw_ConvertBackslashToSlash =>  
 
gfsqw_ConvertBackslashToSlash =>  
Line 13: Line 12:
 
gfsqw_DisplaySample =>  
 
gfsqw_DisplaySample =>  
 
gfsqw_EndMailError =>  
 
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</pre>"
 
gfsqw_EndMailError 99 "Error, failed to connect to $lvsqw_InstanceParam !!!<br>\n<pre class='edt'>\n$cat $gvsqw_TmpFile => \n</pre>"
 
gfsqw_EndMailError_sub
 
 
gfsqw_EndMailError_sub =>  
 
gfsqw_EndMailError_sub =>  
gfsqw_EndMailError_sub 2>&1 >> $gvsqw_LogFile
 
 
gfsqw_EndTrt =>  
 
gfsqw_EndTrt =>  
 
gfsqw_EvalGlobalVar =>  
 
gfsqw_EvalGlobalVar =>  
Line 30: Line 22:
 
gfsqw_ExecXpCmdShell_msg =>  
 
gfsqw_ExecXpCmdShell_msg =>  
 
gfsqw_FormatHtmlMessages =>  
 
gfsqw_FormatHtmlMessages =>  
gfsqw_FormatHtmlMessages $gvsqw_TmpFile.nonparam >> $gvsqw_MailFile
 
 
gfsqw_GenDatabasesList =>  
 
gfsqw_GenDatabasesList =>  
 
gfsqw_GenInfoMail
 
gfsqw_GenInfoMail
Line 38: Line 29:
 
gfsqw_HtmlTablesCode =>  
 
gfsqw_HtmlTablesCode =>  
 
gfsqw_Init =>  
 
gfsqw_Init =>  
gfsqw_JobEnd
 
 
gfsqw_ManageParfile =>  
 
gfsqw_ManageParfile =>  
 
gfsqw_Ptree =>  
 
gfsqw_Ptree =>  

Revision as of 21:42, 12 November 2011

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_ConvertBackslashToSlash => 
gfsqw_ConvertSlashToBackslash => 
gfsqw_DisplaySample => 
gfsqw_EndMailError => 
gfsqw_EndMailError_sub => 
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_GenDatabasesList => 
gfsqw_GenInfoMail
gfsqw_GenInfoMail => 
gfsqw_GetVersion => 
gfsqw_HeadFile => 
gfsqw_HtmlTablesCode => 
gfsqw_Init => 
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 .