Focal Point
Master file name too long for JOIN statement!

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3601034752

November 15, 2007, 03:22 PM
Francis Mariani
Master file name too long for JOIN statement!
Works:

JOIN
BASEL_BSL_BCS_EXTRACT_ACCT_F.BMO_RESP_NODE_CD IN
BASEL_BSL_BCS_EXTRACT_ACCT_F TO ALL
BASEL_BSL_REPTG_RESP_F.RESP_NODE IN
BASEL_BSL_REPTG_RESP_F AS J1
END

Doesn't work:

JOIN
BASEL_BSL_BCS_EXTRACT_ACCT_F_OLD.BMO_RESP_NODE_CD IN
BASEL_BSL_BCS_EXTRACT_ACCT_F_OLD TO ALL
BASEL_BSL_REPTG_RESP_F.RESP_NODE IN
BASEL_BSL_REPTG_RESP_F AS J1
END

I get:
 (FOC009) INCOMPLETE REQUEST STATEMENT
 (FOC009) INCOMPLETE REQUEST STATEMENT


This is in 5.3.3. Anyone have long table names in joins in v7?


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
November 15, 2007, 03:25 PM
Francis Mariani
What's dumb is that we have no trouble generating the meta-data with this name, but we can't use it in a join!


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
November 15, 2007, 03:37 PM
Prarie
I have tables with 35 characters that have been working in joins for several back releases.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
November 15, 2007, 03:38 PM
FrankDutch
I do not know the boundaries, but since I started in the former century with computers we only could use the 8 character file names. I still try to do that.




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

November 15, 2007, 03:41 PM
Prarie
Yes...I remember that Century...


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
November 15, 2007, 03:55 PM
Francis Mariani
Never mind!

It works. I've figured out that it has to do with another deficiency - FOCUS INDEX field names cannot be more than 12 characters so I had a COMPUTE of the INDEX field name but the name was already in the JOIN structure.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server