Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Gettting error in join

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Gettting error in join
 Login/Join
 
Platinum Member
posted
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>,


Thanks!
@vi

WebFOCUS 8105, Dev Studio 8105, Windows 7, ALL Outputs
 
Posts: 103 | Registered: July 08, 2013Report This Post
Virtuoso
posted Hide Post
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?



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
Virtuoso
posted Hide Post
Throwing in
?FF TITLE_VERSION
-RUN
before the DEFINE might help.
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
Virtuoso
posted Hide Post
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.


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1669 | Location: Enschede, Netherlands | Registered: August 12, 2010Report This Post
Silver Member
posted Hide Post
Try changing the last JOIN to refer to the host field as J15.TITLE_REL_DATE.TV_AIR_TM_CD and see what happens.


8009
Windows, HTML, AHTML, Excel
In FOCUS since 1983
 
Posts: 41 | Location: Charlotte, NC | Registered: January 06, 2012Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Gettting error in join

Copyright © 1996-2020 Information Builders