Oracle SQL in source code

Example of adding an Oracle HINT to use a specific index. It appears the Ventyx precompiler skips over SQL that it does not recognize.

EXEC SQL DECLARE TIVM10SC1 CURSOR FOR
SELECT
*CUST BEGIN
/*+ INDEX(TIDWOWRK TIIWOWRK_CUSTOM) */
*CUST END
WORK_ORDER_NBR,
...
WO_DESCRIPTION
FROM TIDWOWRK
WHERE (FACILITY BETWEEN
:FACILITY-ORG AND :FACILITY-END)
AND (PLANNER BETWEEN
:PLANNER-ORG AND :PLANNER-END)
AND (WO_STATUS BETWEEN
:WO-STATUS-ORG AND :WO-STATUS-END)
AND (JOB_ACTIVE_IND BETWEEN
:JOB-ACTIVE-IND-ORG AND :JOB-ACTIVE-IND-END)
AND (DISCIPLINE BETWEEN
:DISCIPLINE-ORG AND :DISCIPLINE-END)
AND (WORK_ORDER_NBR BETWEEN
:WORK-ORDER-NBR-LO AND :WORK-ORDER-NBR-HI)
ORDER BY WORK_ORDER_NBR DESC
END-EXEC.

By Anonymous

Reply