DSXchange

Thanks Craig. I will give Ray's suggestion a try. I was attempting to read each row as one long string, thinking that might be a better way to deal with the extra LFs. I'll use the actual file definition with the "contains terminators" option set to 'Yes'. I'll update with my results. Than...

Thanks for the suggestions so far. I think I'm getting closer, but in effect, my ultimate goal is to join two rows that have been artificially broken by the presence of the wayward LF. The file is delimited, so I use the Count function to identify the row with the extra LF. For those rows, my syntax...

I've seen some replies to problems similar to this, but haven't yet been quite able to make anything work. We have a sequential file coming from a vendor in which a particular column occasionally contains a LF character (X'0A'), even though the end of the row has not actually occurred. Of course tha...

Wondering if anyone else might have run into this strange problem - We have a couple of new Server realtime jobs that read messages from MQ queues, and populate SQL 2008 tables. Very basic design: Container (with a Websphere MQ client stage) --> Transfomer --> ODBC stage (I should also add that our ...

Ray - Thanks for verifying that it can in fact be done. Care to share any more specific details about how you accomplished it?

In our current Production environment, batch level jobs generate email notifications for any jobs that abort or end with warnings. We are in the process of implementing several realtime jobs, which will run 12 - 14 hours each business day. We've been asked if it would be possible to generate email n...

Thank you guys both for your replies. I obviously don't have a lot of experience with xml, and after I posted I did some further reading and found that what I was seeing was normal. :oops: A big thanks for telling me how to convert it. (I always wondered about the 'XML' value in the Data Element col...

I'm currently in the process of building an xml document through DS, and I've utilized one of the techniques in the Best Practices document. Specifically, I'm using the technique in section 3.1.3.1.2 Addresses. In that technique, a series of addresses in a flat file are fed through a transformer to ...

Craig - Thanks for your response. I've tried all of those lowest level fields as the key, and unfortunately I still only got the single pair of <event></event> tags, and not the desired multiple sets. Even though it's a little hokey, at this point I think I may just use a script to insert those tags...

At this point I haven't selected a particular field as key. From this layout that was provided there doesn't appear to be a good candidate, but I'm guessing employeeID might work.

I've read and re-read the XML Best Practices doc several times, and I'm still not sure if my problem is because DS can't do this type of xml output (not likely) or my relative inexperience with xml (more likely). Here's my xsd. - <interaction> - <!-- Copyright (c) 2002 SRA International, Inc. All Ri...

Thanks eostic. I didn't realize it was an early 8.x issue (we're on 8.01 - definitly early 8!). I did eventually figure out that by removing the "defns:" value in every column, I could get rid of the columns. And since the namespaces aren't important to my output, this workaround works for...

I didn't see this particular issue mentioned in previous posts, and I have to think it's a simple error on my part. I have an xml layout (a sample of which is posted below), which I've imported into DataStage for use as an xml output file layout. Seems to work ok, with the exception that my tag name...

Thanks Ray! I tried that function and it provided what I needed. It was a much more elegant solution than what I was coming up with.

Thanks again.

Tom

Ray -

It's just for one time zone. In fact the value is provided in the source data that I receive, so I simply have to take that value and subtract that number of hours from the timestamp.