DSXchange

Server job questions (as posted) or parallel job questions (as marked)? The answers would vary depending on job type.

As a general rule we don't provide answers to interview questions, as we hold the belief that an interviewee should demonstrate his or her own merits, not someone else's.

Nodes are not relevant to DataStage server jobs.

Open Web Console for Information Server. Under Domain Management choose Licensing. What does that report show?

Not sure, but I'd take a punt that it was about March 2002. The product they acquired was called INTEGRITY, and came from a company called Vality.

They're always installed. What enables them is the licensing. I believe you've provided a "server only" licence file. The licence file is an XML document, so you can view it with any text editor.

That is, in the Job activity that invokes the inner sequence, to provide the value of the parameter using an expression containing that macro. It is true, as you identify, that you have to pass the invocation ID as a job parameter (as well as setting the inner sequence's invocation ID).

Use "grouped transaction" in an ODBC stage with multiple input links.

DELETE purges data from both parts. Space is made available against future re-use rather than being reclaimed, so it may appear (from the sizes) that OVER.30 is not being purged. If you ever need to reclaim the available space in a dynamic hashed file the appropriate commands are either CLEAR.FILE f...

No.

DataStage moves records by the buffer-full, but processes them in memory one at a time.

Maybe you don't (and shouldn't have?) INSERT privilege to this table?

In version 8.1 delimited files CAN be read using multiple readers per node, though it remains true that this is more efficient with fixed-width files.

You could even do that within one job. Just ignore the word "file" in what DSGuru2B suggested.

The name "sequential" stems from the fact that, when processing these files, you have to read past each byte to get to the next. Therefore you have to read the precise structure. You can reorder columns elsewhere in your job, for example using a Copy stage. (And even that doesn't necessari...

There's no AsInteger() function in server jobs. Please confirm your job type so we don't waste any more time.

The final byte may have been interpreted as the first byte of a truncated multi-byte character.