DSXchange

Integers don't have commas in them.

Sorry but your example doesn't really seem to help. Can you explain in words how you got from the posted input to the posted output?

The Member Benefits link on the home page should get you there. Never seen any coupons or promotions other that a corporate discount.

D'oh! Where's a [facepalm] icon when you need one?

Note to self - need to stop assuming everyone has made it to some flavor of 8 by now.

Then you'll need to find a way to move/copy the 'dataset' you are creating on the DS server over to the mainframe. Either that or, as I noted, some kind of NFS mount... if such a thing can be supported in your environment.

You just... do it. Put the whole thing in a parameter then put the parameter in the stage.

What have you tried? What problems have you encountered? I for one would not take this path and would look into using a "sql file". For whatever that is worth.

There is a definite limit on email sizes, that's why file sharing sites exist. Something that size you'll need to upload or ftp, either that or break it up and send it in multiple (separate) pieces.

If "hung for over 15 hours" means that's how long before it started to return rows, I'd wager that the answers to Ray's two questions are over 15 hours and no.

As noted, we advise you to post your conversion derivation for this field.

Yup, the "looping" functionality in 8.5 will greatly simplify this problem... should have noticed that you had that version.

No, any kind of file that gets created gets created 'locally' on the DataStage server. Can you do any kind of an 'nfs mount' between the two systems? Do you have the 390 Edition of DS? That version might be able to since it creates COBOL jobs rather than what we all think of as traditional 'DataStag...

Actual number unknown perhaps but do you know the maximum possible number of columns? If so, you pivot that many and then filter out any 'empty' rows post-pivot.

Pffffttt... must have imagined them.

On the Informatica side of the world one has to strip both the currency symbol and any commas, wasn't sure if that was the case here or not... couldn't recall.

So how did you convert that character dollar amount to a decimal?