Page 1 of 1

Universe Stage

Posted: Mon Aug 04, 2008 3:05 pm
by pkomalla
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

Posted: Mon Aug 04, 2008 3:09 pm
by ray.wurlod
Change the file dictionary from MD4 to MD44 (or MD4P if your data already contain a decimal place character).

Posted: Tue Aug 05, 2008 8:16 am
by pkomalla
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

Posted: Wed Aug 06, 2008 7:43 am
by pkomalla
Hi,

can anyone please let me know how to change the file dictionary in this case.

Thanks

Posted: Wed Aug 06, 2008 8:12 am
by chulett
I was wondering the same thing.

Posted: Wed Aug 06, 2008 3:10 pm
by ray.wurlod

Code: Select all

UPDATE DICT hashedfilename SET CONV = 'MD4P' WHERE @ID = 'fieldname';
Note the keyword DICT that precedes the hashed file's name.