dbschema with perl var

Bhargav Coca

I am on TS6.5 sp2 on Win 2000, with OD 6.0.2 and DD with standalone deployments. I was wondering if we can build our dbschema with a column which takes value of a perl variable from the DCR?

For example, I have date field which has value of say 06/06/2006. I have a split function inside my tpl which gives me 06, 06, 2006 in seperate variables and i can use these in creating my html. But we need these same variables as columns in my database too? is this possible?

I think i am working on the wrong side of the plate, i guess i some how have to populate 3 different fields in the DCT itself with these values and then use them as reference in my dbschema. Am i right? Please advice.

Thank you

Bill Klish

This can be easily accomplished using the Tuple Preprocessor framework included with DataDeploy. You basically write a java class that modifies the input data. In your case, you will pull the date field, and add back 3 fields to the tuple representing your month, day and year values.