Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TNYuu-0003rJ-Ha for pgsql-general@postgresql.org; Mon, 15 Oct 2012 00:52:24 +0000 Received: from cmsout01.mbox.net ([165.212.64.31]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TNYum-0007wm-Uf for pgsql-general@postgresql.org; Mon, 15 Oct 2012 00:52:24 +0000 Received: from co01.mbox.net (localhost [127.0.0.1]) by cmsout01.mbox.net (Postfix) with ESMTP id 3087966838A for ; Mon, 15 Oct 2012 00:52:13 +0000 (UTC) X-USANET-Received: from co01.mbox.net [127.0.0.1] by co01.mbox.net via mtad (C8.MAIN.3.82G) with ESMTP id 830qJoa1k5312M01; Mon, 15 Oct 2012 00:52:10 -0000 X-USANET-Routed: 3 gwsout-vs Q:bmvirus Received: from imap02.cms.usa.net [165.212.11.2] by co01.mbox.net via smtad (C8.MAIN.3.87D) with ESMTP id XID830qJoa1k4305X01; Mon, 15 Oct 2012 00:52:10 -0000 X-USANET-Source: 165.212.11.2 OUT gataric@usa.net imap02.cms.usa.net X-USANET-MsgId: XID830qJoa1k4305X01 Received: from Alexoffice [24.12.102.168] by imap02.cms.usa.net (ESMTPSA/gataric@usa.net) via mtad (C8.MAIN.3.82G) with ESMTPSA id 588qJoa1k4704M22; Mon, 15 Oct 2012 00:52:10 -0000 X-USANET-Auth: 24.12.102.168 AUTH gataric@usa.net Alexoffice From: "Alexander Gataric" To: References: <201209270859.09943.andres@2ndquadrant.com> In-Reply-To: Subject: Mapping PostgreSQL data types to DB2 Federated Server Date: Sun, 14 Oct 2012 19:52:09 -0500 Message-ID: <00eb01cdaa6f$4ea12d90$ebe388b0$@net> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00EC_01CDAA45.65CB2590" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: Ac2qbsAf0BBEMQnWT6u+82i6+86LqQAAGYNg Content-Language: en-us Z-USANET-MsgId: XID588qJoa1k4704X22 X-Pg-Spam-Score: 0.0 (/) X-Archive-Number: 201210/435 X-Sequence-Number: 191403 This is a multi-part message in MIME format. ------=_NextPart_000_00EC_01CDAA45.65CB2590 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hello, I'm on a project which requires adding PostgreSQL tables to DB2 Federated Server. I'm getting an error with PostgreSQL data types boolean, text, bytea, and XML. I believe this can be solved with the CREATE TYPE MAPPING in Fed Server. Does anyone know which values to use? I'm not that familiar with Fed Server. Also, the Postgres data is being extracted and inserted from the same table using Optim Archive. Does this pose an additional challenge with setting up the mapping? Thank you in advance Alex ------=_NextPart_000_00EC_01CDAA45.65CB2590 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hello,

I'm on a project which requires adding PostgreSQL tables to DB2 = Federated Server. I'm getting an error with PostgreSQL data types = boolean, text, bytea, and XML. I believe this can be solved with the = CREATE TYPE MAPPING in Fed Server. Does anyone know which values to use? = I'm not that familiar with Fed Server.

Also, the Postgres data is being extracted and inserted from the same = table using Optim Archive. Does this pose an additional challenge with = setting up the mapping?

Thank you in advance

Alex

 

------=_NextPart_000_00EC_01CDAA45.65CB2590--