We have developed synonyms using the synonym builder in WebFOCUS 4.36. We upgraded to WebFOCUS 7.6.1 and used the same synonyms. We have 60 location files on the mainframe and we are able to access the first 50. When we attempt to access data in the last 10 location files we are presented with a message that says "there is no data available for the file". Any idea what we are doing wrong?

This message has been edited. Last edited by: Kerry,

What is different between the first 50 and the last 10? Is there a missing Data Provider definition? Multi-segment file?

- ABT

Thanks for the response.

There is nothing structurally different between the first 50 and the last 10. They are multi-segment files. I'm not sure what you mean by Data Provider definition. The files are native FOCUS files.

Are they also cross referenced ?

Can you post one of the masters ?

Is there a USE statement ?

Is the FOCUS file the specified in the MASTER ?

The masters are cross referenced. There are no USE's in the master file. The name of the FOCUS file is specified in the master. The following is the contents of the master file:

FILENAME=POLICY , SUFFIX=FOC, $

SEGNAME=COMPINFO , SEGTYPE=S1 , $
FIELD=COMPANY_CD , ALIAS=CMPY_NUMBER , USAGE=A5 , $

SEGNAME=POLNO1 , SEGTYPE=S1 , PARENT=COMPINFO, $
FIELD=POL_NO1 , ALIAS=PNO1 , USAGE=A3 , $
SEGNAME=POLNO2 , SEGTYPE=S1 , PARENT=POLNO1 , $
FIELD=POL_NO2 , ALIAS=PNO2 , USAGE=A3 , $
SEGNAME=POLNO3 , SEGTYPE=S1 , PARENT=POLNO2 , $
FIELD=POL_NO3 , ALIAS=PNO3 , USAGE=A4 , $

SEGNAME=POLINFO , SEGTYPE=S1 , PARENT=POLNO3 , $
FIELD=POLINFO_IND , ALIAS=POLF_IND , USAGE=A1 , $

FIELD=POL_MAIL , ALIAS=MAIL_KEY , USAGE=A15 , INDEX=I , $

FIELD=ROLLOVER , ALIAS=RO , USAGE=A1 , $

FIELD=POL_STATUS , ALIAS=PSTATUS , USAGE=A1 , $
FIELD=RATE_CANCEL , ALIAS=CANFLAG , USAGE=A1 , $
FIELD=RATE_FLAG , ALIAS=RATEFLAG , USAGE=A1 , $

FIELD=ORG_RUN_DT , ALIAS=ORUN_DT , USAGE=I8YYMD , $
FIELD=POL_RUN_DT , ALIAS=PRUN_DT , USAGE=I8YYMD , $

FIELD=TOP_END_EFF , ALIAS=TENDEFFDT , USAGE=I8YYMD , $
FIELD=TOP_NET_FYR , ALIAS=TNFYR , USAGE=I4 , $
FIELD=TOP_NET_FMN , ALIAS=TNFMN , USAGE=I2 , $

FIELD=ORG_NB_DT , ALIAS=ONB_DT , USAGE=I8YYMD , $
FIELD=CUR_POL_EFF , ALIAS=CUR_EFF , USAGE=I8YYMD , $

SEGNAME=POLADDR , SEGTYPE=U , PARENT=POLINFO , LOCATION=REQADRFL , $
FIELD=NAME , ALIAS=DESC_INFO , USAGE=A1 , $
FIELD=ADDRESS1 , ALIAS=ADDR1 , USAGE=A50 , $
FIELD=ADDRESS2 , ALIAS=ADDR2 , USAGE=A50 , $
FIELD=CITY , ALIAS=CITY , USAGE=A30 , $
FIELD=STATE , ALIAS=ST , USAGE=A2 , $
FIELD=ZIP1 , ALIAS=ZIP1 , USAGE=A5 , $
FIELD=ZIP2 , ALIAS=ZIP2 , USAGE=A4 , $
FIELD=BEG_ST_NUM , ALIAS=BEG_ST_NUM , USAGE=A10 , $
FIELD=ADDR_UPD_DT , ALIAS=ADDR_UPD , USAGE=I8YYMD , $
FIELD=GIS_LONGITUDE, ALIAS=GIS_LONG , USAGE=D12.6 , $
FIELD=GIS_LATITUDE , ALIAS=GIS_LAT , USAGE=D12.6 , $
FIELD=GIS_GEORESULT, ALIAS=GIS_GEORES , USAGE=A12 , $
FIELD=GIS_GEOCENSUS, ALIAS=GIS_GEOCENS , USAGE=A15 , $

SEGNAME=POLPARS , SEGTYPE=U , PARENT=POLINFO , LOCATION=REQPARFL , $
FIELD=HOUSE_NO , ALIAS=HOUSENO , USAGE=A10 , $
FIELD=ST_PREF_DIR , ALIAS=STPREFDIR , USAGE=A2 , $
FIELD=STREET_NAME , ALIAS=STNAME , USAGE=A40 , $
FIELD=STREET_SUF , ALIAS=STSUF , USAGE=A4 , $
FIELD=ST_SUF_DIR , ALIAS=STSUFDIR , USAGE=A2 , $
FIELD=APT_DESIG , ALIAS=APTDES , USAGE=A4 , $
FIELD=APT_NO , ALIAS=APTNO , USAGE=A8 , $
FIELD=HWY_TYPE , ALIAS=HWYTYP , USAGE=A2 , $
FIELD=HWY_NUM , ALIAS=HWYNUM , USAGE=A2 , $
FIELD=ADDRESS_KEY , ALIAS=ADDKEY , USAGE=A25 , $
FIELD=N_ZIP_CODE , ALIAS=NZIPCD , USAGE=A9 , $
FIELD=S_ADDRESS1 , ALIAS=SADDR1 , USAGE=A50 , $
FIELD=S_ADDRESS2 , ALIAS=SADDR2 , USAGE=A50 , $
FIELD=S_CITY , ALIAS=SCITY , USAGE=A30 , $
FIELD=S_STATE , ALIAS=SST , USAGE=A2 , $
FIELD=SADDRESS_KEY, ALIAS=SADDKEY , USAGE=A25 , $

SEGNAME=POLTERM , SEGTYPE=U , PARENT=POLINFO , $
FIELD=CAN_REASON , ALIAS=REASON , USAGE=A2 , $
FIELD=WYO_USE_CN , ALIAS=WYOCN , USAGE=A30 , $

FIELD=CANC_DT , ALIAS=CANDT , USAGE=I8YYMD , $
FIELD=CAN_ORG_RUN , ALIAS=CANORGRUN , USAGE=I8YYMD , $
FIELD=REIN_DT , ALIAS=REIDT , USAGE=I8YYMD , $

FIELD=TOT_REFUND , ALIAS=TREF , USAGE=D11.2 , $
FIELD=N_TOT_REFUND, ALIAS=CREF , USAGE=D11.2 , $

FIELD=FEE_REFUNDED, ALIAS=FEE_REFUNDED, USAGE=D7.2 , $
FIELD=N_REFUND_FPF, ALIAS=NREFFPF , USAGE=D7.2 , $

SEGNAME=REQUIRED , SEGTYPE=SH1, PARENT=POLINFO , $
FIELD=END_EFF_DT , ALIAS=E_EFF_DT , USAGE=I8YYMD , $

SEGNAME=INFRATE , SEGTYPE=S1 , PARENT=REQUIRED , LOCATION=INFRTEFL , $
FIELD=INFRATE_IND , ALIAS=INFRTEIND , USAGE=A1 , $

FIELD=RATE_METHOD , ALIAS=RMETHOD , USAGE=A1 , $

FIELD=COMM_ID , ALIAS=COMM_NO , USAGE=A6 , INDEX=I , $
FIELD=PANEL_SUFFIX, ALIAS=PANELSUFX , USAGE=A5 , $

DEFINE COMMUNITY/A11 = COMM_ID||PANEL_SUFFIX; $

FIELD=PROGRAM , ALIAS=PROG , USAGE=A1 , $
FIELD=FLOOD_ZONE , ALIAS=ZONE , USAGE=A3 , $
FIELD=OCCUPANCY , ALIAS=OCCUP , USAGE=A1 , $
FIELD=BUILDING , ALIAS=BUILD , USAGE=A1 , $
FIELD=BASEMENT , ALIAS=BASE , USAGE=A1 , $
FIELD=SMALL_BUS , ALIAS=SM_BUS , USAGE=A1 , $
FIELD=CONDO , ALIAS=CONDO , USAGE=A1 , $
FIELD=STATE_OWN , ALIAS=S_OWN , USAGE=A1 , $
FIELD=CRSE_CONST , ALIAS=IN_COURSE , USAGE=A1 , $
FIELD=ELEV_BLDG , ALIAS=ELEV_BLD , USAGE=A1 , $
FIELD=OBSTRUCTION , ALIAS=OBST_TYPE , USAGE=A2 , $
FIELD=LOC_CONT , ALIAS=LCONT , USAGE=A1 , $
FIELD=FLOOD_PROOF , ALIAS=FLD_PROOF , USAGE=A1 , $
FIELD=POST_FIRM , ALIAS=POSTFIRM , USAGE=A1 , $

FIELD=DED_BLD_IND , ALIAS=DED_BLD , USAGE=A1 , $
FIELD=DED_CNT_IND , ALIAS=DED_CONT , USAGE=A1 , $

FIELD=INS_VAL_IND , ALIAS=INSVALIND , USAGE=A1 , $
FIELD=PREM_PAY_IND , ALIAS=PRMPAYIND , USAGE=A1 , $
FIELD=ELEV_CERT , ALIAS=ECERT , USAGE=A1 , $
FIELD=POST_V_CERT , ALIAS=POSTV , USAGE=A1 , $

FIELD=W_POL_TERM , ALIAS=WTERM , USAGE=A1 , $
FIELD=RLTRGTGP_IND, ALIAS=RLTRGT , USAGE=A1 , $
FIELD=DIAGRAM_NO , ALIAS=DIAGNO , USAGE=A1 , $

FIELD=PRP_INELIG , ALIAS=PRPIND , USAGE=A1 , $

FIELD=POL_EFF_DT , ALIAS=EFF_DT , USAGE=I8YYMD , $
FIELD=POL_EXP_DT , ALIAS=EXP_DT , USAGE=I8YYMD , $

FIELD=ORIG_CONST , ALIAS=OCONST , USAGE=I8YYMD , $
FIELD=ELEV_CERT_DT, ALIAS=ECERTDT , USAGE=I8YYMD , $

FIELD=ELEV_DIFF , ALIAS=ELEVDIFF , USAGE=I5 , $

FIELD=CONDO_UNITS , ALIAS=C_UNITS , USAGE=I3 , $

FIELD=T_COV_BLDG , ALIAS=TCOV_B , USAGE=I8 , $
FIELD=T_COV_CONT , ALIAS=TCOV_C , USAGE=I5 , $

FIELD=TOT_PREMIUM , ALIAS=TPREMIUM , USAGE=I8 , $
FIELD=END_PREMIUM , ALIAS=EPREMIUM , USAGE=I8 , $

FIELD=POLICY_FEE , ALIAS=FED_POL_FEE , USAGE=I3 , $

FIELD=CRS_CLASS , ALIAS=CRS_CREDIT , USAGE=I2 , $

FIELD=T_POLICY_FEE, ALIAS=T_POL_FEE , USAGE=I3 , $

FIELD=LOW_FLOOR , ALIAS=LFE , USAGE=F8.1 , $
FIELD=BASE_FLOOD , ALIAS=BFE , USAGE=F8.1 , $
FIELD=LOWADJ_GRADE, ALIAS=LAG , USAGE=F8.1 , $

FIELD=W_BLDG_RATEB, ALIAS=WBRATEB , USAGE=F6.3 , $
FIELD=W_BLDG_RATEA, ALIAS=WBRATEA , USAGE=F6.3 , $
FIELD=W_CONT_RATEB, ALIAS=WCRATEB , USAGE=F6.3 , $
FIELD=W_CONT_RATEA, ALIAS=WCRATEA , USAGE=F6.3 , $
FIELD=W_PREM_ICC, ALIAS=WPREMI , USAGE=I7 , $
FIELD=W_COMM_PROB, ALIAS=WCOMMPROB , USAGE=I3 , $
FIELD=W_DEDDIS_PCT, ALIAS=WDEDDISCP , USAGE=F5.3 , $
FIELD=RL_ID_NUMBER, ALIAS=PROP_LOCATOR, USAGE=I7 , $

DEFINE T_PREMIUM/I8 = TOT_PREMIUM + T_POLICY_FEE;$

FIELD=BLDCONST_DTYP, ALIAS=BCONSDT_TYPE, USAGE=A1 , $
FIELD=BLD_WATER_TYP, ALIAS=BWATER_TYPE , USAGE=A1 , $
FIELD=CONDO_OWN_IND, ALIAS=CND_OWN_IND , USAGE=A1 , $
FIELD=BLDG_USE_TYPE, ALIAS=BLD_USE_TYPE, USAGE=A2 , $
FIELD=GRNDFATHER_CD, ALIAS=GRNDFATHERCD, USAGE=A1 , $
FIELD=CMI_COMM_ID , ALIAS=CMI_COMMID , USAGE=A6 , $
FIELD=CMI_MAP_PANEL, ALIAS=CMI_MAP_PANL, USAGE=A4 , $
FIELD=CMI_MAP_SUFFX, ALIAS=CMI_MAP_SFX , USAGE=A1 , $
FIELD=CMI_FLOOD_ZNE, ALIAS=CMI_FLOODZNE, USAGE=A3 , $
FIELD=CMI_BASEFLOOD, ALIAS=CMI_BFE , USAGE=F8.1 , $
FIELD=CMI_PRIORPOL , ALIAS=CMI_PRIORPOL, USAGE=A10 , $

SEGNAME=WYORATE , SEGTYPE=U , PARENT=INFRATE , LOCATION=WYORTEFL , $
FIELD=RATEKEY , ALIAS=RATEKEY , USAGE=A16 , $

FIELD=N_POL_TERM , ALIAS=NTERM , USAGE=A1 , $

FIELD=COMM_PROB_I , ALIAS=COMMPROBIND , USAGE=A1 , $

FIELD=TRANS_CD , ALIAS=TXN_CD , USAGE=A2 , $
FIELD=TRANS_DT , ALIAS=TXN_DT , USAGE=I8YYMD , $

FIELD=LST_RUN_DT , ALIAS=RUN_DT , USAGE=I8YYMD , $
FIELD=CORR_TXN_DT , ALIAS=CORR_DT , USAGE=I8YYMD , $
FIELD=END_TXN_DT , ALIAS=END_DT , USAGE=I8YYMD , $

FIELD=N_EXP_CST , ALIAS=NEXP , USAGE=I3 , $

FIELD=COMM_PROB , ALIAS=COMMPROB , USAGE=I3 , $

FIELD=N_BAS_COV_B , ALIAS=NBCOVB , USAGE=I8 , $
FIELD=N_ADD_COV_B , ALIAS=NACOVB , USAGE=I8 , $

FIELD=N_BAS_COV_C , ALIAS=NBCOVC , USAGE=I5 , $
FIELD=N_ADD_COV_C , ALIAS=NACOVC , USAGE=I5 , $

FIELD=N_BAS_PREM_B, ALIAS=NBPREMB , USAGE=I7 , $
FIELD=N_ADD_PREM_B, ALIAS=NAPREMB , USAGE=I7 , $
FIELD=N_BAS_PREM_C, ALIAS=NBPREMC , USAGE=I6 , $
FIELD=N_ADD_PREM_C, ALIAS=NAPREMC , USAGE=I6 , $

FIELD=N_POL_SERV , ALIAS=N_FP_FEE , USAGE=I3 , $

FIELD=N_CRS_CLASS , ALIAS=NCRSCLASS , USAGE=I2 , $

FIELD=N_DEDDIS_PCT, ALIAS=NDEDDISCP , USAGE=F5.3 , $
FIELD=N_DEDDIS_AMT, ALIAS=NDEDDISCA , USAGE=I9 , $
FIELD=REPLACEMENT , ALIAS=RCOST , USAGE=D10 , $
FIELD=W_EXP_CST , ALIAS=WEXP , USAGE=I3 , $

FIELD=N_PREM_ICC , ALIAS=NPREMI , USAGE=I7 , $
FIELD=N_COV_ICC , ALIAS=NCOVI , USAGE=I5 , $

SEGNAME=REQNAME , SEGTYPE=S1 , PARENT=INFRATE , LOCATION=REQNMEFL , $
FIELD=REQNAME_IND , ALIAS=REQNAMEIND , USAGE=A1 , $

FIELD=DA_CASE_NUM , ALIAS=DA_CASE_NUM , USAGE=A9 , $
FIELD=NAME_FORMAT , ALIAS=NAMEFORM , USAGE=A1 , $
FIELD=LAST_NAME , ALIAS=L_NAME , USAGE=A25 , $
FIELD=FIRST_NAME , ALIAS=F_NAME , USAGE=A25 , $
FIELD=WYO_USE_RQ , ALIAS=WYORQ , USAGE=A30 , $
FIELD=DIS_ASST , ALIAS=DIS_ASST , USAGE=A1 , $
FIELD=PRINCIPAL , ALIAS=P_RESID , USAGE=A1 , $

SEGNAME=REQKEY , SEGTYPE=S1 , PARENT=REQNAME , LOCATION=REQKEYFL , $
FIELD=POL_CLM_KEY , ALIAS=CLM_POL_KEY , USAGE=A23 , INDEX=I , $

SEGNAME=POL_ERR , SEGTYPE=S1 , PARENT=REQNAME , LOCATION=POLERRFL , $
FIELD=POL_ERROR_CD, ALIAS=ERROR_CODE , USAGE=A8 , $
FIELD=POL_ERROR_DT, ALIAS=PERR_DT , USAGE=I8YYMD , $
FIELD=POL_FILECK , ALIAS=PFILECK , USAGE=I8YYMD , $

SEGNAME=NETPREM , SEGTYPE=SH2, PARENT=POLINFO, LOCATION=NETPRMFL , $
FIELD=NFISCAL_YR , ALIAS=NFYR , USAGE=I4 , $
FIELD=NFISCAL_MN , ALIAS=NFMN , USAGE=I2 , $

FIELD=W_NET_PREM , ALIAS=WNPREM , USAGE=D11.2 , $
FIELD=W_WRT_PREM , ALIAS=WWPREM , USAGE=D11.2 , $
FIELD=W_RET_PREM , ALIAS=WRPREM , USAGE=D11.2 , $
FIELD=W_REF_PREM , ALIAS=WFPREM , USAGE=D11.2 , $

FIELD=W_NET_FPF , ALIAS=WNETFPF , USAGE=D7.2 , $
FIELD=W_WRT_FPF , ALIAS=WWRTFPF , USAGE=D7.2 , $
FIELD=W_RET_FPF , ALIAS=WRETFPF , USAGE=D7.2 , $
FIELD=W_REF_FPF , ALIAS=WREFFPF , USAGE=D7.2 , $

SEGNAME=COMPANY , SEGTYPE=KU , PARENT=COMPINFO,
CRFILE=COMPANY , CRKEY=CMPY_NUMBER , $

SEGNAME=COMPINFO , SEGTYPE=KLU , PARENT=COMPANY ,
CRFILE=COMPANY , $

SEGNAME=EXPENSE , SEGTYPE=KL , PARENT=COMPANY ,
CRFILE=COMPANY , $

SEGNAME=COMMSEG , SEGTYPE=KU , PARENT=INFRATE ,
CRFILE=COMMASTR , CRKEY=COMM_ID , $

SEGNAME=COMNOSEG , SEGTYPE=KLU, PARENT=COMMSEG ,
CRFILE=COMMASTR , $

SEGNAME=COMMINF , SEGTYPE=KLU, PARENT=COMNOSEG ,
CRFILE=COMMASTR , $

SEGNAME=CNTYWSEG , SEGTYPE=KLU, PARENT=COMNOSEG,
CRFILE=COMMASTR , $

SEGNAME=SUSPSEG , SEGTYPE=KL , PARENT=COMNOSEG ,
CRFILE=COMMASTR , $

SEGNAME=FHBMSEG , SEGTYPE=KLU, PARENT=COMNOSEG ,
CRFILE=COMMASTR , $

SEGNAME=REGSEG , SEGTYPE=KLU, PARENT=COMNOSEG ,
CRFILE=COMMASTR , $

SEGNAME=COUNTY , SEGTYPE=KL , PARENT=COMNOSEG ,
CRFILE=COMMASTR , $

SEGNAME=CONGRESS , SEGTYPE=KL , PARENT=COMNOSEG ,
CRFILE=COMMASTR , $

SEGNAME=PROBSEG , SEGTYPE=KL , PARENT=COMNOSEG ,
CRFILE=COMMASTR , $

SEGNAME=CRSTR , SEGTYPE=KL , PARENT=COMNOSEG ,
CRFILE=COMMASTR , $

SEGNAME=MAPSEG , SEGTYPE=KL , PARENT=COMNOSEG ,
CRFILE=COMMASTR , $

SEGNAME=AUTHZONE , SEGTYPE=KL , PARENT=MAPSEG ,
CRFILE=COMMASTR , $

SEGNAME=ALTERKEY , SEGTYPE=KL , PARENT=COMNOSEG ,
CRFILE=COMMASTR , $

SEGNAME=RATESEG , SEGTYPE=KU , PARENT=WYORATE ,
CRFILE=RATES , CRKEY=RATEKEY , $

SEGNAME=CLAIM , SEGTYPE=KM , PARENT=REQKEY,
CRFILE=CLAIMS , CRKEY=CLM_POL_KEY , $

SEGNAME=CLM_OPT , SEGTYPE=KLU, PARENT=CLAIM,
CRFILE=CLAIMS , $

SEGNAME=CLM_ERR , SEGTYPE=KL , PARENT=CLAIM,
CRFILE=CLAIMS , $

SEGNAME=MONTH , SEGTYPE=KL , PARENT=CLAIM,
CRFILE=CLAIMS , $

SEGNAME=PAYMENT , SEGTYPE=KL , PARENT=MONTH,
CRFILE=CLAIMS , $

SEGNAME=RESERVE , SEGTYPE=KL , PARENT=MONTH,
CRFILE=CLAIMS , $

SEGNAME=SPECLAE , SEGTYPE=KL , PARENT=MONTH,
CRFILE=CLAIMS , $

SEGNAME=RECOVERY , SEGTYPE=KL , PARENT=MONTH,
CRFILE=CLAIMS , $

SEGNAME=EDITS , SEGTYPE=KU , PARENT=POL_ERR ,
CRFILE=EDITS , CRKEY=ERROR_CODE, $

SEGNAME=MAILINFO , SEGTYPE=KU , PARENT=POLINFO ,
CRFILE=MAILADDR , CRKEY=MAIL_KEY , $

SEGNAME=MAILADD , SEGTYPE=KLU, PARENT=MAILINFO ,
CRFILE=MAILADDR , $

SEGNAME=MAILREQ , SEGTYPE=KL , PARENT=MAILINFO ,
CRFILE=MAILADDR , $

SEGNAME=MAILERR , SEGTYPE=KL , PARENT=MAILREQ ,
CRFILE=MAILADDR , $

SEGNAME=CLMHIST , SEGTYPE=KL , PARENT=MAILREQ ,
CRFILE=MAILADDR , $

I wonder if this is due to "Code Tightening", 4.3.6 to 7.6.1 is a long jump.

I've noticed that some of your cross referenced segments do not have a CRKEY, this may be the cause.

Also have you verified that each CRKEY does match the cross reference master.

I've TABLED the file on the mainframe using mainframe FOCUS and it worked fine using the MFD that I posted last time. I guess I need to figure out why it doesn't work in WebFOCUS. Thanks for your help.

I've just noticed that you are on WebFOCUS 5.1, what version of Mainframe FOCUS are you on ?.