Duplicate table designator Error When joining tables

Brett James

• 2020年07月04日 16:06

Recently updated Bartender10 to Bartender 2016 and I am now having difficulty creating new database connections to our AS400 through ODBC connection. That is to say our older labels created with the old version of software are still connecting, but if I make a new label document and add a DB connection I get errors as soon as I try to join two tables.

Error: ERROR [HY000] [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0212 - Duplicate table designator WSHPLHT1 not valid.

If I understand this error correctly Bartender thinks I have two tables linked with the same name, which can happen from two different libraries. However both of these tables have unique names and come from the same library so I don't know how to proceed.

1

• 

  Peter Thane

  ★ BarTender Hero ★

  • 2020年07月04日 17:18

  This maybe one you should refer to your regional Seagull Tech Support team rather than this user forum,

  Do you still get the error when you only have one join condition? 

  0

サインインしてコメントを残してください。