Difference between revisions of "SQWareProduction:sybase:lib:sqwsyb GatherStructure.lib"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
 
m (Updated by BatchUser)
Line 5: Line 5:
 
<pre>
 
<pre>
 
gfsqw_GenDatabasesList > $gvsqw_TmpFile.lst
 
gfsqw_GenDatabasesList > $gvsqw_TmpFile.lst
 +
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>

Revision as of 18:34, 8 March 2020

shell functions library $gvsqw_SybBin/../lib/sqwsyb_GatherStructure.lib:
lib for sqwsyb_GatherStructure.ksh
Functions explanation:

gfsqw_GenDatabasesList > $gvsqw_TmpFile.lst
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 => 


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

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