Good morning! I have an RPG program that is creating a view. If I call the program it creates the view. I can then go into SQL and view the data. However, once I sign off and back on the view is gone.
I didn't create the view QTEMP, so my understanding is that it's like a logical and should stay. Does anyone have any suggestions where my problem might be? Here's my create command that is being called via QCMDEXC within the RPG program:
create view jda2dts/j_invaud as select * from invaud where itrdat >= 101227
Thanks for any input!