DSXchange

Hi Amey so which of the above did you chose. Modify the Batch job or Use the Sequence with no dependencies between jobs. This question is for every one. If use the job sequence with no dependencies between jobs, how would we error handle. i.e if a job aborts then it will cause the sequnce to abort w...

Thanks a lot chulett. Using a string of spaces solved the puzzle.
Really appreciate your help

Chulett, one more observation. This function is replacing only the first character in the list. If the string conatains a ~, then it is replacing with space. If it conatins any other character, the function is just getting rid of them. I changed the order of string to make sure I am right. `!@#$%^&a...

Chulett really appreciate your help.
The function almost worked except, it is not replacing the characters to space. It is just getting rid of them.
Can you tell me what does the inclusion of char(34) will do.

I want to get rid of special characters in my data. ~ ` ! @ # $ % ^ & * ( ) _ - + = { [ } ] | \ : ; " ' < , > . ? / (They may not be called special characters I guess) I dont want to see the above characters in the output table. If I see them then I have to replace them with space. Can anbo...

Hi all
I have few jobs which are running fine in production for the past 8 months.
They have XML input stage. Today they aborted with the same error.
ds_seqput: error in 'write()' - Disc quota exceeded. Does any one encountered this error. Any feedback will be appreciated.

...this is assuming that your "input" xml chunk defined above has already been collapsed or built as a single column and single row coming into the XMLOutput Stage...

Ernie is there any way what I want to acheive.

Absolutely. Just pass it thru "one more" XMLOutput Stage (which is what you'd do if it were all in a single job. You can't just "paste" the xml snippets together without wrapping them in a higher level element(s). So... have an XMLOutput stage with an input link and an output li...

Hi Guys,
Is there a way to get rid of the following when generating XML using datastage XML output stage.

<?xml version="1.0" encoding="UTF-8"?>.

Appreciate your help.

Hi Guys,
Is there a way to get rid of the following when generating XML using datastage XML output stage.

<?xml version="1.0" encoding="UTF-8"?>.

Appreciate your help.

When I am executing a TCL command in a routine to get the category of a job in a project, the output is returned as below

Developers Work Area
\U495278 Velagapudi\
JDAXml

How can I get it as below

Developers Work Area\U495278 Velagapudi\JDAXml

Hi all, right now I am able to generate an xml file below with 4 different DS jobs appending to the same file. <!-- Area --> <entry org_cd="00010" org_level_cd="AREA" name="USSTO" locationname="COMPANY1"> <orgrel org_cd="COMPANY1" org_level_cd="...

Hi guys does any body know how to get rid of the below text while generating xml using xml stage? Please let me know.

<!--
- Generated by Ascential Software Corporation, DataStage - XMLOutput stage -
- Mon Apr 23 17:00:47 2007
-->

I am still waiting for xsd guys. Once I have it, I will come back to this and will let you know. But I dont think XML meta data importer will accept the DTD file to import. Its asking for the xml file or xsd file. When I use the dtd file, it is throwing a format error . The File specified was not re...

Craig
I asked for the xsd.
When I am trying to use the dtd file it is throwing me an error.

The file specified was not recognized as a valid xml or xml schema document.