Re: [GENERAL] Migrating data from DB2 zOS to PostgreSQL

[bend]

We have recently done something similar - Converting Informix zLinux to Postgres x86_64.Short answer - We used unloads to put out csv files, wrote some python programs to cleanup data, thenimported them into our Postgres instance ...Ben Duncan - Business Network Solutions, Inc. 336 Elton Road  Jackson MS, 39212"Never attribute to malice, that which can be adequately explained by stupidity"- Hanlon's Razor


 Original Message 
Subject: [GENERAL] Migrating data from DB2 zOS to PostgreSQL
From: Swapnil Vaze 
Date: Mon, December 05, 2016 11:36 pm
To: pgsql-general@postgresql.org

Hello,We need some help on how we can migrate data from DB2 zOS database to postgres database.Are there any utilities present? Any thoughts how we should approach?-- Thanks & Regards, Swapnil Vaze  

[GENERAL] Cant compile using stock RH71 and libpq++

[John Bend]

Can anyone please help (before I go insane).

In learning C++, QT and PostgreSQL I have created a very simple
program to connect to my database but I cannot compile it. I really
cannot see what I am doing wrong.

Postgress is running and was fully installed when I installed Redhat
7.1. The libpq++ header is truly in the specified path. I can
successfully compile and connect using C.

Thanks in advance.

John Bend.


Here is the simple program:

#include iostream
#include libpq++.h


int main()
{

PgDatabase db(dbname=template1);

cout  Program pg1.cpp finished  endl;

}


I compile it with the line:

g++ pg1.cpp -I/usr/include/pgsql -lpq


And get the following error:

/tmp/ccqlJ23X.o: In function `PgDatabase::PgDatabase(char const *)':
/tmp/ccqlJ23X.o(.PgDatabase::gnu.linkonce.t.(char const *)+0x13):
undefined reference to `PgConnection::PgConnection(char const *)'
/tmp/ccqlJ23X.o: In function `PgDatabase::~PgDatabase(void)':
/tmp/ccqlJ23X.o(.gnu.linkonce.t._._10PgDatabase+0x1d): undefined
reference to `PgConnection::~PgConnection(void)'
/tmp/ccqlJ23X.o: In function `PgDatabase type_info function':
/tmp/ccqlJ23X.o(.gnu.linkonce.t.__tf10PgDatabase+0x10): undefined
reference to `PgConnection type_info function'
/tmp/ccqlJ23X.o(.gnu.linkonce.t.__tf10PgDatabase+0x18): undefined
reference to `PgConnection type_info node'
collect2: ld returned 1 exit status

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl