Difference between revisions of "SQWareProduction:mssql:lib:sqwmsq Global.lib"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
Line 18: | Line 18: | ||
gfsqw_FormatHtmlMessages => | gfsqw_FormatHtmlMessages => | ||
gfsqw_GenDatabasesList => | gfsqw_GenDatabasesList => | ||
+ | gfsqw_GenericExecFisql => | ||
gfsqw_GenericExecSql => | gfsqw_GenericExecSql => | ||
gfsqw_GenericExecSql_bsqldb => | gfsqw_GenericExecSql_bsqldb => |
Revision as of 20:29, 23 June 2019
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_bsqldb => 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_GenericExecFisql => gfsqw_GenericExecSql => gfsqw_GenericExecSql_bsqldb => gfsqw_GenericExecSql_bsqldb $lvsqw_GenExecSqlFile 2>&1 gfsqw_GenericExecSql $lvsqw_GenExecSqlFile 2>&1 gfsqw_GenericExecSql $lvsqw_GenExecSqlFile 2>&1 gfsqw_GetVersion => gfsqw_IsXpCmdShellEnabled => gfsqw_LockForXpCmdShell gfsqw_LockForXpCmdShell => gfsqw_ManageParfile => gfsqw_Ptree $$ >> $lvsqw_LockFile gfsqw_TempFile "$echo $gvsqw_ProgName|sed 's,.ksh,,'|sed 's,sqwmsq_,,' => "