SQWareProduction:mssql:lib:sqwmsq Global.lib: Difference between revisions
Jump to navigation
Jump to search
m Updated by BatchUser |
m Updated by BatchUser |
||
| Line 6: | Line 6: | ||
gfsqw_ConvertBackslashToSlash => | gfsqw_ConvertBackslashToSlash => | ||
gfsqw_ConvertSlashToBackslash => | gfsqw_ConvertSlashToBackslash => | ||
gfsqw_EvalGlobalVar | |||
gfsqw_ExecSql => | 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 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 $gvsqw_TmpFile.sql 2>&1|grep lvsqw_HostName|cut -d= -f2|sed 's,\\,\\\\,'| read gvsqw_FullName | ||
| Line 16: | Line 18: | ||
gfsqw_GenDatabasesList => | gfsqw_GenDatabasesList => | ||
gfsqw_GenericExecSql => | 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_GenericExecSql $lvsqw_GenExecSqlFile 2>&1 | gfsqw_GenericExecSql $lvsqw_GenExecSqlFile 2>&1 | ||
gfsqw_GetVersion => | gfsqw_GetVersion => | ||
gfsqw_IsXpCmdShellEnabled => | gfsqw_IsXpCmdShellEnabled => | ||
gfsqw_LockForXpCmdShell | |||
gfsqw_LockForXpCmdShell => | |||
gfsqw_ManageParfile => | gfsqw_ManageParfile => | ||
gfsqw_Ptree $$ >> $lvsqw_LockFile | |||
gfsqw_TempFile "$echo $gvsqw_ProgName|sed 's,.ksh,,'|sed 's,sqwmsq_,,' => " | gfsqw_TempFile "$echo $gvsqw_ProgName|sed 's,.ksh,,'|sed 's,sqwmsq_,,' => " | ||
</pre> | </pre> | ||
Revision as of 09:50, 20 July 2014
shell functions library $gvsqw_MsqBin/../lib/sqwmsq_Global.lib:
central lib of generic fonctions for mssql
Functions explanation:
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_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_,,' => "
