DSXchange

Doesn't really address 'compiling' though, does it? I would use the "Multi-Job Compiler" for this as it does more than just jobs.

Sai, just want to make sure you're understanding the question. This isn't about data "streams" or data at all, this is about having two groups making changes to "the same job" - i.e. starting from a common point and creating two new versions from it - and then needing to merge th...

You cerainly should be able to, what have you tried? Post your syntax for us, please.

Question: are your 'day' and 'month' portions always two digits, i.e. have leading zeroes for single digit values? If so, that will simplify this.

And you think you need UltraEdit to accomplish some part of that?

Not, it's not or you wouldn't get this error. Make sure you are calling / checking the right job and that your spelling matches exactly.

Suggest you learn the equivalent PX functions for this, they are listed in the Parallel Job Developer's Guide pdf in the Functions appendix, specifically the Date and Time Functions and the Type Conversion Functions section. A coule of examples:

DateToString
StringToDate

This is just normal Command Prompt 101 stuff that I guess more and more people have absolutely no clue about having grown up in a completely GUI world. [sigh] :!: The directory a command lives in needs to be in your $PATH to be able to execute it 'from anywhere' - that $PATH variable lets it find it...

And?

So... what role exactly would UltraEdit be playing here?

The output wanted doesn't really matter, as Arnd noted the answer is still 'no' for any kind of automated solution. You'll need to do it manually.

Nothing but? Come on!

Yes, by 'pruning' I mean the same that it means in other areas - removing old, dead parts. So, setup a cron script to do this automtically or check manually and remove anything in there in each project over X days old.

Nice. The changes coming to the venerable Transformer stage are pretty

You can use either type of job for this. How exactly are you "trying to connect to web services"? What errors / issues are you seeing?

Meaning, in Oracle in the target DML? Then any valid DML would work there. Why not do this "transformation" in the job itself?

Good to know, thanks for posting the link. Pretty much just wanted to say that Oracle itself has no such need, so it must be something specific to the way the stage is implemented.