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

From Wiki_dbSQWare
Jump to navigation Jump to search
← Older edit
m Updated by BatchUser
m Updated by BatchUser
 
(2 intermediate revisions by the same user not shown)
Line 4: Line 4:
Functions explanation:
Functions explanation:
<pre>
<pre>
gfsqw_GenDatabasesList|sed 's,\\,,g' > $gvsqw_TmpFile.lst
gfsqw_BeginningCom
gfsqw_GenDatabasesList|sed 's,\\,,g' > $gvsqw_TmpFile.lst_db
gfsqw_GenericExecFisql $gvsqw_TmpFile.sql 2>&1
gfsqw_GenericExecFisql $gvsqw_TmpFile.sql 2>&1
gfsqw_GenericExecFisql $gvsqw_TmpFile.sql 2>&1  
gfsqw_GenericExecFisql $gvsqw_TmpFile.sql 2>&1  
gfsqw_InsertIndicators "columns informations"
gfsqw_InsertIndicators "indexes informations"
gfsqw_InsertIndicators "tables informations"
lfsqw_Columns =>  
lfsqw_Columns =>  
lfsqw_GatherTables =>  
lfsqw_GatherTables =>  
lfsqw_Indexes =>  
lfsqw_Indexes =>  
lfsqw_InsertColumnsDifferences
lfsqw_InsertIndexesDifferences
lfsqw_InsertStructureOk "columns"
lfsqw_InsertStructureOk "indexes"
lfsqw_InsertStructureOk "tables"
lfsqw_InsertTablesDifferences
lfsqw_PrepareColumnsDifferences
lfsqw_PrepareColumnsDifferences
lfsqw_PrepareIndexesDifferences
lfsqw_PrepareIndexesDifferences
lfsqw_PrepareTablesDifferences >$gvsqw_TmpFile.isOK
lfsqw_PrepareTablesDifferences
lfsqw_Tables =>  
lfsqw_Tables =>  
</pre>
</pre>

Latest revision as of 19:21, 24 January 2023

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

gfsqw_BeginningCom
gfsqw_GenDatabasesList|sed 's,\\,,g' > $gvsqw_TmpFile.lst_db
gfsqw_GenericExecFisql $gvsqw_TmpFile.sql 2>&1
gfsqw_GenericExecFisql $gvsqw_TmpFile.sql 2>&1 
gfsqw_InsertIndicators "columns informations"
gfsqw_InsertIndicators "indexes informations"
gfsqw_InsertIndicators "tables informations"
lfsqw_Columns => 
lfsqw_GatherTables => 
lfsqw_Indexes => 
lfsqw_InsertColumnsDifferences
lfsqw_InsertIndexesDifferences
lfsqw_InsertStructureOk "columns"
lfsqw_InsertStructureOk "indexes"
lfsqw_InsertStructureOk "tables"
lfsqw_InsertTablesDifferences
lfsqw_PrepareColumnsDifferences
lfsqw_PrepareIndexesDifferences
lfsqw_PrepareTablesDifferences
lfsqw_Tables =>


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=22338"