DSXchange

Is this a multi-instance job with lots of instances? What is your purge setting for this job's log? How busy is the server system? All of those factors - and others - can slow down retrieval into Director log view.

It's OK, I spread the joy. I do harangue IBM about errors in their manuals. They claim to welcome the feedback. Sometimes the changes even make it into the next edition!

I told you precisely where to look in the Repository.

That you chose to look in a different location can not be my fault.

Since your subject mentions server routine, I might also direct your attention to the ReadBlk statement, that can read a file a byte at a time, if you are so inclined to do.

He/she was wrong. The correct form of words for the facilitator in these situations is "a future release" or even "a near future release". If you had a recording of this statement, you could successfully sue IBM for breach of promise. That's why the caveats and correct form of wo...

Can you copy the command from the log event and execute it in an operating system shell? If so, what is the result?

SQL State is only relevant if you are using ODBC protocols (that is, there is an ODBC stage or Dynamic RDBMS stage on the other end of the link). Not sure what's happening with DBMS code. This is 0 if no connection to the database server is made (for example, an ODBC driver will detect an error with...

Could you just look for ^ | / | ^ | F at the end of the record plus a condition that street type is non-empty?

What's your alternative that you believe not to be as complex as a sequence job?

(The terminology is "sequence" - a "sequencer" is something you use IN a sequence job.)

Where did you search in the Repository?

The BASIC Transformer stage should be able to be found at
\Stage Types\Parallel\Processing\BASIC Transformer

From what source did you "know" that vertical pivot would be in version 8.1 ?

Because it isn't, and was never planned to be.

It is planned for "a future release" (maybe even the next one), but every roadmap presentation from IBM includes a caveat that plans are not promises.

U is one of our posters, and did not pose this particular question.

The second person personal pronoun in English is spelled "you", not "u".

Mister Adams is right on it!

Probably, but what precisely do you mean by "distinct 1 value" and "distinct 2 value"? I am unfamiliar with these terms.

Look in the sequence's job log. Near the end is a "summary of sequence run".

You can interrogate this entry with API functions (such as DSGetNewestLogId, DSGetLogEvent) or with dsjob command equivalents.

SIGINT is you, issuing a stop command, which raises an interrupt signal.