Modèle:SQWareProduction sqwmsq RebuildIndexDatabase.ksh example : Différence entre versions
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
Ligne 1 : | Ligne 1 : | ||
<pre> | <pre> | ||
− | Sourcing sqwmsq_Global.lib v2019. | + | Sourcing sqwmsq_Global.lib v2019.04 SQWareProduction for MsSql (dbSQWare) ... |
#Standard (Locale) help for script sqwmsq_RebuildIndexDatabase.ksh: | #Standard (Locale) help for script sqwmsq_RebuildIndexDatabase.ksh: |
Version du 23 juin 2019 à 20:27
Sourcing sqwmsq_Global.lib v2019.04 SQWareProduction for MsSql (dbSQWare) ... #Standard (Locale) help for script sqwmsq_RebuildIndexDatabase.ksh: $gvsqw_MsqBin/sqwmsq_RebuildIndexDatabase.ksh -h #Affichage de l'aide en ligne pour ce script $gvsqw_MsqBin/sqwmsq_RebuildIndexDatabase.ksh -S $Alias -D <DbName> -NoMail #Desactive l'envoi de mail sur erreur a to $gvsqw_GlobalMail (by default, send on error) $gvsqw_MsqBin/sqwmsq_RebuildIndexDatabase.ksh -S $Alias -D <DbName> -Exec #Execute les commandes generees $gvsqw_MsqBin/sqwmsq_RebuildIndexDatabase.ksh -S $Alias -D <DbName> #Genere les commandes mais ne les execute pas ! $gvsqw_MsqBin/sqwmsq_RebuildIndexDatabase.ksh -S $Alias -D <DbName> -FRT <NumericValue> -Exec #Force le code retour a '<NumericValue>' sur erreur (si pas d'erreur, exit 0!) #Vous pouvez aussi forcer le code retour de ce script pour tous #si vous settez la variable d'environnement: $gvsqw_ForcedReturnCodeScript_sqwmsq_RebuildIndexDatabase=<NumericValue> #dans le fichier de configuration $gvsqw_MsqBin/../etc_cust/sqwmsq_GlobalVar.cfg #Options to generate table list with filters (you can mix all off them): $gvsqw_SybBin/sqwmsq_RebuildIndexDatabase.ksh -S $Alias -D <DbName> -IT <listtbl> #Generate table list with 'in list': #=> and name in ('$ListInclude') $gvsqw_SybBin/sqwmsq_RebuildIndexDatabase.ksh -S $Alias -D <DbName> -ET <listtbl> #Generate table list with 'not in list': #=> and name not in ('$ListExclude') $gvsqw_SybBin/sqwmsq_RebuildIndexDatabase.ksh -S $Alias -D <DbName> -IL <likeclause> #Generate table list with 'like': #=> and name like '$LikeClause' $gvsqw_SybBin/sqwmsq_RebuildIndexDatabase.ksh -S $Alias -D <DbName> -EL <likeclause> #Generate table list with 'not like': #=> and name not like '$NotLikeClause' $gvsqw_SybBin/sqwmsq_RebuildIndexDatabase.ksh -S $Alias -D <DbName> -W <whereclause> #Generate table list with 'where clause': #=> and '$WhereClause'