I tried this too. But doenst have view create definition On Thu, 25 Jun 2020, 11:54 Ron Hesketh, <[email protected]> wrote:
> Hi Suarabh, > Try the Statement column in SYSIBM.SYSVIEWS. > > Regards, > Ron > > -----Original Message----- > From: IBM Mainframe Discussion List <[email protected]> On Behalf > Of saurabh khandelwal > Sent: Wednesday, 24 June 2020 6:44 PM > To: [email protected] > Subject: DB2 View issue > > Dear Group, > > > > In Db2 v12, when I like to see the view definition and I look at column > “TEXT” in catalog table SYSIBM.SYSVIEWS, it is blank. > > > > > > > > Which was available in previous versions on DB2. > > > > Now, requirement is to see the view definition used during creating this > view. Can anyone help me get this detail in Db2 v12. > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, send email > to [email protected] with the message: INFO IBM-MAIN > > ______________________________________________________________________ > This email has been scanned by the Symantec Email Security.cloud service. > For more information please visit http://www.symanteccloud.com > ______________________________________________________________________ > > > _______________________________________________________________________________ > > This email has been scanned by the Bankwest Email Security System. > > _______________________________________________________________________________ > > > _______________________________________________________________________________ > Unencrypted electronic mail is not secure and may not be authentic. > If you have any doubts as to the contents please telephone to confirm. > > This electronic transmission including any attachments is intended only > for those to whom it is addressed. It may contain copyright material or > information that is confidential, privileged or exempt from disclosure by > law. > Any claim to privilege is not waived or lost by reason of mistaken > transmission > of this information. If you are not the intended recipient you must not > distribute or copy this transmission and should please notify the sender. > Your costs for doing this will be reimbursed by the sender. > > We do not accept liability in connection with computer virus, data > corruption, > delay, interruption, unauthorised access or unauthorised amendment. > > _______________________________________________________________________________ > > ______________________________________________________________________ > This email has been scanned by the Symantec Email Security.cloud service. > For more information please visit http://www.symanteccloud.com > ______________________________________________________________________ > > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
