DSXchange

I have a requirement like the following.

I want to add a dynamic date value in the name space declaration of root tag.

<FOODS xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" Date="2008-09-08">

I know we can declare the name space information in the namespace declaration tag in XML output stage. In the above case, I want the date value to be updated dynamically. Is it possible to call a Datastage function from the name space declaration tab. Or wht is the alternative for my requirement.

FOODS is my root element.

Would appriciate if anyone can help me?

We use parameters in the XMLInput stage namespace declaration textbox. I have to believe the XMLOutput stage would allow it as well although I don't know for sure. I very much doubt you can call a function from there. Therefore you'll have to feed the dynamic value into the job containing the dynamic date namsepace as a parameter via a Sequence or some other external mechanism.