DSXchange

What kind of job - Server, Parallel? One would typically use the Complex Flat File stage for reading mainframe EBCDIC files as it will handle all of that for you.

Both of those are examples of How It Works with numeric values in a flat file. The space is a place holder for the sign (i.e. where the minus sign would go if it was negative) and the leading zeroes are not significant. I know it's not how you want it to look but neither one should be causing a prob...

When you say it goes slow when you run it "against all database instances in parallel", do you mean you are targeting the same table in separate databases with each invocation id? Assuming that's what you meant but wanted to clarify.

When people post examples they rarely fully match reality (if at all) so I'll typically answer with general / generic advice. Did much the same here so they can apply it to whatever their specific situation is, as needed.

Thanks for sharing! :D

What's the point of what?

As noted I would assume it's simply the fact that you have a BASIC Transformer in the job and that it has no parallel capability, thus creating a choke point. From what little I recall, it is restricted to running on one specific node - head? conductor? - don't recall which but I'm sure someone know...

Or perhaps leverage rsh for that.

And just to round this out, here is a Technote in case someone needs to manually delete a project - i.e. one that is corrupted or otherwise cannot be deleted via normal means.

From what I recall, the dsadmin command line function has a -deleteproject option.

Edited to add: Command Line Interface documentation link

Okay, should have realized this was more of your other topic: Is it possible to call a cobol stored procedure in db2 mainframe (z/os) from datastage? Also, I would appreciate if one can share the differences between a cobol stored procedure and db2 mainframe stored procedure? Let's just put them bot...

Go ahead?

It would help if you actually asked a question or let us know what you've tried and the issues you are facing.

So... RDC is the "Remove Duplicates" stage, yes?

Yes, one would need to sort on all of the "group by" fields, in this case OID. I would wager if you did more extensive testing on larger data sets you would no longer receive 'proper output'.

Pass in a valid value? There's not enough information posted for anyone to help, unfortunately. Any chance you are leaving an argument empty?