Hello,

I am using DS 5.2 connecting to Oracle Database. I have created synonyms from existing tables/views on the database. In addition, i created some views with Developer Studio. How can I reflect the new views created within DS to show up on teh database. Right now, if I try to run the report it gives a "No HTML Output" saying "The description cannot be found for file named: RLDETAILSVIEW." RLDETAILSVIEW is the view I created in Developer Studio using synonyms from tables on the Oracle database.

Any help would be much appreciated.

Thank you.

Kinkini.

Could you post the mas and acx you created in Dev Studio?

Hello,

Thanks for the response.

RLDETAILSVIEW.acx code is:

SEGNAME=RL_REGIONS,
TABLENAME=SFR.RL_REGIONS,
KEYS=1,
CONNECTION=nextgen1,$
SEGNAME=RL_CONTACTS,
KEYFLD=REGION_ID,
TABLENAME=SFR.RL_CONTACTS,
KEYS=1,
IXFLD=REGION_ID,
CONNECTION=nextgen1,$
SEGNAME=RL_TITLES,
KEYFLD=TITLE_ID,
TABLENAME=SFR.RL_TITLES,
KEYS=1,
IXFLD=TITLE_ID,
CONNECTION=nextgen1,$
SEGNAME=RL_ADDRESS_INDEX,
KEYFLD=CONTACT_ID,
TABLENAME=SFR.RL_ADDRESS_INDEX,
KEYS=2,
IXFLD=CONTACT_ID,
CONNECTION=nextgen1,$
SEGNAME=RL_ADDRESSES,
KEYFLD=ADDRESS_ID,
TABLENAME=SFR.RL_ADDRESSES,
KEYS=1,
IXFLD=ADDRESS_ID,
CONNECTION=

--------------------------------------
RLDETAILSVIEW.mas is:

FILE=rldetailsview, SUFFIX=SQLORA
SEGNAME=RL_REGIONS, SEGTYPE=S0, $
FIELD=REGION_ID, ALIAS=REGION_ID, USAGE=A10, ACTUAL=A10, $
FIELD=REGION_DESCRIPTION, ALIAS=REGION_DESCRIPTION, USAGE=A50, ACTUAL=A50,
MISSING=ON, $
SEGNAME=RL_CONTACTS, SEGTYPE=S0, PARENT=RL_REGIONS, $
FIELD=CONTACT_ID, ALIAS=CONTACT_ID, USAGE=P11, ACTUAL=P6, $
FIELD=TITLE_ID, ALIAS=TITLE_ID, USAGE=I11, ACTUAL=I4, MISSING=ON, $
FIELD=SALUTATION, ALIAS=SALUTATION, USAGE=A10, ACTUAL=A10, MISSING=ON, $
FIELD=LAST_NAME, ALIAS=LAST_NAME, USAGE=A50, ACTUAL=A50, MISSING=ON, $
FIELD=FIRST_NAME, ALIAS=FIRST_NAME, USAGE=A50, ACTUAL=A50, MISSING=ON, $
FIELD=PHONE_NUMBER, ALIAS=PHONE_NUMBER, USAGE=A20, ACTUAL=A20, MISSING=ON, $
FIELD=FAX_NUMBER, ALIAS=FAX_NUMBER, USAGE=A20, ACTUAL=A20, MISSING=ON, $
FIELD=NAME_FORMAT_INDICATOR, ALIAS=NAME_FORMAT_INDICATOR, USAGE=A1,
ACTUAL=A1, MISSING=ON, $
FIELD=NG_LOGIN_NAME, ALIAS=NG_LOGIN_NAME, USAGE=A30, ACTUAL=A30,
MISSING=ON, $
FIELD=E_MAIL, ALIAS=E_MAIL, USAGE=A50, ACTUAL=A50, MISSING=ON, $
FIELD=REGION_ID, ALIAS=REGION_ID, USAGE=A10, ACTUAL=A10, MISSING=ON, $
SEGNAME=RL_TITLES, SEGTYPE=S0, PARENT=RL_CONTACTS, $
FIELD=TITLE_ID, ALIAS=TITLE_ID, USAGE=I11, ACTUAL=I4, $
FIELD=TITLE_DESCRIPTION, ALIAS=TITLE_DESCRIPTION, USAGE=A50, ACTUAL=A50,
MISSING=ON, $
SEGNAME=RL_ADDRESS_INDEX, SEGTYPE=S0, PARENT=RL_CONTACTS, $
FIELD=ADDRESS_ID, ALIAS=ADDRESS_ID, USAGE=P11, ACTUAL=P6, $
FIELD=CONTACT_ID, ALIAS=CONTACT_ID, USAGE=P11, ACTUAL=P6, $
SEGNAME=RL_ADDRESSES, SEGTYPE=S0, PARENT=RL_ADDRESS_INDEX, $
FIELD=ADDRESS_ID, ALIAS=ADDRESS_ID, USAGE=P11, ACTUAL=P6, $
FIELD=ADDRESS1, ALIAS=ADDRESS1, USAGE=A50, ACTUAL=A50, MISSING=ON, $
FIELD=ADDRESS2, ALIAS=ADDRESS2, USAGE=A50, ACTUAL=A50, MISSING=ON, $
FIELD=CITY, ALIAS=CITY, USAGE=A30, ACTUAL=A30, MISSING=ON, $
FIELD=ZIP_CODE, ALIAS=ZIP_CODE, USAGE=A10, ACTUAL=A10, MISSING=ON, $
FIELD=STATE_CODE, ALIAS=STATE_CODE, USAGE=A2, ACTUAL=A2, $
FIELD=COMMUNITY_ID, ALIAS=COMMUNITY_ID, USAGE=P7, ACTUAL=P8, MISSING=ON, $
FIELD=PERIOD_BEGIN_DATE, ALIAS=PERIOD_BEGIN_DATE, USAGE=HYYMDS,
ACTUAL=HYYMDS, $
FIELD=PERIOD_END_DATE, ALIAS=PERIOD_END_DATE, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
END

Is that what you asked for?

Thank you.

Kinkini.

It looks like what you have created is a cluster join. WebFOCUS does not views, databases do. What WebFOCUS has are synonyms (metadata) that point to tables and/or views. A cluster join is a single synonym that joins multiple tables or views in the database. The error you are getting is not really an error. It just means 0 rows have been returned from your request. It probably has nothing to do with data access. If you have any WHERE tests, try taking them out. If you have no WHERE tests, it could be a short path issue. That is the parent file exists without matching joined-to records. Try SET ALL=ON at the top of your procedure. Or, try to PRINT just fields from 1 or 2 tables at a time.

Are the mas and acx files in folders on the APP PATH?

The mas and acx files are on APP PATH

Thank you.

Kinkini.

The message seems to be stating that it can not find RLDETAILSVIEW.mas. If you do
CHECK FILE RLDETAILSVIEW
what do you get?

Hello,

Thanks N.Selph, WFUser. As both of you indicated, it was unable to find rldetailsview. I had to check it into the environment I was working in. It seems to connect now. I appreciate you guys pointing me in the right drection. You saved me a bunch of time.

Regards and good wishes for the new year!!

Kinkini.