|
|
|
|
|
|
|
|
|
|
- Properties specific to the description of hFileParameter variables
hFileParameter (Type of variable) In french: hParamètreFichier
 Available only with this kind of connection
The hFileParameter type is used to define the data files taken into account by a scheduled optimization task. The characteristics of these data files can be defined and modified by several WLanguage properties. Remark: For more details on the declaration of this type of variable and the use of WLanguage properties, see Declaring a variable.
// Recalculate the statistics for the files found in "MyDatabase",
// every Saturday at 23:00
Optim is hScheduledOptimization
Optim.Description = "Recalculating the statistics for the files found in the MyDatabase database"
Â
Optim.Scheduling.Month = "*"
Optim.Scheduling.DayOfWeek = "Saturday"
Optim.Scheduling.Hour = "23"
Optim.Scheduling.Minute = "0"
Â
Optim.File[1].Name = "MyDatabase"
Optim.File[1].Option = hOptStat
Â
HAddScheduledOptimization(MyConnection, Optim)
Remarks Properties specific to the description of hFileParameter variables The following properties can be used to handle a hFileParameter variable: | | | | Property name | Type used | Effect |
|---|
| Name | Character string | Name of the file to process. This name can correspond to a string of the following type: - <Database name>/<File name>: Optimizing the "File Name" file in the "Database Name" database.
- <Database name>: Optimizing all the data files found in the "Database Name" database.
- "*": Optimizing all the data files found in all the databases of the server.
| | Option | Integer constant | Optimization options: - hOptIndex: Provokes the re-indexing operation on the data files. A hot re-indexing operation is performed on the indexes and on the full-text indexes.
- hOptStat: Provokes the recalculation of statistics on the data files. The result is similar to the use of HStatCalculate. This process is a hot process.
| | Password | Character string | Password of the encrypted data files. This property is available in write mode. |
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|