DSXchange

"Cannot open DSR_JOBS" is, I believe, a mis-typing. There is no file of this name. It's either that the DSR_JOBS helper subroutine failed to be called correctly, or cannot open DS_JOBS. Without knowing which is the actual case I'm wary of commenting further.

As far as I am aware the maximum length of a Long VarChar in a Data Set is 128KB (the maximum length of a VarChar is 4KB, which answers Sanjay's question).

DS.REINDEX ALL is a good plan, but make very sure that you have exclusive access to the project. If necessary restart DataStage services first. You can always get to the project by telnet (or ssh), and nearly always from the Administrator client.

DataStage uses the user's operating system identity. That's where you would enforce password change.

You can not retrieve "JOHN" from the hashed file if "JOHN" is the key value unless you supply "JOHN" as the reference key expression. Assuming that you have some way to do this, such as SourceFile.NAME, then the 10 and 5 will be returned. You just use the other two input columns from the reference i...

Good, now you can change to and re-compile.

Generally a fast initial rate followed by degradation indicates that some kind of resource (buffer, for example) becomes full and then a slower process becomes involved (for instance transfer with handshaking rather than direct transfer). It might also mean that row processing has finished but the c...

No. No. You could monitor client connections by having a process continuously monitoring the DS_LICENSE file. You can monitor their activity by enabling server-side tracing, but this carries a severe performance penalty and warns folks connecting that tracing is enabled. Also, you would need to do a...

It seems - without knowing too much about Sybase - that Sybase is trying to create a (temporary?) table in the tempdb database to store the result of your query. And, apparently, such action is not permitted, either because you don't have appropriate privilege to that database, or because it's simpl...

Version 7.5x2 is an official release. However, being the first kid on the block (the first implementation of Orchestrate on Windows, and relying heavily on MKS Toolkit), I don't personally believe it's suitable for production. Maybe the Windows Hawk release will be less flaky.

It means the fifth parameter marker in the SQL. If this is Oracle SQL, the fifth parameter marker is :5 but, if this is ODBC SQL, the fifth parameter marker is ? (as are all the other parameter markers). Is the column in the Oracle table defined as VARCHAR2(50)? That is, does the metadata in your jo...

Yes I have. You are not helping. But thanks for the reply. No, I am trying to help. If you had never started it then you may always have had a zero length file. This is clearly not the case and so we can eliminate that possibility. It also means that your jobmoninit file has become empty in the mea...

There is a known bug in some of the 7.5 releases where the Palette only shows the Aggregator stage icon with a label of "0". This can not be expanded. If this occurs, the workaround is to drag stages from the Repository view, which seems to be unaffected.

Is there an index on the sorting column?

Because a B-tree is stored in sorted order, it can facilitate sorting in an unconstrained query, and in certain classes of constrained query.

Harry died in 1972