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

From Wiki_dbSQWare
Jump to navigation Jump to search
m Updated by BatchUser
m Updated by BatchUser
Line 4: Line 4:
Functions explanation:
Functions explanation:
<pre>
<pre>
gfsqw_BatchDuration
gfsqw_BatchDuration =>
gfsqw_BeginningCom =>
gfsqw_Colors =>
gfsqw_ConvertBackslashToSlash =>  
gfsqw_ConvertBackslashToSlash =>  
gfsqw_ConvertSlashToBackslash =>  
gfsqw_ConvertSlashToBackslash =>  
gfsqw_DisplaySample =>
gfsqw_EndMailError =>
gfsqw_EndMailError_sub =>
gfsqw_EndTrt =>
gfsqw_EvalGlobalVar =>
gfsqw_ExecSql =>  
gfsqw_ExecSql =>  
gfsqw_ExecSql $gvsqw_TmpFile.sql 2>&1|grep gvsqw_ProductEdition|cut -d= -f2|awk '{print $1}'| read gvsqw_ProductEdition
gfsqw_ExecSql $gvsqw_TmpFile.sql 2>&1|grep gvsqw_ProductEdition|cut -d= -f2|awk '{print $1}'| read gvsqw_ProductEdition
Line 27: Line 18:
gfsqw_GenericExecSql $lvsqw_GenExecSqlFile  2>&1
gfsqw_GenericExecSql $lvsqw_GenExecSqlFile  2>&1
gfsqw_GenericExecSql $lvsqw_GenExecSqlFile 2>&1
gfsqw_GenericExecSql $lvsqw_GenExecSqlFile 2>&1
gfsqw_GenInfoMail
gfsqw_GenInfoMail =>
gfsqw_GetVersion =>  
gfsqw_GetVersion =>  
gfsqw_HeadFile =>
gfsqw_HtmlTablesCode =>
gfsqw_Init =>
gfsqw_IsXpCmdShellEnabled =>  
gfsqw_IsXpCmdShellEnabled =>  
gfsqw_ManageParfile =>  
gfsqw_ManageParfile =>  
gfsqw_Ptree =>  
gfsqw_SourceProfile =>  
gfsqw_Purge
gfsqw_TempFile "$echo $gvsqw_ProgName|sed 's,.ksh,,'|sed 's,sqwmsq_,,' => "
gfsqw_Purge =>
gfsqw_SetMailSender =>
gfsqw_SetMailSender "$1"
gfsqw_SourceOverloadLibs =>
gfsqw_SourceOverloadLibs 'sqwmsq_InsertIndicators.lib'
gfsqw_SourceOverloadLibs 'sqwmsq_SetEnv.lib'
gfsqw_SourceOverloadLibs $lvsqw_SpecificLib
gfsqw_StartLog =>
gfsqw_TempFile =>  
</pre>
</pre>
<br>
<br>
{{SQWareProductionSurchargeLib|mssql|Mss|sqwmsq_Global.lib}}
{{SQWareProductionSurchargeLib|mssql|Mss|sqwmsq_Global.lib}}
<br>
<br>

Revision as of 18:33, 5 April 2014

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

gfsqw_ConvertBackslashToSlash => 
gfsqw_ConvertSlashToBackslash => 
gfsqw_ExecSql => 
gfsqw_ExecSql $gvsqw_TmpFile.sql 2>&1|grep gvsqw_ProductEdition|cut -d= -f2|awk '{print $1}'| read gvsqw_ProductEdition
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_GenericExecSql => 
gfsqw_GenericExecSql $lvsqw_GenExecSqlFile  2>&1
gfsqw_GenericExecSql $lvsqw_GenExecSqlFile 2>&1
gfsqw_GetVersion => 
gfsqw_IsXpCmdShellEnabled => 
gfsqw_ManageParfile => 
gfsqw_SourceProfile => 
gfsqw_TempFile "$echo $gvsqw_ProgName|sed 's,.ksh,,'|sed 's,sqwmsq_,,' => "


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 .