|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The content of an analysis can be exported in the format of SQL scripts for a specified database (SQL Server, Oracle, ...... |
|
|
|
|
|
|
|
| The CalculatedDefaultValue property is used to:
Find out the SQL expression that defines the default value of an item. This item was defined in the data model editor or through programming.
Define the SQL expression that returns the default value of an item (item described through programming only).... |
|
|
|
|
|
|
|
| Connects the current application to a database that must be interrogated via SQL. |
|
|
|
|
|
|
|
| Starting with version 21, you can manage transactions in SQL code...... |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Modifies the rights granted to a user or to a group on a SQL view or on a materialized view. |
|
|
|
|
|
|
|
| Modifies the rights granted to a user or group on an SQL view or on a materialized view. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Initializes the different SQL variables with information relative to the last query run. |
|
|
|
|
|
|
|
| Allows you to specify the version of the Native SQL Server Connector that will be used. |
|
|
|
|
|
|
|
| The SQLCodeExecuted property gets the SQL code of a query after replacing the parameters with a value. |
|
|
|
|
|
|
|
| An insert query (corresponding SQL statement...... |
|
|
|
|
|
|
|
| Connects the current application to a database that will be queried by SQL through a Webservice proxy (SOAP). |
|
|
|
|
|
|
|
| Allows you to find out the rights granted to a user or to a group on an SQL view or on a materialized view. |
|
|
|
|
|
|
|
| Creates or updates the description of an SQL view or materialized view from the analysis to an HFSQL server. |
|
|
|
|
|
|
|
| Allows you to find out the rights granted to a user or to a group on an SQL view or on a materialized view. |
|
|
|
|
|
|
|
| Creates or updates the description of an SQL view or materialized view from the analysis to an HFSQL server. |
|
|
|
|
|
|
|
| An HFSQL view corresponds to a "memory image" of an HFSQL data file...... |
|
|
|
|
|
|
|
| The SQL functions can be used to handle the MariaDB database...... |
|
|
|
|
|
|
|
| The SQL functions can be used to handle the MySQL database...... |
|
|
|
|
|
|
|
| You can use SQL functions to handle the PostgreSQL database...... |
|
|
|
|
|
|
|
| Hive is a software layer of Hadoop used to run queries...... |
|
|
|
|
|
|
|
| SQL allows performing set operations on groups of files...... |
|
|
|
|
|
|
|
| List of SQL functions: Special case... |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native SQL Server Connector...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|