Using FIELDS option in progress 4GL with Oracle DB

Posted by nilesh_pharate on 19-Jan-2015 03:27

I am using progress 10.2B and Data Server for Oracle. As per FIELDS option in query, we can use fields option to get only certain columns of table, but when i used FIELDS option and checked SQL query with QUERY-TUNING, i observed that it is picking all columns instead of those which are specified in FIELDS option. I also used Data Server Start Up Parameter "-Dsrv optimistic", but still it is not working.

Anyone has tried this or faced same issue ? Please comment your observations.

OpenEdge RDBMS - Forum

All Replies

Posted by Rohit Kumar on 19-Jan-2015 03:51

Can you post the ABL code you are running and the generated SQL? What is the exact OpenEdge version?

Posted by gus on 19-Jan-2015 15:00

note that even when you use FIELDS, if your code references columns that you didn't ask for, or you update rows you didnt ask for, 't you create new rows, you may still get all the columns.

Posted by sgarg on 22-Jan-2015 01:54

I hope that you are not missing the NO-LOCK option to the query. FIELDS works in combination with NO-LOCK.

This thread is closed