Metadata Mismatch-Hash File when Opened in UV stage

[sumeet]

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

[ray.wurlod]

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.