I need to write a program which creates a complex SQL view. However when I do it by RPG embedded SQL or use the RUNSQL command it locks the view (see picture).
I need to change the view description and owner on the fly which I can't because the file (view) is locked.
How can I create the view without locking it? Or how can I release the lock?
Thank you
I need to change the view description and owner on the fly which I can't because the file (view) is locked.
How can I create the view without locking it? Or how can I release the lock?
Thank you
Comment