On this page
|Table of Contents|
|exclude||On this page|
|separator|| | |
This macro has all the same parameters as the SQL Macro and behaves similarly in most cases. There are 2 primary reasons for using sql-query:
- Some databases/JDBC drivers support read-only SQL statements. The sql-query macro will attempt to use this support if available. Otherwise it behaves exactly like the sql macro. Read-only support means the database can optimize for read only statements to improve performance. For some databases (PostgreSQL for instance), the read-only aspect is enforced while others it is only a performance suggestion.
- Using CMSP, administrators can configure different restrictions for use of the sql and sql-query macros. This provides greater flexibility allowing more people access to query without having access for other SQL operations. For instance, administrators can create read-only data sources using database access controls and only grant access to those specific data sources.
Common SQL parameters
|SQL-query Macro - 8.x|
|Common SQL parameters -query Macro - 8.x|
select * from test