Focal Point
[CLOSED] Datamigrator - Ambiguity while joining 2 tables which have same column name

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/8917067786

September 14, 2017, 09:45 PM
rboya
[CLOSED] Datamigrator - Ambiguity while joining 2 tables which have same column name
I have 2 tables

Table A- Party_ID,kk,ll,mi,ll (Party_ID,kk,ll,mi,ll are column names in Table A)

Table B- Party_ID,aa,bb,cc,dd (Party_ID,aa,bb,cc,dd are column names in Table B)

When joining Table A with Table B, I get below error.

(FOC1400) SQLCODE IS -203 (HEX: FFFFFF35)
: [42702] [IBM][CLI Driver][DB2/AIX64] SQL0203N A reference to column "PARTY_ID" is ambiguous. SQLSTATE=42702
(FOC1405) SQL PREPARE ERROR.

Could anyone please help.

Thanks,
Rajesh

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8
Windows, All Outputs
September 15, 2017, 04:29 AM
Martin vK
Hi Rajesh,

Do you use a Data Flow or an SQL flow?
In both cases, can you right click on the SQL object to get the SQL statement and post it here?

Martin.


WebFocus 7.7.06M/8.2.03M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
September 15, 2017, 11:25 AM
KenFR
quick work around if the tables can be filtered to fit in temp space would be to hold the needed data from both tables into hold files sorted by party_id and then join them.
I suspect the mas file does not recognize party_id as unique...look for s1 or higher segtype in .mas or key in acx


8105 Tomcat and AIX reporting server
input: Teradata, SQL, DB2, Essbase, Oracle, text
output:html, excel, PDF,