DSXchange

As noted, you (in essence) insert the first record and update all subsequent records. And you do the 'update' by looking up the current value and appending/concatenating any new values to it before doing the destructive overwrite back to the hashed file.

On a lookup "miss" you put the value in the second field. For any subsequent lookup "hit" you append a comma and the new value to the existing value.

OK... you could have also used the proper viewer for log entries in the XMETA repository, which is done via the console from what I recall.

I would assume 8.5 as the older 8.x versions are not supposed to support an itag install. Good to know that it looks like they've finally added that ability back in.

Sorry but there's no such thing as an integer with a format. Once you add any kind of external format (like "99:99:99") then it becomes a string. As noted, compare them as such or remove the formatting and compare the integers.

This topic is already discussed so many times . but the scenario which i explain is little bit different. Sorry, don't see anything different about this, just a plain old ordinary vertical pivot. The fact that you want everything in one column instead of multiple columns is just a variation on that...

First make sure you don't have any kind of filter turned on.

rohitagarwal15 wrote:So you mean to say that if i need both versions on same server then probably first i have to uninstall the 7.5 version then first install 8.1 and then 7.5 version.

I'm unsure, hence the question mark in my statement. Ray probably knows, in the meantime you could always check with support.

Why not show us what you tried and what error(s) you received?

Yes, one is the XMETA database. The other is the legacy "Universe" repository that you suggested might need to be reindexed.

You might want to google for "ORA-03127", looks like it is an Oracle client / sqlnet issue where *it* rather than DataSTage may be doing something multi-threaded (which may line up with your "different section" thought) and failing in that attempt. From what I saw, upgrading your...

As far as I know, DataStage doesn't do anything magical with CLOBs so not really sure what "moves in a different section" might mean. Regardless, you've been asked for a solution using a tool that doesn't support CLOBs. Have you checked with your official support provider, passed along tha...

Not necessarily any more, 8.x stores that information in two places. Best to involve your official support provider, get their help to sync things back up again.

In the past, there was a pdf manual supplied on the subject of installing / supporting multiple server installations - is that no longer included? As noted, the 7.x version will need to be reconfigured (reinstalled?) with a different itag as 8.x can only use the default. I'm sure your official suppo...

He said "can mean" not "does mean". Is this an ongoing issue? Since you've chaged the status, what is your 'workaround' for this?