Description
This macro has similar parameters as the SQL Macro and behaves similarly in most cases. There are 2 primary reasons for using sql-file:
- Security - it can be secured separately from the other SQL macros.
- Using CMSP, more general users can be authorized to use this macro since the administrator controls what queries can be accessed.
- When not using CMSP, the administrator can disable the sql and sql-query macros and still allow the sql-file macro since it has a fixed set of queries that can be run.
- Simplified file access parameter.
...
Examples
No Format |
---|
{sql-file:dataSource=testDS|file=authorized.sql} |
Image Removed
...
Include Page |
---|
| SQL-file Macro - 8.x |
---|
| SQL-file Macro - 8.x |
---|
|