Date based partitioning scheme for HVS

startled_hippo

Hi,

I'm trying to implement data partition in  Documentum 6.7. I was wondering how I can use a date based partitioning  scheme? Apparently, i_partition is an integer and I'm not sure how to  convert a date to an integer without using a partition function like  those supported by SQL or Oracle. I could not find any documentation on  this - any help will be greatly appreciated.

DCTM_Guru

Look at the DATEDIFF function in DQL.  You could subtract the r_creation_date from Jan 1, 2011 and return the difference in days.  This should return a numeric value that if needed you can convert to integer.