DSXchange

Yup, you need a direct grant, something your DBA should be able to confirm for you.

Hmmm... ok. What if you quote the comparison?

Not a conversion thing, I'd wager. What's in your AREA2 field? If either of those substrings return a null, all you'll end up with is a null after concatenation.

Just do the comparison. Server isn't picky about data types so no 'conversion' is necessary.

No problem, glad I could help.

What I do is use something like this to get all of the PIDs for the client connections and 'logout' any that I know are invalid. That generally means any that didn't connect that day.


Then DS.TOOLS option 4 then 9 from what I recall.

Only Client connections 'use' / require a license and are thus involved in the check. Jobs don't. Sounds like you've got some orphaned ones that need to be cleaned up.

There is one in each Project directory and it's a 'plain text' file. So, you can edit it with your UNIX text editor of choice.

Object directory? Is this perhaps a PX specific answer and not something that applies to Server jobs? I'll check closer when I get a chance.

Let us know if you need more help. If you've resolved your problem, mark the topic as Resolved and post your actual resolution to help future searchers.

Thanks!

Search the forums for 'jobmonapp', lots of discussions on this topic.

Lovely. veera24 - I neglected to finished the details in my original post. Open up the 3rd log entry, where the ENVironment is displayed, and the LD_LIBRARY_PATH will have the jobno as the first entry. Arnd, I looked for something in the logs that would denote the job number before I posted, in case...

ag_ram wrote:Correct chulett.

So... your question was some kind of a quiz? What the frak was the point of that?

If you knew the answer, just post it as a clarification. If you didn't, say "Thanks" and move on.

You'd need a routine to execute the UNIX 'cat' command and pass back the result. You would call it in the Initial Value field of the stage variable. Now, Server forum so Server answer. Someone else would have to note exactly how one would do this in a PX transformer.

Tutorial? Comes with the product.