DSXchange

What kind of stage is the target stage? What exactly is it programmed to do (for example Write Mode)?

If it's a database connector, are there any warnings generated in the database?

Do you have an after-job subroutine in your job design? If so, what does it do?

Only where there are uncommitted transactions.

Probably not, because an ISD job is probably only performing one lookup; the performance difference will be minor.

When the job starts, whether from ISD or not, the conductor process constructs the score out of the generated OSH and the parallel execution configuration file. So, yes, jobs executed by ISD can run parallel. But you must ask yourself whether it's worth it. What's the usual payload of a web client's...

0 <> "NA"

Nor can "NA" ever be an integer value.

The DSODB database. Assuming, of course, you have set it up and configured the services associated with it, which is entirely optional.

And actually Ray, the first four are the pivot keys (bhasds: you can have more than one) while the last four are the pivoting columns. Otherwise as noted it's just a plain old horizontal Pivot. Save the transformer looping for something that actually requires it. :wink: :oops: Post edited appropria...

Welcome aboard.
What exact version are you using?
Have you executed the dsenv script first?

Welcome aboard. Simply adding a user to a group will cause that user to inherit any roles that have been assigned to the group.

The IsValid() function requires a data type as one of its arguments.

You don't have quotes around your delimiter characters in the construction expression - therefore they are being treated as negative zero.

The first four columns are the Pivot key, the other columns are the pivoting columns. Provided your data are correctly partitioned, that's all you need.

Use the "double convert" trick to remove all non-alphabetic characters from the string. This has been discussed many times on DSXchange. In your particular case (keep only alphabetic characters) the expression is: Convert(Convert("ABCDEFGHIJKLMNOPQRSTUVWXYZ", "", InLink...

peep wrote:Any suggestions?

Don't push.
Especially on weekends.

Are ANY rows processed?
Does the job ever achieve Running status?
Are there any errors or warnings in the job log?

Do you see a lock on this table when you invoke Cleanup Resources from the Director client? How about if you issue a LIST.READU command?