DSXchange

Hi All, We've hit a bit of a strange problem here. One of our users has the username 'smorris'. They are set up with Developer permissions in a project. However, we have seen a few instances of other users running a job or sequence in that project, and in Director, the 'User' field in the header det...

Thanks Ernie. The background is that the job that runs multi-instance has 3 stages: SeqFile ---> Tfm ---> Dataset The tfm uses RCP and a schema to basically load up a dataset. There are 7 instances, and based on what you've said above they run sequentially I believe. The loop is a simple counter con...

Hi All, This is a bit of a theory question and I'm afraid probably reveals my ignorance about how DataStage works 'under the covers'. Imagine I have a project that has a default config file with single node. In that project is a job sequence, that has start and end loop activities. Inside the loop i...

Ah, having read that.. am I right to say that putting version="1.1" in the heading wouldn't highlight an issue - problems would come if some 1.1 compliant content (that was not 1.0 compliant) appeared on the files....


Thanks again,
S

Thanks Craig.

Renewed my Premium membership about 15 mins ago, so will read your full answer later once it gets applied to the account.

Cheers,
S

Hi All, I've had a search through, but couldn't find what I was after, so... as per the title really. We have a supplier that is considering "upgrading" the XML files they send us from version 1.0 to version 1.1. As a test, I changed the header line on the input XML from: <?xml version=&qu...

I could only get it to work with Record Delimiter=null - the reason this failed before was that I didn't specify that setting on the output file, only on the input :oops: Still, working as expected now (albeit with the 0D's still there), so will mark as resolved. Thanks everyone for your help. Regar...

If you do as Ray suggests you will need to increase BigCol to hold more than 25 charactes. The "Final Delimiter" is not the same as the "Line delimiter" I tried this by setting Record Delimiter to 'null' - this produced one row of output in DataStage (appears as one row, seperat...

Change the format to "no line terminators" then your Convert() function will work. Of course you will then only have one line of data. Thanks Ray. I have changed the Final Delimiter on the input file to 'none', but this made no difference. Is this what you meant by "no line terminato...

ArndW wrote: this would only output a new data line when a ">" character is found, which usually would mean the end of an end tag...

or the end of an open tag

I'll fiddle with the logic and get it though :D

Thanks very much for that - it's certainly given me a different direction to think in.

Much appreciated.

S

Thanks. Is there an easy way of removing these? The actual problem I have is that I am trying to parse an XML file. One of the elements contains lots of text that is formatted on the file as: <textElement> Lots of text starts here and goes on and on. Then a new bit starts here, causing problems. The...

Hi All, I have a simple test job set up with: SF ===> TFM ===> SF The Sequential Files have a single column (BigCol) of VarChar(25). The input file is: Line One Line Two Line Three And the Hex representation is: http://photos-d.ll.facebook.com/photos-ll-snc1/v1050/92/62/721071516/n721071516_1514339_...

Thanks Ray! I did exactly as mentioned to set the status of the job with a value by invoking a routine which calls DSSetUserStatus function and it worked fine. If we need to catch more than one value and pass it to set of parameters in a sequence job then ,do we need to design those many jobs or can...

Thanks Ray for your suggestion. I have some confusion on this could you please explain 1-1st I will read the values from the table using any dabase stage then how to load the string to job's user status area which will be used in another sequence job? 2-Is the Sequence job will depedent on this job?...