Hi all,
I am trying to use a universe stage to do a range lookup , this is for small amount of data , what i did was i loaded the data into a hashed file and then i am accessing through a universe stage , i have a decimal value which is 11,4 in the hashed file ,but i changed it to numeric and the data changed from 518.0000 to 0.0518 , how can i still read 518.00 in the universe stage.
Appreciate any thoughts
Thanks
Universe Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi,
Yes my input data has already contain a decimal place container,
Can you please explain me how to make this change , i loaded some data into the Hashed file from a DB2UDB table . Hashed file is created in the project directory , Then i imported the metadata from the table definitions using the universe file definitions , Can you please correct me if i am wrong.
Thanks again
Yes my input data has already contain a decimal place container,
Can you please explain me how to make this change , i loaded some data into the Hashed file from a DB2UDB table . Hashed file is created in the project directory , Then i imported the metadata from the table definitions using the universe file definitions , Can you please correct me if i am wrong.
Thanks again
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
UPDATE DICT hashedfilename SET CONV = 'MD4P' WHERE @ID = 'fieldname';
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.