Since Informix Dynamic Server 7.3X you have been able to use SQL directives like
SELECT {+INDEX(incident_details id_u1) AVOID_FULL(incident_details)}
id_case , id_in_case, id_status, id_reserve_amt
FROM incident_details
WHERE id_in_case = g_in.in_case
AND id_status = l_id.id_status
This works fine using "dbaccess"
Two questions.
1. Can we use this format with Genero 2.XX
2. If the statement is PREPAREd does Genero check/changed anything or just pass the statement to the backend.
Thanks
Paul
Yes you can use optimizer hints with Dynamic SQL (PREPARE, EXECUTE IMMEDIATE).
However, with Static SQL, {} are treated as 4gl comments and are removed by fglcomp.
Try fglcomp -S to extract Static SQL statements.
Seb
Thanks.
Paul