I'm trying to optimize a view I have in release 9.7v8, when I add the "Optimize for 1000 rows" it throws the error "Sqlcode=-104"
the working view DML:
create view myView ( mykey ) as select mykey from user.mytable;
The non working DML:
create view myView ( mykey ) as select mykey from user.mytable
optimize for 1000 rows;
Is it possible to add an optimize option...
User Profile
Collapse
Profile Sidebar
Collapse
pickle
Last Activity: Jun 21 '16, 10:16 PM
Joined: Jan 28 '16
Location:
-
pickle started a topic creating a new database View using the Optimize clause is throwing error sqlcode=-104in DB2creating a new database View using the Optimize clause is throwing error sqlcode=-104
No activity results to display
Show More