You can use macro substitution to store the SQL SELECT statement created for a view into a variable that you use with the AS clause in the CREATE SQL VIEW command.

To create a view using macro substitution

Create a variable and store the SQL SELECT statement in the variable.
In the AS clause of CREATE SQL VIEW command, use the ampersand (&) macro substitution character followed by the variable name.

For example, the following code stores a SQL SELECT statement into the variable MyEmpCustSQL. CREATE SQL VIEW creates a view named EmpCustView using the variable:

В	Copy Code
MyEmpCustSQL = "SELECT employee.emp_id, customer.cust_id, ; customer.emp_id, customer.contact, customer.company ; FROM employee, customer WHERE employee.emp_id = customer.emp_id" CREATE SQL VIEW EmpCustView AS &MyEmpCustSQL

Copy Code

MyEmpCustSQL = "SELECT employee.emp_id, customer.cust_id, ;
   customer.emp_id, customer.contact, customer.company ;
   FROM employee, customer WHERE employee.emp_id = customer.emp_id"
CREATE SQL VIEW EmpCustView AS &MyEmpCustSQL

To create a view using macro substitution

See Also

Other Resources