DSXchange

yep done

Whenever i use a hash file stage with the "Directory path".

an extra "d_" prefix is adding to the hash file.

How can I disable this auto append feature?

Can anyone help me with a tip?

Yup!

Thanks a for all suggestions.

I think I need to put an extra slash.

:D m happy

I want to give the file name in the sequentuial file from job parameters. E.g If i have job parameter like this. Variable Value ===== ===== p_FoldName /dw/dsadm p_File MyFile.Txt I gave like this in the sequential file stage. #p_FoldName##p_File # But not working. CAn anyone tell me wht need to do? ...

When I try to delete a job, i am getting the folloing error. "Job validation is being accessed by another user" The interesting part is , I release the job from director still it throwing me the same error. In this server, only i am working, no chance of someone else accessing the job afte...

Right on target!!

Thank you so much for the reply.....

it was a near logic problem, the minue i removed "OR" with "AND"

I got my buggy run right

Thanks I am closing this issue.

I have an interesting issue which i am not able to find a solution. Any help will be greatly helpful to me. In the transformer constraint, i want to add two condition to reject rows from a particular link. Not( sfpri_Bunit.GROUP_CODE MATCHES "..") Or Not(Left(sfpri_Bunit.GROUP_CODE,2) MATC...

Hi Is it possible for to call the DSLogFatal form transformer stage.

is it possible to give this way, which is not working for me

if DSLink5.Name <> "Arun" Then
Call DSLogFatal("Error in processing", "IDWLineCounter")
END

Can anyone plese help me?

Wht should i give inside iconv.?

Its not accepting @Date.

please help me

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...

Can anybody help me with a function where I can generate the date in this format?

20080729

I have not find any option to get this using oconv iconv.

Please help

Thats funny

I am trying to edit the XML metadata definition using the META data importer. But the problem is the tool is not allowing me to edit "Repeating" property in the Node properties. Why it is not allowing? Wht to do if i want to change the repeatin value form "False" to "True&qu...

I am trying to transfer data from a FLAT file to XML using XML output.

But the root column is repeating so it is not forming a valid xML.

How can i set that the root colum should com ein the file only once?

I have an XSD in hand. I would like to generate a table /xml defnition out of it.

Is it possible to do this using the XML Metadata importer tool in our Datastage?

I also want to generate a sample XML from the XSD. Is it also possible?