Filter
Top Products
6.11 Changing the User of the Current Session
When an application program accesses a database, the user of the current session becomes the person connected to
the database. This user can be changed in the application program.
Example:
In this example, the user of the current session is changed to USER2.
6.12 Adding Name to Results Column in Query Specificati
on
If a function is specified in the select column list of the query specification, no name is added to the derived columns.
To add a name, use the AS clause and add a column name. An example of specification is shown below.
Example:
The total stock quantity for each product name is fetched from stock table STOCKTBL. In this example,
use the table derived from the query specification to add a name to the total stock quantity column.
125