SQWareProduction:mssql:lib:sqwmsq Global.lib

From Wiki_dbSQWare
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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 .