Difference between revisions of "SQWareProduction:mssql:lib:sqwmsq Global.lib"
m (Updated by Expdbtools) |
m (Updated by BatchUser) |
||
| (13 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | shell functions library $gvsqw_MsqBin/../lib/sqwmsq_Global.lib:<br> | |
| − | + | {{SQWareProduction_sqwmsq_Global.lib_presentation}} | |
<br> | <br> | ||
| − | + | Functions explanation: | |
| − | + | <pre> | |
| − | + | gfsqw_CheckConn => | |
| − | + | gfsqw_ConvertBackslashToSlash => | |
| − | + | gfsqw_ConvertSlashToBackslash => | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
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_ExecXpCmdShell => | |
| − | + | gfsqw_FormatHtmlMessages => | |
| − | gfsqw_GenDatabasesList | + | gfsqw_GenDatabasesList => |
| − | + | gfsqw_GenericExecFisql => | |
| − | + | gfsqw_GenericExecSql => | |
| − | gfsqw_ManageParfile | + | gfsqw_GenericExecSql $lvsqw_GenExecSqlFile 2>&1 |
| − | gfsqw_Ptree | + | 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 => | ||
| + | </pre> | ||
<br> | <br> | ||
| − | {{SQWareProductionSurchargeLib|mssql| | + | {{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 =>
