DSXchange

Could someone please provide an example on how I might setup the userstatus variable and populate it. I have researched the guide and forum to no avail.

Thanks in advance.

P.s. I will be using the variable further on in a job sequence.

You can set the user status for a job using DSSetUserStatus.
You could build a small routine around this and call it for setting the userstatus of that job.


Once you have set the UserStatus, you can refer it in the following jobs in your Job Sequence, using JobName.$UserStatus

Huh... quite a number of posts on the subject that a search should turn up. This one, for example.

I created a routine and tried to call it in the derivation of the stage variable, I kepp getting told that my routine doesn't exist. Is there an environment variable that needs to be turned on

The ability to use DSSetUserStatus() only exists in server jobs, the BASIC Transformer stage or server shared containers. It is not possible from parallel jobs.

Yah, except for that it should work fine.

What are my options if this is not possible. I thought I could use the SetUserStatus to store my variable to be used later in the Job Sequence Stream. I guess I am back to storing the values in a sequential file.

It IS possible. Just put a server job in your job sequence stream.

Is there a way to setup a server job with the PX version. We never had the server version. I checked the NEW program function and it only has the parallel job creation option.

OK, your site has not licensed server jobs. They have a server licence; they've just decided not to use it. So your next best approach is to use a parallel job that includes a BASIC Transformer stage, and invoke the routine from that. Make sure that the BASIC Transformer stage - indeed the whole job - executed in sequential mode in one processing node - whether using a node pool or a one-node configuration file to achieve this.

ray.wurlod wrote:OK, your site has not licensed server jobs. They have a server licence; they've just decided not to use it.

That's just crazy talk!

Perhaps, but I've seen it at three separate sites.

I checked our license structure and we do have the server version. If I install the server version, will it be a separate program icon or will it appear when I open up the NEW dialog box.

The latter.

There's nothing to install. All you have to do is license it. All the pieces are already in place.