Difference between revisions of "SQWareProduction:sybase:lib:sqwsyb GatherStructure.lib"
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 | + | 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 =>