F. Report-Writer Report Examples : ACCOUNT Example : QUEL User Notes for ACCOUNT Example
Share this page                  
QUEL User Notes for ACCOUNT Example
You cannot use delimited identifiers, schema or owner qualification for table names, or the decimal data type in QUEL queries. Therefore, to create a QUEL version of this report, you have to set up the tables without delimited identifiers as column or table names. The balance column is data type float8 rather than decimal (12,2). You are not able to use owner qualification for the customer table.
An equivalent QUEL query for a similar example would be:
/* ACCOUNT - example of bank statement report. */
.NAME account
        range of t is transact
        range of a is account
        range of c is customer
        retrieve (c.name, c.address, c.city, c.state, c.zip,
            a.acctnum, a.balance, t.transnum, tdate = t.date,
            withdrawal = t.amount * t.type,
                deposit = t.amount * (1 - t.type),
                amt = (t.amount * (1 - t.type)) - (t.amount * t.type))
        where a.acctnum = t.acctnum and c.name = a.name