I love DB2LOOK for many reasons. Its a wonderful and easy way to reverse engineer a database. DB2LOOK can generate DDLs for specific table(s), but what if we just want indexes to be reverse engineered, thats were db2look hits the brick wall. \u00c2\u00a0I wonder why ibm didn’t provide a way just to get the indexes, so I wrote a simple sql for it. \u00c2\u00a0It does not do include or MDCs for now. But I am working on it :<\/p>\n
with temp1 (col1) as I know it has few limitation, but its a start !<\/p>\n","protected":false},"excerpt":{"rendered":" I love DB2LOOK for many reasons. Its a wonderful and easy way to reverse engineer a database. DB2LOOK can generate DDLs for specific table(s), but what if we just want indexes to be reverse engineered, thats were db2look hits the brick wall. \u00c2\u00a0I wonder why ibm didn’t provide a way just to get the indexes, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","site-transparent-header":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[3],"tags":[245,244,52,246],"class_list":["post-390","post","type-post","status-publish","format-standard","hentry","category-db2","tag-db2-index","tag-db2look","tag-indexes","tag-reverse-engineer"],"_links":{"self":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/390","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=390"}],"version-history":[{"count":5,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/390\/revisions"}],"predecessor-version":[{"id":1533,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/390\/revisions\/1533"}],"wp:attachment":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=390"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=390"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=390"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n(
\nselect ‘create ‘||
\ncase
\nwhen uniquerule in (‘U’,’P’)
\nthen ‘unique index ‘
\nelse ‘index ‘ end
\n||rtrim(indschema)||’.’||indname||’ on ‘||rtrim(tabschema)||’.’||tabname||’ (‘||replace(colnames,’+’,’,’)||’)’||
\ncase
\nwhen indextype = ‘CLUS’
\nthen ‘cluster ‘
\nelse ‘ ‘ end
\n||’allow reverse scans;’
\nfrom syscat.indexes where indname like ‘X%’
\n)
\nselect replace(col1,'(,’,'(‘) from temp1;<\/em><\/span><\/p>\n