DB2查看VIEW定义的SQL文。
select VD.text as V_DLL from syscat.VIEWS as VD where VD.VIEWSCHEMA = 'DB2ADMIN' and VD.VIEWNAME = 'V_DEPT';
字段V_DLL就是VIEW的DLL了。
DB2查看VIEW定义的SQL文。
select VD.text as V_DLL from syscat.VIEWS as VD where VD.VIEWSCHEMA = 'DB2ADMIN' and VD.VIEWNAME = 'V_DEPT';