Beginning with v11.10 dbaccess will accept C language style multi-line comments.
As such, you can write things like:
SELECT * /* this is the
select clause */
FROM customer /* This is the FROM clause */
This will allow for better compatibility with other RDBMS SQL scripts, and it's also SQL-99 compliant.
The other forms of comments recognized by dbaccess will still be available:
- "-- comments" for single line comments
- "{ comments }" for multi-line comments
The syntax /*+
SELECT /*+ FULL ( customer ) */ *
FROM
customer
WHERE
customer_num = 101;
to force the query to make a full table scan.
No comments:
Post a Comment