DSXchange

Are those the only two formats or have you seen others in that field?

What is the data type of "field008"? The hex data shows that there are 8 spaces in that field...

Thought it was 's' rather than 'v'... or is that yet another variant?

Well, you can execute an anonymous block - it's just that it will need to look something like this:
You can see the same thing when you supply a proc name to the stage and ask it to generate it for you.

To the best of my knowledge the anonymous block you can use in the SP stage is just a wrapper to call your procedure, there's no provision to provide PL/SQL code in lieu of actually writing a proc.

James - you don't need any special tags or that 'sid' portion, just the simple URL pasted in works all by itself. FYI. :wink: Ray - sorry for the (slight) derail but when did the single character date masks become 'flexible format' masks? I thought (back in the day) that %m matches one-digit months ...

How are you "trying to suppress the left zeroes"?

Hi Upul and Ray sorry for giving the requirment wrong. So this means a simple transformer stage variable approach cannot be used. You'll need to fall back on the dreaded "fork join" design with the aggregator brach getting counts per key and then when joining back together only passing re...

So you are saying that the file you are reading doesn't have a header row in it?

PhilHibbs wrote:Post another thread.

Exactly. As a matter of fact you've already got your own post on that subject, Palci, no need to run around and jump in other people's posts.

Interesting, thanks for posting that. Usually you only need to do that if the path to the executable is parameterized, then as you've done something like 'exec' or the shell ('ksh' for example) go in the command box and everything goes into the parameter box.

Nothing is being "converted" to a linefeed, it just happens to have the same value as one inside that field and thus can be interpreted as one, depending on the tool / viewer used. So vi will present it incorrectly as will something simple like a cat, however the CFF stage should be able t...

There is no "output format" here if the target is a date. So the question remains, are those two examples of what can come in as your date string? 3/21/2011 0001-02-02 So, both m/d/y & y-m-d formats in the same field? If not then please explain what you will be getting with additional ...

Define what "execute" means here - you need to run it once or once per row? Pass parameters to it? Get something back from it? Details, please.

ps. Don't actually use DSSendMailTester, rather look at it to know how to properly use DSSendMail.