I question that. What do you see there? On Thu, 25 Jun 2020 20:12:41 +0300 saurabh khandelwal <sourabhkhandelwal...@gmail.com> wrote:
:>I tried this too. But doenst have view create definition :> :>On Thu, 25 Jun 2020, 11:54 Ron Hesketh, <ron.hesk...@bankwest.com.au> wrote: :> :>> Hi Suarabh, :>> Try the Statement column in SYSIBM.SYSVIEWS. :>> :>> Regards, :>> Ron :>> :>> -----Original Message----- :>> From: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> On Behalf :>> Of saurabh khandelwal :>> Sent: Wednesday, 24 June 2020 6:44 PM :>> To: IBM-MAIN@LISTSERV.UA.EDU :>> 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 lists...@listserv.ua.edu 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 lists...@listserv.ua.edu with the message: INFO IBM-MAIN :>> :> :>---------------------------------------------------------------------- :>For IBM-MAIN subscribe / signoff / archive access instructions, :>send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Binyamin Dissen <bdis...@dissensoftware.com> http://www.dissensoftware.com Director, Dissen Software, Bar & Grill - Israel Should you use the mailblocks package and expect a response from me, you should preauthorize the dissensoftware.com domain. I very rarely bother responding to challenge/response systems, especially those from irresponsible companies. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN