Difference between revisions of "SQWareProduction:mssql:lib:sqwmsq GatherStructure.lib"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
 
m (Updated by BatchUser)
Line 4: Line 4:
 
Functions explanation:
 
Functions explanation:
 
<pre>
 
<pre>
−
gfsqw_ExecSql $gvsqw_TmpFile.sql 2>&1 |grep -iv Password|sed 's,  *$,,g'|sed 's,^  *,,g'|tr '\t' ' '|sed 's,  *, ,g'
 
−
gfsqw_ExecSql $gvsqw_TmpFile.sql 2>&1 |grep -iv Password|sed 's,  *$,,g'|sed 's,^  *,,g'|tr '\t' ' '|sed 's,  *, ,g'|sed 's, *; *,;,g'
 
 
gfsqw_GenDatabasesList|sed 's,\\,,g' > $gvsqw_TmpFile.lst
 
gfsqw_GenDatabasesList|sed 's,\\,,g' > $gvsqw_TmpFile.lst
 +
gfsqw_GenericExecFisql $gvsqw_TmpFile.sql 2>&1
 +
gfsqw_GenericExecFisql $gvsqw_TmpFile.sql 2>&1
 
lfsqw_Columns =>  
 
lfsqw_Columns =>  
 
lfsqw_GatherTables =>  
 
lfsqw_GatherTables =>  

Revision as of 21:29, 23 June 2019

shell functions library $gvsqw_MsqBin/../lib/sqwmsq_GatherStructure.lib:
lib for sqwmsq_GatherStructure.ksh
Functions explanation: 

gfsqw_GenDatabasesList|sed 's,\\,,g' > $gvsqw_TmpFile.lst
gfsqw_GenericExecFisql $gvsqw_TmpFile.sql 2>&1
gfsqw_GenericExecFisql $gvsqw_TmpFile.sql 2>&1 
lfsqw_Columns => 
lfsqw_GatherTables => 
lfsqw_Indexes => 
lfsqw_PrepareColumnsDifferences
lfsqw_PrepareIndexesDifferences
lfsqw_PrepareTablesDifferences >$gvsqw_TmpFile.isOK
lfsqw_Tables =>


Nuvola apps information.png
Note:
You can overload functions contained in $gvsqw_MsqBin/../lib/sqwmsq_GatherStructure.lib

by function with same name in $gvsqw_MsqBin/../lib_cust/sqwmsq_GatherStructure.lib for all your environnement
or by $HOME/sqwConfig/sqwmsq_GatherStructure.lib specifically for this user .


Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareProduction:mssql:lib:sqwmsq_GatherStructure.lib&oldid=13241"