[CLOSED] getting error while joining the master files
Hi All, I am getting error while joining the master file .Please find below code for your refernce.
SQL SELECT DISTINCT QRY1.REGION_CODE AS REGION_CODE, QRY1.REGION_NAME AS REGION_NAME, QRY1.PRODUCTLINE_CODE AS PRODUCTLINE_CODE, QRY1.REGION_CODE || ' ' || QRY1.PRODUCTLINE_DESC AS PRODUCTLINE_DESC, QRY1.PLANT_CODE AS PLANT_CODE, QRY1.PLANT_NAME AS PLANT_NAME, QRY2.CATEG_CODE AS CATEG_CODE, QRY2.CATEG_DESC AS CATEG_DESC, QRY3.TARGET_CODE AS TARGET_CODE, QRY3.TARGET_DESC AS TARGET_DESC FROM (SELECT DISTINCT VCRM.REGION_CODE, VCRM.REGION_NAME, VCPLM.PRODUCTLINE_CODE, VCPLM.PRODUCTLINE_DESC, VCPM.PLANT_CODE, VCPM.PLANT_NAME FROM VIN_CORE_PLANT_MST VCPM, VIN_CORE_PRDLINE_DTL VCPLD, VIN_CORE_PRDLINE_MST VCPLM, VIN_CORE_REGION_MST VCRM
WHERE VCPM.PLANT_CODE = VCPLD.PRODUCTLINE_PLANT_CODE AND VCPLM.PRODUCTLINE_CODE = VCPLD.PRODUCTLINE_CODE AND VCRM.REGION_CODE = VCPLM.PRODUCTLINE_REGION AND (VCPM.PLANT_INACTIVE_DATE IS NULL OR VCPM.PLANT_INACTIVE_DATE > NOW)) QRY1, (SELECT distinct VCPDGP.PRODMAP_PARENT_CODE, VCPPM.PRODMAP_PLNT_CODE, VCCM.CATEG_CODE, VCCM.CATEG_DESC FROM VIN_CORE_PRODGRP_MAP VCPDGP LEFT JOIN VIN_CORE_PRDGRPPRT_PLANT_MAP VCPPM ON VCPDGP.PRODMAP_ID = VCPPM.PRODMAP_PRDGRP_CODE LEFT JOIN VIN_CORE_CODE_MST VCCM ON VCCM.CATEG_CODE = VCPDGP.PRODMAP_CHILD_CODE AND VCPDGP.PRODMAP_PARENT_LEVEL = 1 AND VCPDGP.PRODMAP_CHILD_LEVEL = 2 AND VCPPM.PRODMAP_PLNT_CODE IS NOT NULL AND VCCM.CATEG_TYPE = 'PRDGRP')QRY2, (SELECT SOURCE_CODE, TARGET_CODE, TARGET_DESC FROM VIN_PRODUCT_MAS )QRY3 WHERE QRY1.PRODUCTLINE_CODE = QRY2.PRODMAP_PARENT_CODE AND QRY1.PLANT_CODE = QRY2.PRODMAP_PLNT_CODE AND QRY1.REGION_CODE = QRY3.SOURCE_CODE; TABLE ON TABLE HOLD AS HLD_RES_1 END -*Hold file HLD_RES_1 ends TABLE FILE HLD_RES_1 PRINT * END -EXIT
Error :-(FOC14013) OUTER JOIN GENERATION (ONLY EQUIJOINS ALLOWED) IS NOT SUPPORTED
Please let me know how can i resolve.
Thanks, RaghuThis message has been edited. Last edited by: Kerry,
WebFOCUS 7.6.7 Windows Excel, PDF, HTML
August 27, 2010, 09:35 AM
Prarie
What kinds of tables are these? Are they different types?
In Focus since 1993. WebFOCUS 7.7.03 Win 2003
August 29, 2010, 05:52 PM
Waz
As you are issueing an SQL command. but not specifying the data source, then you are relying on the internal capabilitis of WebFOCUS with SQL.
If the source is a relational one, then specify file type.
i.e. for oracle it would be SQL SQLORA...
This is called SQL Passthrough. The SQL is passed directly to the RDBMS
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
December 30, 2015, 11:26 PM
jashwood
I have the same problem. The documentation states the SQL Translator supports LEFT OUTER JOINs and furthermore than it is ANSI Level 2 compliant. If so, why is [1] something as basic as a LEFT JOIN not supported and [2] has this been fixed in a future version (Focus 7.6)
As of my version of FOCUS it is far from ANSI Level 2 compliant.