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
