FETCH FIRST 1 ROW ONLY

Products

• Gen
• Gen - Workstation Toolset
• Gen - Host Encyclopedia
• Gen - Run Time Distributed

Issue/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

Resolution

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.