Returns information about a materialized view.
Info("The data of the view was produced on " + ...
HInfoView("MyConnection", MyView, hDateLastRefresh)
<Result> = HInfoView(<Connection> , <View> , <Requested information>)
<Result>: Character string
<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. |