All of the SQL Accelerator Drivers now support the following syntax:
view{'field_label',PROP:Name} = string
to change the field's name in the generated SQL. This is normally a name that will be used for a field in a SELECT statement.
Example:
PROGRAM
MAP
END
EMP FILE,DRIVER('ORACLE'),NAME('EMP'),PRE(EMP)
P_EKY_EMP KEY(EMP:EMPNO),NOCASE,OPT,PRIMARY
KEY_DEP KEY(EMP:DEPTNO),DUP,NOCASE,OPT
Record RECORD
EMPNO SHORT !Emp-no
ENAME CSTRING(11) !Employee name
JOB CSTRING(10) !Job
HIREDATE DATE !Hiredate
MGR SHORT !Manager
SAL PDECIMAL(7,2) !Salary
COMM PDECIMAL(7,2) !Commisison
DEPTNO BYTE
END
END
v VIEW(EMP)
PROJECT(EMP:EmpNo)
END
CODE
OPEN(EMP)
OPEN(v)
CODE
OPEN(EMP)
OPEN(v)
v{PROP:Order}=SQL(1)
v{'EMP:EmpNo',PROP:NAME} = 'count(*)'
SET(v)
NEXT(v)
MESSAGE(EMP:EmpNo)
This example will produce the equivalent of “SELECT count(*) FROM EMP”.
See Also: PROP:SQL , PROP:Order