using UniVerse and UniData

vijaykumar · Post by **vijaykumar** » Wed Feb 14, 2007 5:34 pm

Hi Gurus,
My Design is Hashfiles---->UniVerse Stage

while defining the universe(uni) datastage properties.Iam facing lot of problem.

Its asking for database connection name, user name and password.

I gave the dsn name, user name as scott and password as tiger, since iam connecting to oracle.

In details tab, iam specifying the directory path, iam specifying the path where hashfile is created.

iam getting error-invalid account name, the connection name defined is valid.
Plz gurus help me in analyzing the stage properties.

cheers;
vijay

I_Server_Whale · Post by **I_Server_Whale** » Wed Feb 14, 2007 5:38 pm

You cannot connect to Oracle using Universe Stage. UniVerse stage is for connecting to UniVerse tables.

DSguru2B · Post by **DSguru2B** » Wed Feb 14, 2007 5:59 pm

What are you trying to achieve here? As noted you cannot connect to Oracle using Universe Stage.

ray.wurlod · Post by **ray.wurlod** » Wed Feb 14, 2007 6:09 pm

UniVerse and UniData are database products, in the same way that Oracle, Sybase, Informix and DB2 are. You can gain more information here on the IBM website, since IBM has owned these two databases since 2001.

Saama · Post by **Saama** » Thu Feb 15, 2007 2:32 pm

Hi Gurus,

I can't find the universe stage in my repository, i can only find the UNIDATA STAGE, its says that its universe and Unidata stage, but when i double click the stage its says that it is Unidata stage, where can i find the Universe stage.
From the information which you gave gurus, i was able to know that UNIVERSE and UNIDATA are the separate databases.
But I created a hashfile and defined in the properties of hashfile as universe stage compatibility.
I want to access these hashfiles using universe stage.
Please help me where can I find the universe stage.

Cheers;
Vijay

ray.wurlod · Post by **ray.wurlod** » Thu Feb 15, 2007 2:38 pm

Look beside the UniData stage in the Palette; you will see a drop-down list. This list contains both UniData stage types and the UniVerse stage.

Alternately you can select the UniVerse stage from the Stage Types branch of the Repository.

Saama · Post by **Saama** » Thu Feb 15, 2007 2:54 pm

Hi Gurus,
You are helping me a lot, can we access the Hashfiles which are created in the universe by Unidata stage.

I know that we can retrieve by Universe stage, or is Unidata stage used only for Unidatabases.

cheers;
Vijay

narasimha · Post by **narasimha** » Thu Feb 15, 2007 4:47 pm

Universe and Unidata are two seperate products.
AFAIK you cannot read universe data from Unidata stage.
Is there any particular reason why you are going this way?

ray.wurlod · Post by **ray.wurlod** » Thu Feb 15, 2007 5:31 pm

Yes there is, but we'd better not go there.

The UniVerse stage can access data in DataStage hashed files, but only if a pointer to the hashed file exists in VOC. Search the forum for the SETFILE command for more information. In the UniVerse stage specify the pre-allocated DSN localuv.

Neither UniData stage can be used to access data in DataStage hashed files.

DSguru2B · Post by **DSguru2B** » Thu Feb 15, 2007 6:10 pm

So Ray ji, we can use UNIDATA to access hashed file

I saw two contradicting statements in your last post.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 15, 2007 6:15 pm

No you didn't.

ray wurlod wrote:Neither UniData stage can be used to access data in DataStage hashed files.

means that neither (of the two UniData stages) can be used to access data in DataStage hashed files.

Whilst I did not say so, the UniData stages do access hashed files - but these are UniData hashed files, which are - architecturally - radically different from DataStage hashed files.

So I stand by my statements and the precision of my language.

DSguru2B · Post by **DSguru2B** » Thu Feb 15, 2007 9:06 pm

ray.wurlod wrote:Yes there is, but we'd better not go there.

I was talking about those two statements

ray.wurlod wrote: Neither UniData stage can be used to access data in DataStage hashed files.

I thought that the first one was about UNIDATA. Anyways, must have been a minterpretation on my part.

ray.wurlod · Post by **ray.wurlod** » Fri Feb 16, 2007 12:11 am

The first was my answer to narasimha's immediately prior question.