DSXchange

No, it's not supported. You could, however, write your own routine that leverages the DSSendMail() function, then anything you like could go into the body.

Sorry, I haven't worked with DB2... what does "it doesn't work if the record doesn't exist" mean? Do you get an error? Oracle wouldn't care and would happily update zero records, I seem to recall that DB2 cares.

Really seems to be unrelated to the original topic.

So... if you remove the attachment filename from the Email Notification stage, does the email go out ok?

At a high level, the FAQ posting details writing a routine to loop thru the delimited string and building one long string where the 'key' fields are repeated per each pivoted column and then a record terminator (LF or CR/LF) concatenated into the string between each 'record'. What you get is one lon...

Target needs to be a string if you want to preserve the leading zero.

AFAIK, there shouldn't be any "special access" required to read that forum, it's one of the public ones. Is that what it is telling you? Anyone else having an issue?

Eric, can you access it directly from the FAQ forum? It's almost at the bottom of the listed posts there.

In what version does that answer change?

Split off, linked and moved to the proper forum.

Another possibility - the technique mentioned in this FAQ post.

How is this any different from your other post on this topic? Other than being... shorter.

I've highlighted what seems to me to be the key difference in what chandra posted. One option is for use when the data is already sorted, the other when the stage does the sorting. Not sure why they felt a need to have two separate options but obviously they did.

Right, almost... and the difference between the two is the key here.

This means if my source data is like 21-03-11 then it should be StringtoDate(Columnname,"%dd-%mm-%yy") and output will be as 21-03-2011. No, your output will be a date which has no external format. If you need another string then you'll need to enclose the result in a DateToString() funct...

Check the Parallel Job Developer's Guide pdf. Documented in the section on the Sort stage oddly enough, page 274 in the 8.5 version I have.

If you are grouping on all twenty columns, then won't each "group" have a single value for each column, including Column 20? Meaning there really won't be a last of several values in that group. Or by "last" do you mean previous as in the value of Column 20 from the previous grou...

Well... it will rollback any uncommitted records when it aborts, so for an "all or nothing" load you need to ensure it only commits at the end. Vikram - don't forget there are two variables that control that: the count based on you posted and another that is time based. Make sure both are ...