Can CA Gen toolset generate SQL code with 'FETCH FIRST 1 ROW ONLY'? If so, how is it coded?
Setting the property "Limit to N row" on the READ EACH and setting the value to 1 will generate FETCH FIRST 1 ROW ONLY. Generation target must be for COBOL and DB2. Other platform targets will not generate this SQL.