Showing Error in the ststement
DB2 SQL error: SQLCODE: -20211, SQLSTATE: 428FJ, SQLERRMC: null

CREATE VIEW LimitView AS
SELECT lcl,ucl,cl FROM DBO.THRESHOLD
WHERE
DBO.THRESHOLD.paramname='RPM of Spray Pump'
AND
DBO.THRESHOLD.stepname='Achieve the desired parameters for pressure, temperature and RPM'
AND
DBO.THRESHOLD.productname='Curin'
AND
DBO.THRESHOLD.unitoperationname='Wet Granulation, Drying & Final Blending'
FETCH FIRST ROW ONLY

if you look in messages and code
SQL20211N
it indicates the fetch first.... is not allowed

Hi,
Please help me to convert this view.

query1:='CREATE OR REPLACE VIEW Step47view AS
SELECT * FROM (
SELECT * FROM(
SELECT * FROM (
SELECT time_stamp ' || query1 ||' FROM '|| Param9 ||' GROUP BY time_stamp ORDER BY
time_stamp DESC
)
WHERE
time_stamp >= TO_DATE('''||Param4||''',''MM/DD/YYYY HH24:MIS'')
AND
time_stamp <=TO_DATE('''||Param3||''',''MM/DD/YYYY HH24:MIS'')
AND ROWNUM<='||Param11||'
)
'||Param9||'
ORDER BY
time_stamp
ASC
) WHERE ROWNUM<='||Param10;
I am facing problem in rownum part. I changed that to "FETCH FIRST N ROWS". But its showing error that that cant be used with create view.