DSXchange

My guess is that you already have an output link from the Pivot stage (look carefully for any red color) which is why Designer will not let you draw a second output link from this stage.

Does not the manual state that OCCURS DEPENDING ON is not supported in versions 7.5 and earlier?

This is a misleading comment from you. Why 2 months? Where did you pull that number from?

You can ask your DBA about the database error/reason codes.

SQLState is a general ODBC error code; you can search for these on Google, MSDN and lots of other places.

If your system generates "unknown network error" how the heck would we be supposed to know?!!!

The "null" error can occur even if your metadata specifies nullable, and will definitely occur if there is any null in, or generated in, the data. Don't assert, check.

Is saying extracting from a cluster equivalent to saying extracting from a server Or do they both mean differently. Different. A cluster involves more than one machine. Therefore there are architectural differences. Philosophically one could argue that a cluster of one machine is a possibility, but...

It takes the same connection resources to check whether there are any rows as to process zero rows. There is no gain.

If the job is being monitored, if the job is being edited, if the job is running; you do not want to unlock anything. The locks are there for a reason.

Not if the lock is owned by an abnormally disconnected process. That's when you need the UNLOCK command on the server.

You did.

Who knows?

You didn't show is the BuildOp code.

Further, what proof do you have that the problem is in the BuildOp? You may have filled some structure, such as tablespace, in the database.

Create a job to insert the row. Pass the four values as job parameters. Generate one row.

Pass the parameters to the job from the batch, obtaining the values as described above.

Why bother? The job will work fine even if there are no rows in the table. It will process zero rows.

1. There is no such thing as a DS Scheduler. When you use Schedule view from Director, the command executed on the server is AT. 2. Full syntax for dsjob is in both the Server Job Developer's Guide and the Parallel Job Advanced Developer's Guide so I don't understand why you can't find it. Look for ...