Universe Stage

pkomalla · Post by **pkomalla** » Mon Aug 04, 2008 3:05 pm

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

ray.wurlod · Post by **ray.wurlod** » Mon Aug 04, 2008 3:09 pm

Change the file dictionary from MD4 to MD44 (or MD4P if your data already contain a decimal place character).

pkomalla · Post by **pkomalla** » Tue Aug 05, 2008 8:16 am

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

pkomalla · Post by **pkomalla** » Wed Aug 06, 2008 7:43 am

Hi,

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

Thanks

chulett · Post by **chulett** » Wed Aug 06, 2008 8:12 am

I was wondering the same thing.

ray.wurlod · Post by **ray.wurlod** » Wed Aug 06, 2008 3:10 pm

Code: Select all

UPDATE DICT hashedfilename SET CONV = 'MD4P' WHERE @ID = 'fieldname';

Note the keyword DICT that precedes the hashed file's name.