FETCH FIRST 1 ROW ONLY

Document ID : KB000123040
Last Modified Date : 14/12/2018
Show Technical Document Details
Introduction:
Can CA Gen toolset generate SQL code with 'FETCH FIRST 1 ROW ONLY'?  If so, how is it coded?
Environment:
z/OS DB2
Windows Toolset
Instructions:
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.