DSXchange

(Please wrap your design in Code tags.)

I don't see any way you are testing the output of Change Capture to limit inserts and updates to detected new/changed records.

Surely to read them all you need to do is name them in a SELECT statement, whether generated or user-defined?

Use a connection that doesn't drop out.

Involve your network administrator and Sybase DBA to gather information about why this error occurred in the first place. It is not a DataStage error.

I don't believe it's possible. DataStage NLS only recognizes one administrator user at a time, set by the current impersonation mode. This is the user who can start DataStage server. (It's different on Windows, but isn't everything?)

Capture both stdout and stderr.

sinhasaurabh014 wrote:where can i find the codes for folders as used in the KEY field of DS_AUDIT?
for eg. for jobs its is 2
for routines its 7..etc.

Ever considered a Search of DSXchange? Hint: KEY is a composite column; the individual key columns are called CLASS and INSTANCE.

They are not obfuscated. IBM has not published an entity-relationship diagram, and no-one of whom I am aware has developed one either.

Therefore a licence for every Cognos user who wants to access the technology?

You have not provided enough information (not have you asked a question). What is your job design and, in particular, what are you doing with, and with the results of, the change detection stage that you are using (and, for that matter, which stage type is it)?

The first is due to your not specifying, in the Sequential File stage, the value with which null is to be represented. Either do so, or make the column not nullable. In particular the first has nothing whatsoever to do with the Modify stage. The second is from the Row Generator stage. Where does dec...

The limit is governed by the largest address (offest) within a file that can be addressed by a signed 32-bit integer. Hashed files use 32-bit pointers internally to link the records in each group. The RESIZE command can, among other things, change the size of those pointers to 64-bit. The largest ad...

Hi, Please send me the exact syntax. thanks, Tanisha I provided a precise manual reference. Why can't you look it up there? I would be perfectly happy to read the manual for you, but only as a commercial arrangement. If you wish to proceed on this basis please revert with a purchase order or reques...

Hi, Please send me the exact syntax. thanks, Tanisha I provided a precise manual reference. Why can you look it up there? I would be perfectly happy to read the manual for you, but only as a commercial arrangement. If you wish to proceed on this basis please revert with a purchase order or request ...

Probably a syntax error message. But Arnd did say he was not in a position to check the syntax.

Please post the complete error message, and indicate what stage type is indicated by any stage mentioned in it.