SQWareProduction:postgres:lib:sqwpg GatherStructure.lib: Difference between revisions

From Wiki_dbSQWare
Jump to navigation Jump to search
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_BeginningCom
gfsqw_GenListDatabase > $gvsqw_TmpFile.lst
gfsqw_GenListDatabase > $gvsqw_TmpFile.lst
gfsqw_InsertIndicators "columns informations"
gfsqw_InsertIndicators "indexes '%ccnew%' or '%ccold%'"
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_InsertIndexesTemp
lfsqw_InsertIndexesTemp =>
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 10:38, 11 February 2023

shell functions library $gvsqw_PgBin/../lib/sqwpg_GatherStructure.lib:
lib for sqwpg_GatherStructure.ksh
Functions explanation: 

gfsqw_BeginningCom
gfsqw_GenListDatabase > $gvsqw_TmpFile.lst
gfsqw_InsertIndicators "columns informations"
gfsqw_InsertIndicators "indexes '%ccnew%' or '%ccold%'"
gfsqw_InsertIndicators "indexes informations"
gfsqw_InsertIndicators "tables informations"
lfsqw_Columns => 
lfsqw_GatherTables => 
lfsqw_Indexes => 
lfsqw_InsertColumnsDifferences
lfsqw_InsertIndexesDifferences
lfsqw_InsertIndexesTemp
lfsqw_InsertIndexesTemp => 
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_PgBin/../lib/sqwpg_GatherStructure.lib

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


Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareProduction:postgres:lib:sqwpg_GatherStructure.lib&oldid=22938"