DSXchange

Welcome... and yes, it is certainly possible. You can use the ellipsis (...) to pick it from a list of those defined in the job or just type it in yourself. This is one of the few places where you do not enclose them in pound/hash signs, however.

Where in your code are you telling it to append? Search the forum for the proper usage of the SEEK command.

The list_readu should show you similar information. You'll see entries for each connection with a long string of "-" separated numbers. Near the end is the machine name, a colon and the pid of that connection. Each unique machine name should count as one license in use.

Here's a thought... why not set the uvconfig values that you changed back to whatever they used to be when the server would actually start?

Row/warn limit of what exactly? There really isn't one before a job starts running, other than the default. Are you saying that first thing, you want to check once to see what the limit is the Sequence job is using, the limit it will be passing to all child jobs? There's probably a DSGet* routine ou...

When you say that "no one can open a new session", what exactly does that mean? Do you get an error, does it tell you your license limit is at its max, something else? There's no simple way to get a list of all licenses in use. The 'session' question can be answered by searching the forum for the us...

Your environment isnt' setup properly for this script's session. Make sure it 'sources' the dsenv file before you run the dsjob command.

It says it couldn't find "/dsjob". To me that would imply that your DSBINDIR variable wasn't set.

Place your shell script anywhere you like - and then provide a full path to it.

That's what I was afraid of, it means you haven't understood what the reject link is capturing. This was discussed in previous replies - an update statement that updates zero rows does not reject, it simply updates zero rows. The only time data will go down your Reject link is if your DML statement ...

You need to say what's "not working" about it. What is it not doing that you are expecting? What is it doing that you are not expecting? You need to give details or we'll just keep chasing our tails here.

Ok... it would have helped if you had actually said that rather than just repeating the original question. Try not using a constraint on the Reject link. Simply leave the constraint blank and check the 'Reject Row' box for it. Make sure it comes last in line when checking the link execution order. S...

I'm sorry, but your question has been asked and answered more than once already in this thread. Asking it yet again won't get you a better answer.

Do you have a sample of the desired output? If not, generate one, and then import the metadata for it. Use that to drive the XPath expressions you use in the Output stage.

I don't use the stage, but have you tried it with the parameter name enclosed in the standard pound/hash signs?

Procedure call syntax "BEGIN test(#TableName#); END;"

As long as TableName is a job parameter, that is.

Ah... octal... gotcha. Thought it was just boo-boo.