HI ,
I populated a hash file in job1.
I tried to open that hash file through UV stage but when I try to view the data it gives MetaData mismatch. And some columns are missing and some columns have shifted.
Data veiwed from Hash File
col1 col2 col3 col4 col5
M 198905 1989-05-01 1985-05-31 26
M 198910 1989-10-01 1989-10-31 27
M 199006 1990-06-01 1990-06-30 25
M 199009 1990-09-01 1990-09-30 24
Data viewed from UV Stage( column missing & order changed)
col1 col2 col3 col4 col5
198905 -- --- --- M
198910 --- --- --- M
199006 -- --- --- M
199009 -- --- --- M
I checked the metadata..everything looked fine.
What cane be done
Thanks
Sumeet
Metadata Mismatch-Hash File when Opened in UV stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Everything isn't fine. Check the hashed file stage again, but this time scroll right in the columns grid. You will see that the fields are referred to by position, not by name. Therefore, when you changed the order, it wasn't happy.
Import and load the UniVerse table definition from the hashed file if you want to refer to columns by name in arbitrary order.
Import and load the UniVerse table definition from the hashed file if you want to refer to columns by name in arbitrary order.
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.