Refresh a SQL View in ILE
I have created a view and am using in an ILE module. I have updated one of the files that the view is built with. How do I refresh the View to see this record the next time I run the SQL view? Is there a CREATE OR REPLACE VIEW in RPGILE? Thank you.
Software/Hardware used:
Software/Hardware used:
ASKED:
April 7, 2009 5:05 PM
UPDATED:
April 7, 2009 6:45 PM
Answer Wiki:
You can drop the view and create it again but you may not need to
If you "updated one of the files that the view is based on" by adding or deleting a field that is not used by the view no change should be necessary. The view contains the set of rules for gathering the data.
Including the rows to select, the fields to return and the join info.
If the rules don't need to be changed then the view doesn't need to be altered.
Phil
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
