DSXchange

Hi All, I'm still having some issues trying to get the XML output stage to work without the sequential file stage. Here are some settings that I have tried... Document Settings > Comments > Generate XML Header - unchecked >Header > Include > unchecked > Namespace Declaration - Include checked with 2...

Thanks. Chulett I very much like your idea. I've spent some time removing the sequential file stage that was an output to my xml output stage from my job and setting up the xml output stage to have an output file name etc. Now when I run my job with the xml output stage as the last stage in my flow ...

Hi, Yes what Ernie is saying sounds very like what was suggested happens. A wrapper for a parallel job. However from the sounds of all the responses I don't think it is a concern hence I'll go back to my parallel written job and continue with that. Thanks all for the answers. I'm going to mark this ...

Thanks Ray.

That's a shame for me. So if my parallel job writes multiple files I can't seem to think of a way I could get it to write multiple files without overwriting the original.

Because there is no way to add a unique identifier?

Hi, I got stuck this afternoon trying to use @OUTROWNUM as the suffix for my sequential file name. I have a transformer(TF_HEAD) that links to an xml output file(XML_HEAD) stage that links to a sequential file stage (SF_HEAD). In TF_HEAD I have a column named FILE SUFFIX which is equal to @OUTROWNUM...

woops sorry. Rather than saying a sequence job is loaded in per instance of the XML stage I meant to say "server job". I don't think this changes the answer though.

Hi, We are on DataStage version 8.0. I've just got through the pain of writing a nice little job that reads from a database and then creates an XML document using multiple XML output stages. I've now been told by someone on my team that it is not best practice to use the XML Output stage in a parall...

Thank you so much for your advice. This worked for me.

So to summarize it better I guess what I'm trying to do is convert multiple rows with non repeating columns into a single row with multiple columns. Not just a single row with 1 column.

But the trick with my scenario is that all three transformers lead back to the same oracle enterprise stage. So the rows coming out of the transformers come out one by one. I.e. I want to read all the rows then after all rows are read combine output as originally described. For a join to work you ne...

Hi all, I am just a data stage beginner. I've been searching on the forums on whether it's possible to merge multiple rows from different sources into one row. So far the pivot stage seems to be the closet thing to what I want but I'm still not sure it will meet my requirements. Let me explain. I ha...

Yep Thanks guys.... Command=sed -e Parameters= "s/\&apos;/\'/g;s/\</\</g;s/\>/\>/g;s/DATE_YYYYMMDD/#DATE#/g" MyFile.txt > /tmp/out.txt && rm MyFile.txt && mv /tmp/out.txt MyFile.txt It was just confusing seeing the Command as Sed -e. I wasn't sure whether that Execute C...

Thanks Ray. That way the hint I needed. I've got it to work now. The only thing I'm confused about is how to run a command straight after my sed. In my routine activity I could do a sed, redirect the output to /tmp then do a && and then write another command to overwrite my original file wit...

Hi All, I am having a strange problem whilst trying to use Sed via a Routine Activity Stage in my sequence job. I am doing a global replace of multiple patterns. Sed is working to replace text but as soon as I start to try and replace numbers it is getting totally confused. I assume this is somethin...

Thanks for your responses. Sorry Ray I just did a reply on the original thread where the function code was listed. Ah yes there is XML at play here. In order to get a comma separated list from the oracle database I have used .. select rtrim( xmlagg(xmlelement(c,columnvalue1 ||'~'||columnvalue2||'^')...