![]() |
||||||||||||
Go ![]() | New ![]() | Search ![]() | Notify ![]() | Tools ![]() | Reply ![]() | ![]() |
Member |
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, RajeshThis message has been edited. Last edited by: FP Mod Chuck, WebFOCUS 8 Windows, All Outputs | ||
|
Platinum Member |
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 | |||
|
Silver Member |
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, | |||
|
Powered by Social Strata |
![]() | Please Wait. Your request is being processed... |
|