Image Removed
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
b- fixed set of queries that can be run.
- Simplified file access parameter.
Include Page |
---|
| Common SQL parameters |
---|
| Common SQL parameters |
---|
|
Examples
...
{sql-file:dataSource=testDS|file=authorized.sql} |
Image Added