DSXchange

If you run this on a single node, does it run correctly?

Seems like another place where setting APT_OSL_PARAM_ESC_SQUOTE may help.

Or you can set APT_OSL_PARAM_ESC_SQUOTE so you don't have to do that.

Best Practice: You need to use the appropriate functions for those date comparisons - TO_DATE() for all three or TO_CHAR() for the other pair. Doing so will ensure the SQL always works regardless of the NLS_DATE format of the target database. Match the format mask to how they come in as parameters....

I'm guessing you may have missed listing a LOB column as there's no reason I am aware of to split anything when passing by reference. As for the "column ambiguously defined" error, is the stage generating the SQL or did you?

Welcome to last week, Ray.

Since the only difference in running a job via a Sequence versus 'manually' is how the parameters are passed, I'd triple-check them in the affected job's log. For grins, can you verify that you are using a Job Activity stage in the Sequence to run the job? I'd also be curious if your parameters cont...

Both job types can generate data. In my mind it can depend on what kind of data you need and what you mean by "meaningful" data. Is it as simple as (for example) phone numbers that look like phone numbers? Or do you need to generate something like useful names and addresses? So why don't w...

asorrell wrote:I'd still like Ray or someone else to confirm that though.

Confirmed.

1. In a Server job, all of the work happens in a Transformer so you should be able to do what you need there. We'd need more details to provide any help, though. 2. Use the Notification Activity stage in the Seqence to send the email. I'd suggest leveraging the USERSTATUS area of the job doing the c...

I don't see a need for any kind of 'looping' here, just stage variable(s) to tract the current target based on the tags seen and then appropriate constraints on the output links.

As George would say... "OH MY".

... or a patch.

How are you viewing the file? What characterset is being used for it?

Since CSV stands for Comma Separated Values, the first test would be for the presence of commas in the record. Hopefully a count returns the correct number of commas.