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

From Wiki_dbSQWare
Jump to navigation Jump to search
Exploit (talk | contribs)
0 edits
m Updated by Expdbtools
 
m Updated by BatchUser
 
(13 intermediate revisions by 2 users not shown)
Line 1: Line 1:
Librairie de fonctions shell $gvsqw_MssBin/../lib/sqwmsq_Global.lib:<br>
shell functions library $gvsqw_MsqBin/../lib/sqwmsq_Global.lib:<br>
central lib of generic fonctions
{{SQWareProduction_sqwmsq_Global.lib_presentation}}
<br>
<br>
gfsqw_BatchDuration
Functions explanation:
gfsqw_BatchDuration
<pre>
gfsqw_BeginningCom
gfsqw_CheckConn =>
  gfsqw_Colors
gfsqw_ConvertBackslashToSlash =>
gfsqw_Colors
gfsqw_ConvertSlashToBackslash =>
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 "Database $lvsqw_DbName on $lvsqw_InstanceParam does not exist or pb connection !"
gfsqw_EndTrt
gfsqw_EvalGlobalVar
gfsqw_EvalGlobalVar
gfsqw_ExecSql
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_ExecSql "sp_helpdb '$lvsqw_DbName'" >$gvsqw_TmpFile
gfsqw_exec_xp_cmdshell
gfsqw_ExecXpCmdShell =>
gfsqw_exec_xp_cmdshell_msg
gfsqw_FormatHtmlMessages =>
gfsqw_GenDatabasesList
gfsqw_GenDatabasesList =>
gfsqw_Init
gfsqw_GenericExecFisql =>
gfsqw_JobEnd
gfsqw_GenericExecSql =>
gfsqw_ManageParfile
gfsqw_GenericExecSql $lvsqw_GenExecSqlFile  2>&1
gfsqw_Ptree
gfsqw_GenericExecSql $lvsqw_GenExecSqlFile 2>&1
gfsqw_Purge
gfsqw_GenericExecSql_bsqldb =>
gfsqw_Purge
gfsqw_GenericExecSql_bsqldb $lvsqw_GenExecSqlFile  2>&1
gfsqw_TempFile
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 =>
</pre>
<br>
<br>
{{SQWareProductionSurchargeLib|mssql|Mss|sqwmsq_Global.lib}}
{{SQWareProductionSurchargeLib|mssql|Msq|sqwmsq_Global.lib}}
<br>
<br>

Latest revision as of 18: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 =>


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"