Add Oracle hint to iqd file... 1

[magnum2112]

I tried to manually edit an iqd file and add a sql hint (Oracle syntax). The problem is that Transformer can no longer parse the sql and my data source becomes invalid.

Does anyone have an example of how to do this?

 

[DoubleD]

Modifying the SQL in the IQD is just a band-aid. I would suggest looking into why the database is not performing the way you need it to.
There are ways to force your database to handle certain SQL statements a specific way, but I would consider that a band-aid also.

I am what I am based on the decisions I have made.

DoubleD

 

[Draoued]

you can do it , by adding { } around your sql.

in the IDQ:
BEGIN SQL
{ select product from product_table
}
END SQL