DSXchange

I mean the next step is already a Job Activity. Do you have another idea that I can use? Sorry, but I don't see the relevance of your comment. You can have as many Job Activity stages in the Sequence as you need. So, if you need to, put another Job Activity stage before the existing one. Let it wha...

Do not use UtilityRunJob in this manner. Use a Job Activity stage to run the job, and simply let the trigger to it evaluate the "Var1 > 0" condition.

Oh, a 'loopback connector' or adapter.

A 'root install' means it is installed by the root superuser. I've also been able to do it as 'dsadm' via 'sudo' privledges granted by root to me on the install script.

Perhaps he just missed the 'ALTER SESSION' equivalent for SQL Server before the SET command? I'll be the first to admit I know zip about that database, however.

But you can do 'ALTER SESSION SET blah blah...' in the before sql tab if we are talking database, is that not what is needed here? Or is that too Oracle specific?

You haven't stated your actual problem. And is this in a Sequence job? If so, why not use a Job Activity stage for this?

It's in the Server Job Developer's Guide pdf, but better yet just double-click on the routine itself and all shall be revealed.

Try: NLS_LANG=AMERICAN_AMERICA.UTF8 and also LC_CTYPE=C.utf8 rather than the NCHAR version.

Or:

Might make it a little more obvious what's going on.

It would need to be in a Job Parameter to be able to use it in a query, so you'd need something to get it from the hashed file out somewhere it could be picked up from - a flat file, perhaps or $UserStatus.

For strange hauntings you'd need to go back to IBM Support, they are the official Ghost Busters.

Session parameters won't help, run the query from NLS_DATABASE_PARAMETERS and let us know what you find.

DSG2B: It would probably help if you also explained what exactly that is doing, the 'how' of the 'what', if you will.

Tell us A) how you set this and B) what value you set it to.