I was wondering if there is a Postgres JDBC Type 4 wrapper for DB2 Federated
Server. The default wrapper from IBM has a number of issues with Postgres
which a better wrapper could solve. I will attempt to modify the IBM wrapper
if I can get my hands on the source code.
--
Sent via pgsql-general
Just cast to integer. Decimal portion will be lost.
Sent from my smartphone
- Reply message -
From: "Ian Pilcher"
To:
Subject: [GENERAL] Cast double precision to integer & check for overflow
Date: Sat, Jan 26, 2013 3:13 pm
I need to cast a double precision into an integer, and I want
I need a sample database and hard practice SQL questions (multiple joins,
window functions, subqueries, CTEs) to write ad hoc queries or perform database
tasks. Any suggestions are welcome. Thanks in advance.
Sent from my smartphone
- Reply message -
From: g.si...@utwente.nl
To:
Subjec
I'm going to be accessing a Postgres database through DB2 Federated Server
and extracting/inserting with IBM Optim. I want to verify that Optim and DB2
are not corrupting text characters. This SQL should generate a sample set of
characters:
Select genseries, chr( genseries) from generate_series(1
I need to determine relationships between several tables. Is there a free tool
to extract these from catalog tables? Is there an SQL that also does this?
Thanks
Alex
Sent from my smartphone
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 famili
The IBM people aren't being helpful so I thought I'd ask here.
Sent from my smartphone
- Reply message -
From: "John R Pierce"
To:
Subject: [GENERAL] Mapping PostgreSQL data types to DB2 Federated Server
Date: Sun, Oct 14, 2012 8:05 pm
On 10/14/12 5:52 PM, Ale
What is the data physically stored as for boolean type? I know that it is one
byte but is it char, int, or something else?
Sent from my smartphone
