Hi - I am not sure how to delete the table from the meta data repository Xmeta. Accidentally the table definition was defined twice in the QETXT. hence, it created duplicate columns under the same table. However, when I corrected the QETXT and tried "Identify All Levels" it showed me right number of columns but when I tried to import it, it shows me the same duplicate columns. how can I solve this issue?
Thanks
How to delete the tables from the meta data repository?
-
- Premium Member
- Posts: 145
- Joined: Fri Sep 15, 2006 12:23 pm
I'm not exactly familiar with the problem you are running into, so it may be more involved than just cleaning out the table, but I like to do deletions via FastTrack....it has the simplest GUI for it, but if you are running 8.1.2 (possibly this was all in 8.1 with FP1...I can't remember) you can do deletions at the Web Console via the new "Repository Tab", and also within Workbench, and also within IA.
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That new Repository Management functionality in the Web Console for Information Server that Ernie mentioned has specific function for identifying and removing duplicate table definitions from the repository.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 145
- Joined: Fri Sep 15, 2006 12:23 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 145
- Joined: Fri Sep 15, 2006 12:23 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: