DSXchange

First bit of advice would be for you to start your own post rather than append to an existing, unrelated 7 year old question. I've done that for you. And no, you can't. The second can append once the first has finished, however, if we're talking two jobs. One job would use a funnel or other mechanis...

You could also generate the trailer as a separate file and then append it After Job via the O/S: cat trailer_file >> detail_file

There is a discussion of Lookup versus Join in the documentation. Suggest you start there. You can also find discussions here if you search, for example this one.

Have either of you involved your official support provider? John, did you ever get a resolution for this?

Appending is an option in the Sequential File stage. And a count would typically be accomplished via an Aggregator.

We are upgrading server 7.5 version jobs to parallel 9.1 version. Hopefully that does not mean each and every job is being rewritten as a Parallel job because that's just crazy talk. Rewrite the ones that "need" it. Write new ones in PX. Leave the Server jobs alone that do not have perfor...

You can use any table, just craft some SQL that "does nothing"... say, update a record "where 1 = ?" and then pass in a 2 as the value. Select the 2 from DUAL.

It does not reply nor resolve.

(I think it is a bot)

Periods are your friend.

How is $count instantiated? Does it work for you if you replace it with a number?

I could have sworn it was all originally VB. [shrug]

Nope. However this is a generic parameter error, nothing specific to a 'set'. Hopefully someone else can help.

Meaning what, the table has already been loaded? Then just build a job with a single row into the Connector that does nothing and then run the MERGE after SQL. What else does the proc do besides that?

Funny, just found a post of mine from 8 years ago where I ran across the exact same error. However, don't recall whatever became of the answer. Perhaps try DSJ.PARAMVALUE instead?

See previous comments in all of your other posts so far.

Checking your six posts so far, you've got a bad habit of coming here and dropping out rather incomplete generic 'questions' while not coming back and defending / explaining or expanding on any of them. It just seems like a poor attempt at fishing to me. I for one do not plan on 'answering' any of t...