DSXchange

I've opened up a combined PMR for my two issues with this project and will post back with the resolutions here when I have them. Being classed as the lowest priorty in their system, no clue how long before someone contacts me, however.

First problem is you have unmatched quotes:

"%report%)

Secondly, what is "%report%" supposed to be? Specifically questioning the use of the percent signs and finding nothing called 'report' in the code for the body of the email.

So... I don't see any actual change.

Post your DSSendMail syntax again, please.

Okay... can you generally compile jobs with transformers and just this one has a problem or you cannot compile any job with a transformer?

Not sure what's stopping you. Simply create the second one noted as User Defined if it's not in the official list of environment variables.

Post the actual errors, please.

I believe that you'll need to pivot the data, specifically that second 'CDE' row needs to become two rows and then the XML Output stage can club them back together as desired.

index_of_substring_basic()
substring_1()
compact_whitespace()

Those are new ones on me, guess I need to go and try to look them up.

Bottom line, Satheesh, is that your sequential file will always be created regardless of how many records are written to it, including zero. So you will either need some kind of 'work around' to fake this (as posted) or just live with and don't worry about it (which is what practically everyone does).

I guess I'll open yet another PMR with IBM. Thanks.

I've seen BigInt issues with the Pivot stage but don't recall seeing anyone posting Stored Procedure issues. Probably best to check with your official support provider.

If you mean that perhaps it is fixed, forgot to add that when I rerun the VERIFY.SQL for that table after the resize I still get the same error re: UV_SCHEMA.

All resize tells me is this:

You need to check the manuals, they describe how to generate / capture the default stylesheet which you'd need to carefully modify to do your redirection.