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)
 
(10 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
shell functions library $gvsqw_MssBin/../lib/sqwmsq_Global.lib:<br>
+
shell functions library $gvsqw_MsqBin/../lib/sqwmsq_Global.lib:<br>
 
{{SQWareProduction_sqwmsq_Global.lib_presentation}}
 
{{SQWareProduction_sqwmsq_Global.lib_presentation}}
 
<br>
 
<br>
 
Functions explanation:
 
Functions explanation:
 
<pre>
 
<pre>
−
gfsqw_BatchDuration
+
gfsqw_CheckConn =>  
−
gfsqw_BatchDuration =>
 
−
gfsqw_BeginningCom =>
 
−
gfsqw_Colors =>  
 
 
gfsqw_ConvertBackslashToSlash =>  
 
gfsqw_ConvertBackslashToSlash =>  
 
gfsqw_ConvertSlashToBackslash =>  
 
gfsqw_ConvertSlashToBackslash =>  
−
gfsqw_DisplaySample =>
+
gfsqw_EvalGlobalVar
−
gfsqw_EndMailError =>
 
−
gfsqw_EndMailError_sub =>
 
−
gfsqw_EndTrt =>
 
−
gfsqw_EvalGlobalVar =>
 
 
gfsqw_ExecSql =>  
 
gfsqw_ExecSql =>  
−
gfsqw_ExecSql $gvsqw_TmpFile.sql 2>&1|grep lvsqw_HostName|cut -d= -f2|sed 's,\\,\\\\,'| read gvsqw_FullName
+
gfsqw_ExecSql $gvsqw_TmpFile.sql >$gvsqw_TmpFile
 +
gfsqw_ExecSql_bsqldb =>
 +
gfsqw_ExecSql "select distinct 'RDS_ENV' from master.sys.server_principals where name = 'rdsa'" 2>&1| tr -d "\015" >$gvsqw_TmpFile
 
gfsqw_ExecSql "select @@version" 2>&1| tr -d "\015" >$gvsqw_TmpFile
 
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 =>  
−
gfsqw_ExecXpCmdShell_msg =>
 
 
gfsqw_FormatHtmlMessages =>  
 
gfsqw_FormatHtmlMessages =>  
 
gfsqw_GenDatabasesList =>  
 
gfsqw_GenDatabasesList =>  
−
gfsqw_GenInfoMail
+
gfsqw_GenericExecFisql =>
−
gfsqw_GenInfoMail =>  
+
gfsqw_GenericExecSql =>  
 +
gfsqw_GenericExecSql $lvsqw_GenExecSqlFile  2>&1
 +
gfsqw_GenericExecSql $lvsqw_GenExecSqlFile 2>&1
 +
gfsqw_GenericExecSql_bsqldb =>
 +
gfsqw_GenericExecSql_bsqldb $lvsqw_GenExecSqlFile  2>&1
 
gfsqw_GetVersion =>  
 
gfsqw_GetVersion =>  
−
gfsqw_HeadFile =>  
+
gfsqw_IsXpCmdShellEnabled =>  
−
gfsqw_HtmlTablesCode =>  
+
gfsqw_IsXpCmdShellEnabledGlobal =>  
−
gfsqw_Init =>  
+
gfsqw_LockForXpCmdShell =>  
 
gfsqw_ManageParfile =>  
 
gfsqw_ManageParfile =>  
−
gfsqw_Ptree =>  
+
gfsqw_Ptree $$ >> $lvsqw_LockFile
−
gfsqw_Purge
+
gfsqw_Ptree ${gvsqw_GlobalPid} >>$gvsqw_RootCfg/need_xp_cmdshell.$$
−
gfsqw_Purge =>  
+
gfsqw_TempFile "$echo $gvsqw_ProgName|sed 's,.ksh,,'|sed 's,sqwmsq_,,' => "
−
gfsqw_SourceOverloadLibs =>  
+
gfsqw_XpCmdShellGlobalDisable =>  
−
gfsqw_SourceOverloadLibs 'sqwmsq_InsertIndicators.lib'
+
gfsqw_XpCmdShellGlobalEnable =>  
−
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|Msq|sqwmsq_Global.lib}}
 
<br>
 
<br>

Latest revision as of 17:47, 21 July 2024

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

gfsqw_CheckConn => 
gfsqw_ConvertBackslashToSlash => 
gfsqw_ConvertSlashToBackslash => 
gfsqw_EvalGlobalVar
gfsqw_ExecSql => 
gfsqw_ExecSql $gvsqw_TmpFile.sql >$gvsqw_TmpFile
gfsqw_ExecSql_bsqldb => 
gfsqw_ExecSql "select distinct 'RDS_ENV' from master.sys.server_principals where name = 'rdsa'" 2>&1| tr -d "\015" >$gvsqw_TmpFile
gfsqw_ExecSql "select @@version" 2>&1| tr -d "\015" >$gvsqw_TmpFile
gfsqw_ExecSql "sp_helpdb '$lvsqw_DbName'" >$gvsqw_TmpFile
gfsqw_ExecXpCmdShell => 
gfsqw_FormatHtmlMessages => 
gfsqw_GenDatabasesList => 
gfsqw_GenericExecFisql => 
gfsqw_GenericExecSql => 
gfsqw_GenericExecSql $lvsqw_GenExecSqlFile  2>&1
gfsqw_GenericExecSql $lvsqw_GenExecSqlFile 2>&1
gfsqw_GenericExecSql_bsqldb => 
gfsqw_GenericExecSql_bsqldb $lvsqw_GenExecSqlFile  2>&1
gfsqw_GetVersion => 
gfsqw_IsXpCmdShellEnabled => 
gfsqw_IsXpCmdShellEnabledGlobal => 
gfsqw_LockForXpCmdShell => 
gfsqw_ManageParfile => 
gfsqw_Ptree $$ >> $lvsqw_LockFile
gfsqw_Ptree ${gvsqw_GlobalPid} >>$gvsqw_RootCfg/need_xp_cmdshell.$$
gfsqw_TempFile "$echo $gvsqw_ProgName|sed 's,.ksh,,'|sed 's,sqwmsq_,,' => "
gfsqw_XpCmdShellGlobalDisable => 
gfsqw_XpCmdShellGlobalEnable =>


Nuvola apps information.png
Note:
You can overload functions contained in $gvsqw_MsqBin/../lib/sqwmsq_Global.lib

by function with same name in $gvsqw_MsqBin/../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=28139"