DSXchange

My error - that's a parallel job solution that I gave.

In a server job using a Transformer stage with VarChar on each side should be OK. Conversion from NVarChar to VarChar and from VarChar to VARCHAR2 should occur automatically.

If it doesn't, please post back.

When you Compile in Trace Mode there is an option to force all players to execute in sequential mode. Perhaps you have this selected?

You should be able to use a Modify stage and a string_from_ustring() conversion for each field in that stage.

"There might be an issue with the database server."

Has the password you're using when authenticating against XMETA expired?

There is a separate &PH& sub-directory in each project directory.

Not at all. Set up a stable, unique sort on the input link to the Transformer stage and map the columns across the stage.

Unless you dump the score, you can not assert that the stages did not run in parallel by examination of the log.

Is this the same question as this one?

Can you give us an example? I'm not quite clear from your description.

Pass them HOW? For example are they contained in sharp signs (#)?

Yes, and it was solved by a routine that ran at the same time as the real-time jobs and monitored their logs.

pandeesh wrote:Just I would like to know whether it's possible .

The answer to that is "yes". But why?

The philosophy of parallel jobs is basically one task, one stage type. That's why there are so many more stage types than server jobs have.

I was not envisaging a DataStage job: I envisaged a sequence containing an Execute Command activity.

You could do it with a job, but that's not what I envisaged.

Again, try (or look at the source for) OpenSequentialFile routine - there's a link to it in my earlier post. You need to SEEK to end of file before using WRITESEQ to insert the new line.

HOW are you "declaring" the parameters? In particular are you using the "add job parameter" tool to the right of the field in question?