Return-Path: Delivered-To: apmail-cayenne-user-archive@www.apache.org Received: (qmail 14748 invoked from network); 20 Nov 2008 09:19:02 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 20 Nov 2008 09:19:02 -0000 Received: (qmail 18032 invoked by uid 500); 20 Nov 2008 09:19:10 -0000 Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org Received: (qmail 18020 invoked by uid 500); 20 Nov 2008 09:19:10 -0000 Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cayenne.apache.org Delivered-To: mailing list user@cayenne.apache.org Received: (qmail 18009 invoked by uid 99); 20 Nov 2008 09:19:10 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 20 Nov 2008 01:19:10 -0800 X-ASF-Spam-Status: No, hits=-1.0 required=10.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [83.140.161.195] (HELO mail.fsys.se) (83.140.161.195) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 20 Nov 2008 09:17:48 +0000 Received: from [192.168.1.71] ([192.168.1.71]) by mail.fsys.se (8.14.3/8.14.1) with ESMTP id mAK9GUv9014523 for ; Thu, 20 Nov 2008 10:16:30 +0100 Message-Id: <6D15FC69-3733-4D5E-AE02-FE521896E113@fsys.se> From: Andreas Pardeike To: user@cayenne.apache.org Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v929.2) Subject: Duplicate table names? Date: Thu, 20 Nov 2008 10:16:30 +0100 X-Mailer: Apple Mail (2.929.2) X-Proofpoint-Virus-Version: vendor=fsecure engine=1.12.7400:2.4.4,1.2.40,4.0.166 definitions=2008-11-20_02:2008-11-19,2008-11-20,2008-11-20 signatures=0 X-Proofpoint-Spam-Reason: safe X-Virus-Checked: Checked by ClamAV on apache.org Hi, I have a project that uses DB2 tables that I don't have control over. The problem is that for a specific database entity, I need to handle records from three different DB2 libraries: - LIB1.TABLE - LIB2.TABLE - LIB3.TABLE Before, I simply created a view that contained a union of those three tables but now I need to write to it. When I try to create those three tables in the modeler, it does not like to create DBEntity Configuration Name: TABLE Schema: LIB1 + DBEntity Configuration Name: TABLE Schema: LIB2 Why does this limitation exist? Is there a way around? I really need to write to those tables depending on the logged-in user. Any help appreciated, Andreas Pardeike