Hi,

Iam getting this Error-
======================================================
0 ERROR AT OR NEAR LINE 31 IN PROCEDURE new_airdte
(FOC370) THE FIELDNAME USED IN JOIN CANNOT BE FOUND IN THE FILE:
J15.TV_AIR_TM_CD
0 ERROR AT OR NEAR LINE 34 IN PROCEDURE new_airdte
(FOC370) THE FIELDNAME USED IN JOIN CANNOT BE FOUND IN THE FILE:
J15.TV_AIR_TM_CD
BYPASSING TO END OF COMMAND
======================================================
and my code is-
=====================================================
JOIN
INNER TITLE_VERSION.TITLE_VERSION.VERSION_ID
IN TITLE_VERSION TO UNIQUE
TITLE_HIERARCHY.TITLE_HIERARCHY.PARENT_VERSION_ID
IN TITLE_HIERARCHY TAG J10 AS J10
END
JOIN
INNER FILE REPT_TITLE_VERSION
AT J10.TITLE_HIERARCHY.PARENT_ID TO UNIQUE
FILE REPT_TITLE_VERSION_BUSINESS_VIEW
AT TITLE_VERSION_BUSINESS_VIEW.EDM_TITLE.ID TAG J14
AS J14
WHERE ( J10.TITLE_HIERARCHY.PARENT_ID EQ J14.EDM_TITLE.ID ) AND ( J10.TITLE_HIERARCHY.HIERARCHY_CODE EQ 'BCAST' );
END
JOIN
INNER FILE TITLE_VERSION AT J14.EDM_TITLE.VERSION_ID
TO UNIQUE FILE TITLE_REL_DATE
AT TITLE_REL_DATE.TITLE_REL_DATE.VERSION_ID
TAG J15 AS J15
WHERE ( J14.EDM_TITLE.VERSION_ID EQ J15.TITLE_REL_DATE.VERSION_ID ) AND (J15.TITLE_REL_DATE.MEDIA_CD IN ('FTV','TV') );
END
JOIN
LEFT_OUTER TITLE_REL_DATE.TV_AIR_TM_CD IN
TITLE_VERSION TO UNIQUE
REF_TV_NETWORKS.REF_TV_NETWORKS.TV_NET_CD
IN REF_TV_NETWORKS TAG J18 AS J18
END


DEFINE FILE TITLE_VERSION
NAME/A20=SER_NM || '-' || SEAS_NUM;
END
TABLE FILE TITLE_VERSION
PRINT
NAME
J14.EDM_TITLE.FIN_PROD_ID
J14.EDM_TITLE.TITLE_DESC
BY J15.TITLE_REL_DATE.TITLE_RLSE_DT
BY LOWEST TITLE_VERSION.TITLE_DESC NOPRINT
BY J10.TITLE_HIERARCHY.CHLD_SEQ_NUM NOPRINT
BY J14.EDM_TITLE.ID NOPRINT
WHERE J10.TITLE_HIERARCHY.CNTRY_CD EQ 'US';
WHERE RECORDLIMIT EQ 10
WHERE READLIMIT EQ 10
ON TABLE NOTOTAL
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
TYPE=REPORT,
COLUMN=N2,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N5,
WRAP=6.000000,
$
ENDSTYLE
END

Please suggest what is the error in the code...

This message has been edited. Last edited by: <Kathryn Henning>,

quote:

(FOC370) THE FIELDNAME USED IN JOIN CANNOT BE FOUND IN THE FILE:
J15.TV_AIR_TM_CD

The error message suggests you're attempting to use a non-existing field.

Is there an actual field called TV_AIR_TM_CD in your TITLE_REL_DATE synonym?

Throwing in
?FF TITLE_VERSION
-RUN
before the DEFINE might help.

Your joins start from at least 3 different tables.
Only those starting from file TITLE_VERSION will be visible to your table request on that table.

Try changing the last JOIN to refer to the host field as J15.TITLE_REL_DATE.TV_AIR_TM_CD and see what happens.