storing Date(YYYY-MM-DD) in Hashed File

satish_valavala · Post by **satish_valavala** » Wed Jan 18, 2006 6:41 pm

I am writing date(YYYY-MM-DD from sequential file) to Hashed file, hashed file is storing in its internal integer format. I need to populate this date to Oracle table date field. Is there any way to populate date to target without doing any Iconv/Oconv conversions. I mean can we store the date as it is in hashed file.

Thanks
VS

ray.wurlod · Post by **ray.wurlod** » Wed Jan 18, 2006 6:52 pm

Make the column VARCHAR in the hashed file.

satish_valavala · Post by **satish_valavala** » Wed Jan 18, 2006 8:38 pm

I tried VARCHAR , by changing metadata. It still showing in DS internal (integer) format of Date. I also tried changing data element to DATA-TYPE (of Varchar), it didn't workout.

ray.wurlod · Post by **ray.wurlod** » Wed Jan 18, 2006 10:51 pm

If you're reading YYYY-MM-DD as a VarChar from a sequential file and loading it into a hashed file as VarChar, there is NO WAY it can be converted into internal format.

Does your job look like this?

Code: Select all

  SeqFile  ------>  HashedFile  ------>  ODBC

I've been seeing a number of developers lately interposing hashed files in data streams in this fashion. There is absolutely no reason to do so, apart from being paid more to come back and improve performance by removing them.