WANTED - example of MFD for an Oracle database

[w860098]

We have a data warehouse system which uses the Cognos tools with an Oracle database. We also have WebFOCUS which is being used to process data held on our mainframe.

Before we consider purchasing the relevant WebFOCUS driver, I want to see an example of an MFD created from the Oracle catalog (using AUTOSQL ?).
Is it possible someone can provide me with a sample of the definitions that will be generated from an Oracle catalog.

The reason for this requirement is that I wish to develop suitable processing to edit those definitions to match the names used within the Cognos catalog. I would be happy to provide that solution to anyone else who has the same requirement.

 

[craigiep]

FILE=TTEST ,SUFFIX=SQLORA ,$
SEGNAME=TTEST , SEGTYPE=S0 ,$
FIELD=TSID ,TSID ,P19 ,P10 ,MISSING=OFF,$
FIELD=TSGCD ,TSGCD ,A3 ,A3 ,MISSING=OFF,$
FIELD=TDATE ,TDATE ,YYMD ,DATE ,MISSING=OFF,$
FIELD=TDATE1 ,TDATE ,HYYMDS ,HYYMDS ,MISSING=OFF,$

The TDATE / TDATE1 access the same column but in different formats.

Hope this helps