DSXchange

An exact search here for 'vertical pivot' will turn up your options. In Server, a hashed file can make this process pretty simple as well.

Your error must be from a run without a transformer, otherwise it wouldn't have mentioned IDENT1 as the active process.

Are there any other warnings in the log? If you Reset the aborted job from the Director, does a new "From previous run..." log entry appear? If so, post the contents.

Sorry, missed that in the code you posted. Your problem is the big IF/END you've wrapped the entire code block in. Move the "ErrorCode = 0" line outside of the END, either that or set it to a non-zero value when your "len(Arg1) = 3" test fails. Regardless, ErrorCode needs to be a...

You need to determine what exactly it is. Use "od" on the UNIX box or bring the file over to your PC and use a hex editor, but do something to find the actual value of that character. Only then will you be able to transform it in some fashion.

With Trim() or Convert() as noted with the proper CHAR() value to indentify them. If you are certain of that value, use CHAR(001) as the value to match on.

You can't - it's one job or the whole project. You can, however, get a list of all jobs in the category and then export them (one by one) in a loop.

Has the job been run at least once so the hashed file has actually been created? Can you verify at the O/S level existence and permissions?

Or properly pre-size the Hashed File's minimum modulus so it is created at the full size and then just filled rather than constantly needing to be extended.

Mike wrote:How did you conclude that Char(255) is equivalent to COBOL LOW-VALUES?

I've been wondering the same thing all along but decided to stick with the assertion that they are 255s rather than "low values".

You need to create it as a "Before/After" type routine, which changes the calling mechanism.

One example here: viewtopic.php?t=134275

Also, an exact search for "Call DSSetUserStatus" will turn up many more.

More cleanup work for me later.... sigh...

Masking is similar but involves still having 'useful' data when you are done, this seems to be just... scrambling.

Here is a fairly recent discussion on the subject.

There's nothing really all that special about those characters and you haven't told us what the resolution is you are attempting. Let's start with - what are you trying to do with/to them?

I split this out from the original post it was added to and linked you back to it for reference. That let's you control the destiny of your version of this problem. That also means I had to guess at your version, O/S, etc so please take a moment and edit your post if I got any of that wrong.