AS400 CREATE VIEW - how can I retrieve the SQL statement used to create a VIEW?

Question

I have created many SQL VIEWs but the only way I have of maintaining a record of the SQL behind each logical view is to save the original create view SQL command in a txt document on my server. Can I query the AS400 somwehere to find the SQL behind a VIEW?

Thanks

Answer 1

http://search400.techtarget.com/tip/0,289483,sid3_gci1162160,00.html

Answer 2

Well, God did create a one everlasting book...the bible. However, he didn't skywrite it. God created the world because he is all good, and perfect. he had this overflowing glory that he wanted to share, so he created the world. Adam and Eve sinned, and we are a fallen, sinful world. Without sin, every person could walk outside, look at the sky, and say "wow, God exists." But we are sinful. It is our SINFUL nature to supress what we internally know is true. God can and DOES change people. he reveals himself to people all the time. He already skywrote it. Jesus died on the cross after performing tons of miracles and fulfilling tons of prophecies, and then he rose after being dead for 3 days. It doesn't get any more clear than that. Even people who were alive back then and SAW it didn't all believe, or he wouldn't have been crucified. God did skywrite it, we just chose to ignore it.

Answer 3

If AS400 supports information schema, you can use:



select TABLE_NAME,view_definition from INFORMATION_SCHEMA.views