SQWareProduction:mssql:lib:sqwmsq Global.lib : Différence entre versions

De WikiFr_dbSQWare
Aller à : navigation, rechercher
m (Updated by BatchUser)
m (Updated by BatchUser)
 
Ligne 10 : Ligne 10 :
 
gfsqw_ExecSql =>  
 
gfsqw_ExecSql =>  
 
gfsqw_ExecSql $gvsqw_TmpFile.sql >$gvsqw_TmpFile
 
gfsqw_ExecSql $gvsqw_TmpFile.sql >$gvsqw_TmpFile
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_bsqldb =>  
 
gfsqw_ExecSql_bsqldb =>  
 
gfsqw_ExecSql "select @@version" 2>&1| tr -d "\015" >$gvsqw_TmpFile
 
gfsqw_ExecSql "select @@version" 2>&1| tr -d "\015" >$gvsqw_TmpFile

Version actuelle datée du 27 septembre 2021 à 21:25

librairies de fonctions shell $gvsqw_MsqBin/../lib/sqwmsq_Global.lib:
central lib of generic fonctions for mssql
Explication des fonctions:

gfsqw_CheckConn => 
gfsqw_ConvertBackslashToSlash => 
gfsqw_ConvertSlashToBackslash => 
gfsqw_EvalGlobalVar
gfsqw_ExecSql => 
gfsqw_ExecSql $gvsqw_TmpFile.sql >$gvsqw_TmpFile
gfsqw_ExecSql_bsqldb => 
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 => 


Information.png
Information:
Vous pouvez surcharger les fonctions contenues dans $gvsqw_MsqBin/../lib/sqwmsq_Global.lib

en redeclarant une fonction du meme nom $gvsqw_MsqBin/../lib_cust/sqwmsq_Global.lib pour tous les environnements
ou dans $HOME/sqwConfig/sqwmsq_Global.lib specifiquement pour ce user .