|
|
|
|
|
HInfoView (Function) In french: HInfoVue Returns information about a materialized view.
Info("The data of the view was produced on " + ... HInfoView("MyConnection", MyView, hDateLastRefresh)
Syntax
<Result> = HInfoView(<Connection> , <View> , <Requested information>)
<Result>: Character string Requested information. <Connection>: Character string or Connection variable Connection to the HFSQL server that contains the materialized view. This connection corresponds to: <View>: Character string Name of the materialized view found on the server and for which the information is requested. <Requested information>: Integer constant Requested information about the specified materialized view. | | hDateLastRefresh | <Result> will contain the date (in YYYYMMDD format) of the last successful refresh of the view. | hErrorLastRefresh | <Result> will correspond to: - the error that occurred during the last refresh.
- Empty string ("") if the last refresh was successful.
| hRefreshInProgress | <Result> will correspond to: - 1 if the view is currently refreshed,
- 0 otherwise.
| hSQLCode | <Result> will contain the SQL code of the view content. |
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|