Universe tables with periods in their names

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Universe tables with periods in their names

Post by admin »

We are starting up a DataStage application where were going to import files from another machine running an application in UniVerse. So far, Ive been able to use the UniVerse stage within DataStage quite well in reading the files. Great!

Heres the rub. DataStages UniVerse stage does not like UniVerse tables or columns with periods in their name. Underscores are fine, but not a period. So, when I try to access the ACCOUNT.MASTER table and read ACCOUNT.NUMBER, ACCOUNT.NAME, I have to instead create a Q-pointer in the VOC called ACCOUNT_MASTER. I then have to create dictionary items in the ACCOUNT.MASTER table called ACCOUNT_NUMBER and ACCOUNT_NAME.

Something tells me there has to be an easier way. Any ideas?

Thanks. FYI, were still on the old DS 3.1.1r3 in NT. The UniVerse were reading from (via RPC) is in Unix.

Sincerely,
Brad Vincent
Data Warehousing with a "health"-y spin
Compuware
c/o The Detroit Medical Center
(313) 966-2176
Locked