DSXchange

NRO means Not Read Only and is another piece of metadata in the table. I would assume you've got your hashed file setup incorrectly. Post your columns and which is marked as the Key field.

Please clarify if one of the different array sizes you tried was 1. And post all of the errors messages you receive complete and unedited rather than something like them. What is your total byte length for the record?

Once you do find the decimal value, you can use the CHAR() function to represent it and then include that in something like Convert() to remove it by converting it to '', an empty string.

Is that actually one character? You need to find the hex/decimal value of it in order to remove it. From UNIX you can try either an "od -h" to dump it in hex or use an actual hex editor to determine that. Lots of free ones out there.

You increased the array size with field sizes like that? Yikes. What happens if you set it to 1?

Jeez, this is like being Bill Murray in that Groundhog Day movie.

Reading logs has been discussed here ad nauseam. A search for DSGetLog or -logdetail should turn them up, the former for a DataStage routine solution and the latter for a command line solution using dsjob.

Yes... but how, exactly? Using anything DataStage (Execute Command stage, ExecSH,DSExecute, etc etc) will decrypt the password for you during the invocation.

Firs thing I'd look into is that large ** WARNING ** block in the message.

I was under the impression that the latest iterations of 8.1 plugged all the leaks in the SS XML, perhaps I was mistaken. We've also seen plenty of examples where you could 'get away' with something in earlier versions that are subsequently fixed in later versions - to many people it appears as a bu...

I wouldn't bother. Give Ernie a chance to look into it first.

There is "no" magic bullet. And as noted, jobs can abort for a very large variety of reasons. You'd need to post specific errors for anyone to provide specific help.

Why would anyone need to post 'the exact syntax' here when you can simply look it up in the Designer's online help? It's all there, including how to get a row count from a particular link.

derekchu wrote:I cannot simple construct a shell command to trigger it.

Yes, you can. Have you tried it yet? What happened?

Actually, this is their thread and is very much related. And I assume your DBA can reset the password for you.