Universe Query -

chulett · Post by **chulett** » Wed Apr 01, 2009 3:39 pm

sarjushah wrote:Let me search the forum but if you have it handy please pass it on.

It, what "it"? The link to Ken's post I already provided to you?

sarjushah · Post by **sarjushah** » Thu Apr 02, 2009 8:43 am

chulett wrote:
sarjushah wrote:Let me search the forum but if you have it handy please pass it on.
It, what "it"? The link to Ken's post I already provided to you?

take it eazy

sarjushah · Post by **sarjushah** » Thu Apr 02, 2009 11:36 am

chulett wrote:No, you can't - and I was wondering if that was why the question was being asked. Note that you use the UV stage, not the Universe stage, over the hashed file for this. ...

I just tried and I am able to access the hash file using a ODBC stage.

Using localuv and same VOC entry that I had created for using it with the uv stage.

Thanks
Sarju Shah

chulett · Post by **chulett** » Thu Apr 02, 2009 2:08 pm

Interesting... I guess there must be branded ODBC "Universe" drivers out there. I don't have any kind of DataStage access at the moment, so couldn't check what you might be using in the stage for this.

Now I'm curious, does that fact help you at all? Solve your problem?

sarjushah · Post by **sarjushah** » Thu Apr 02, 2009 2:20 pm

chulett wrote:Interesting... I guess there must be branded ODBC "Universe" drivers out there. I don't have any kind of DataStage access at the moment, so couldn't check what you might be using in the stage for this.

Now I'm curious, does that fact help you at all? Solve your problem?

No it doesnt.. but adds to my adds to my ds knowledge.

chulett · Post by **chulett** » Thu Apr 02, 2009 2:26 pm

Fair enough... mine, too.

ray.wurlod · Post by **ray.wurlod** » Thu Apr 02, 2009 3:21 pm

All calls through the UV and ODBC stages use BCI functions under the covers. The uvodbc.config file tells whether it is a UniVerse or an ODBC data source - in the former case it is not necessary to use an ODBC driver because the process is already connected to the "UniVerse" database. Only if the DBMSTYPE setting is "ODBC" will a driver be used.

chulett · Post by **chulett** » Thu Apr 02, 2009 7:05 pm

I see... gotcha. Should have realized that.

sarjushah · Post by **sarjushah** » Thu Apr 02, 2009 8:34 pm

After posting this topic and the quick response I felt the premium was worth it.. So I am in. Paid my dues now waiting for my access to be granted .