DSXchange

Ah... would have been nice to know about the advisory message box. So, no bug but rather 'Working As Designed' as they say.

Assuming they are all located in the same directory, no matter how 'sufficiently different' their filenames were, a suitable wildcard pattern could be "*" or "*.*", I would think. Unless there are other filenames that should not be picked up at the same time, of course. I'm guessing that the multipl...

Can't you do your "wc -l" counting all at once in an External Source stage? Not sure the Filter option in the Sequential stage is the best way to go here, but perhaps it can be made to work.

I would think that should happen automatically, i.e. that it should skip the first record of each file, not just the first file. Smells like a bug to me.

How is that field defined in your Oracle table - NUMBER(what,what) ?

199542 wrote:In my transformer my transformation is as follows
If IsNull( F1 ) then SetNull() ELSE F1 ------>> throwing oracle error

Any error in particular or do we get to guess?

No, that's only applicable for a UNIX server, didn't realize you were running Windows. Ignore that bit of advice in your case. What happens if you fully path your command? $ORCHHOME\bin\orchadmin rm testfile.ds Have you checked in your bin directory to confirm that command is (or isn't) actually the...

So... you can't use a File Pattern, even one like '*' or '*.csv' to read them?

I was wondering. That's what you get for being a triskaidekaworkaholic. You definitely don't want to use the $ when assigning the value. It is not set in the current environment. So, one would need (as noted earlier) to 'source' their dsenv file first, if that is where those are set. If they are def...

Of course.

Dropping the dollar sign makes no sense (sorry Arnd) as that just echos back the string as typed. Some flavors of UNIX echo back an empty line when a value is not set, others specifically tell you it isn't set.

Well... do not specify a Repetition Element (Key) if you have. Also use the 'Single row' Output Mode rather than 'Aggregate all rows'. One of those should fix you, I would think.

What changed? I honestly have no idea why that would be the case. Best to involve your official support provider unless someone here has an idea.

So... the 'Show All' buttons don't show you any processes?

You have to be logged in as the "Administrator" to work with other people's processes.

Including user written routines in routines is a horse of a different color.

If this fixes your problem, please mark the post as Resolved.

Take that advice with a grain of salt. It can easier said than done to just 'build a new table and swap it around for the old one' when there are constraints / foreign keys / RI involved. That should have at least been mentioned. And unless we're talking about a work table, not everyone has the gran...