Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn IB Bloggers
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CLOSED] Datamigrator - Ambiguity while joining 2 tables which have same column name
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Datamigrator - Ambiguity while joining 2 tables which have same column name
 Login/Join
 
Member
posted
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: Chuck Wolff,


WebFOCUS 8
Windows, All Outputs
 
Posts: 10 | Registered: March 14, 2017Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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.6.9/7.7.06M, iWay DataMigrator, ISM, Windows, DB2 Windows V10.5, MS SQL Server, Hyperstage
 
Posts: 112 | Registered: March 29, 2013Reply With QuoteReport This Post
Silver Member
posted Hide Post
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


7703 & 8009 AIX Websphere /Tomcat
input: Teradata, SQL, DB2, Essbase, Oracle, text
output:html, excel, PDF,
 
Posts: 32 | Location: DFW Texas | Registered: May 30, 2008Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CLOSED] Datamigrator - Ambiguity while joining 2 tables which have same column name

Copyright © 1996-2017 Information Builders, leaders in enterprise business intelligence.