MVSFORUMS.com

kingo · Posted: Wed Jul 02, 2008 12:47 am Post subject: Load into view

Can anyone please tell me is it possible to load into a view and if yes how it works as view is not a physical entity and do they inturn load data to the base tables of the view?
_________________
IF YOU ARE NOT FOCUSSED ON GOAL ALL YOU SEE IS OBSTACLE.

jim haire · Beginner Joined: 30 Dec 2002 Posts: 140 Topics: 40

A view is not a physical entity as you mention. You don't load into a view. You load into the table(s) that the view uses.

jsharon1248 · Posted: Wed Jul 02, 2008 11:51 am Post subject:

From the DB2 Utility Guide and Reference for z/OS v8:

kingo · Posted: Thu Jul 03, 2008 1:36 am Post subject:

Thanks Jim and jsharon1248 Smile

_________________
IF YOU ARE NOT FOCUSSED ON GOAL ALL YOU SEE IS OBSTACLE.