{"action":"created","issue":{"url":"https://api.github.com/repos/dbeaver/dbeaver/issues/4675","repository_url":"https://api.github.com/repos/dbeaver/dbeaver","labels_url":"https://api.github.com/repos/dbeaver/dbeaver/issues/4675/labels{/name}","comments_url":"https://api.github.com/repos/dbeaver/dbeaver/issues/4675/comments","events_url":"https://api.github.com/repos/dbeaver/dbeaver/issues/4675/events","html_url":"https://github.com/dbeaver/dbeaver/issues/4675","id":383839553,"node_id":"MDU6SXNzdWUzODM4Mzk1NTM=","number":4675,"title":"View definition not available on Db2 z/OS","user":{"login":"orbanbalage","id":285574,"node_id":"MDQ6VXNlcjI4NTU3NA==","avatar_url":"https://avatars1.githubusercontent.com/u/285574?v=4","gravatar_id":"","url":"https://api.github.com/users/orbanbalage","html_url":"https://github.com/orbanbalage","followers_url":"https://api.github.com/users/orbanbalage/followers","following_url":"https://api.github.com/users/orbanbalage/following{/other_user}","gists_url":"https://api.github.com/users/orbanbalage/gists{/gist_id}","starred_url":"https://api.github.com/users/orbanbalage/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/orbanbalage/subscriptions","organizations_url":"https://api.github.com/users/orbanbalage/orgs","repos_url":"https://api.github.com/users/orbanbalage/repos","events_url":"https://api.github.com/users/orbanbalage/events{/privacy}","received_events_url":"https://api.github.com/users/orbanbalage/received_events","type":"User","site_admin":false},"labels":[{"id":276025405,"node_id":"MDU6TGFiZWwyNzYwMjU0MDU=","url":"https://api.github.com/repos/dbeaver/dbeaver/labels/feature%20request","name":"feature request","color":"009800","default":false},{"id":276013149,"node_id":"MDU6TGFiZWwyNzYwMTMxNDk=","url":"https://api.github.com/repos/dbeaver/dbeaver/labels/x:db2","name":"x:db2","color":"fbca04","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/dbeaver/dbeaver/milestones/76","html_url":"https://github.com/dbeaver/dbeaver/milestone/76","labels_url":"https://api.github.com/repos/dbeaver/dbeaver/milestones/76/labels","id":3466991,"node_id":"MDk6TWlsZXN0b25lMzQ2Njk5MQ==","number":76,"title":"5.3","description":"","creator":{"login":"serge-rider","id":6398845,"node_id":"MDQ6VXNlcjYzOTg4NDU=","avatar_url":"https://avatars0.githubusercontent.com/u/6398845?v=4","gravatar_id":"","url":"https://api.github.com/users/serge-rider","html_url":"https://github.com/serge-rider","followers_url":"https://api.github.com/users/serge-rider/followers","following_url":"https://api.github.com/users/serge-rider/following{/other_user}","gists_url":"https://api.github.com/users/serge-rider/gists{/gist_id}","starred_url":"https://api.github.com/users/serge-rider/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/serge-rider/subscriptions","organizations_url":"https://api.github.com/users/serge-rider/orgs","repos_url":"https://api.github.com/users/serge-rider/repos","events_url":"https://api.github.com/users/serge-rider/events{/privacy}","received_events_url":"https://api.github.com/users/serge-rider/received_events","type":"User","site_admin":false},"open_issues":28,"closed_issues":6,"state":"open","created_at":"2018-07-02T12:22:53Z","updated_at":"2018-11-28T17:34:42Z","due_on":"2018-12-10T08:00:00Z","closed_at":null},"comments":1,"created_at":"2018-11-23T14:15:43Z","updated_at":"2018-11-30T12:30:36Z","closed_at":null,"author_association":"NONE","body":"![image](https://user-images.githubusercontent.com/285574/48947461-8fcfdb00-ef31-11e8-928a-f2ae05c27e67.png)\r\n\r\nThe View definitions are stored as CLOB, which might be the reason it's not implemented - but just casting it to varchar would help in most cases (where the definition is not extremely long)\r\n\r\n```\r\nSELECT\r\nSTATEMENT, CAST(STATEMENT AS VARCHAR(32000))\r\nFROM SYSIBM.SYSVIEWS\r\nWHERE NAME = :_view \r\nAND CREATOR = :_schema\r\nWITH UR;\r\n```\r\n\r\nhttps://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/cattab/src/tpc/db2z_sysibmsysviewstable.html"},"comment":{"url":"https://api.github.com/repos/dbeaver/dbeaver/issues/comments/443189865","html_url":"https://github.com/dbeaver/dbeaver/issues/4675#issuecomment-443189865","issue_url":"https://api.github.com/repos/dbeaver/dbeaver/issues/4675","id":443189865,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0MzE4OTg2NQ==","user":{"login":"Arty68","id":20853780,"node_id":"MDQ6VXNlcjIwODUzNzgw","avatar_url":"https://avatars0.githubusercontent.com/u/20853780?v=4","gravatar_id":"","url":"https://api.github.com/users/Arty68","html_url":"https://github.com/Arty68","followers_url":"https://api.github.com/users/Arty68/followers","following_url":"https://api.github.com/users/Arty68/following{/other_user}","gists_url":"https://api.github.com/users/Arty68/gists{/gist_id}","starred_url":"https://api.github.com/users/Arty68/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Arty68/subscriptions","organizations_url":"https://api.github.com/users/Arty68/orgs","repos_url":"https://api.github.com/users/Arty68/repos","events_url":"https://api.github.com/users/Arty68/events{/privacy}","received_events_url":"https://api.github.com/users/Arty68/received_events","type":"User","site_admin":false},"created_at":"2018-11-30T12:30:36Z","updated_at":"2018-11-30T12:30:36Z","author_association":"NONE","body":"[drivers.xml.txt](https://github.com/dbeaver/dbeaver/files/2633192/drivers.xml.txt)\r\n\r\nBy editing drivers.xml in .dbeaver4\\.metadata\\.plugins\\org.jkiss.dbeaver.core folder.\r\nI was able to view SYSIBM catalog ..etc\r\n"}}
{"actor":{"display_login":"Arty68"}}