DSXchange

Yes. Vertical pivot a.k.a. Rows to Columns.

Yah, not really sure why Oracle got thrown into the mix. It doesn't answer the question that was asked and no database was mentioned, let alone a specific one.

Remove? Don't. Convert? Do that by identifying and using in the job the proper characterset being used by the file.

The "s" means it can have a leading space. If "1-2 digits without a leading 0" means "1 thru 12" you can just use %h I would think.

Hmmm... another of those silly things that I thought would go without saying and would have already been done. If you're not sure what something should look like in a dsx, make the change in a job (or create a test job to futz with) and then export it.

What have you tried?

Contact support.

What's "not working" about it? Seems to me you'd need to post snippets of the dsx in question, the section that includes that information before anyone could provide specific help. Before and after examples (to show what change you made) would be best and then explain what happened after y...

There's also a specific forum here for things of that nature... moved.

You could also leverage "round robin" as a partitioning method if you wanted the split to be across all nodes, be it three or whatever.

Not sure what kind of answer you are expecting (or why the anger) but since we're talking about a dsx export file... you do it using a text editor.

That very thought occurred to me while I was driving into work this morning... figured someone else would probably beat me to it.

Seems to me you'd need to stick with DB2 utilities for this.

Taking a wild guess here... Project Plus.