public inbox for [email protected]
help / color / mirror / Atom feedFrom: PABLO ANDRES IBARRA DUPRAT <[email protected]>
To: pgAdmin Support <[email protected]>
Subject: Question About Load Dara From DB2 LUW (AIX) to PostgreSQL
Date: Mon, 14 Apr 2025 21:09:05 +0000
Message-ID: <CPWP152MB4029238E9CB0320422A2A46787B32@CPWP152MB4029.LAMP152.PROD.OUTLOOK.COM> (raw)
Hi Dear postgreSQL profesionals.
I need your collaboration to found the correct way to export data from DB2 LUW and import over PostgreSQL table. The main problem with that DB2 LUW table are the datatype in this case is BLOB.
This is the DB2 LUW source table:
Data type Column
Column name schema Data type name Length Scale Nulls
------------------------------- --------- ------------------- ---------- ----- ------
ID_BPM SYSIBM VARCHAR 64 0 No
DATOS SYSIBM BLOB 4194304 0 Yes
Then, my doubts are:
1.
Which Postgres data type match with db2 luw blob?
2.
Which tool or procedure is the most recommended?
Thanks for any idea or advice.
Greetings.
*
*
[cid:1d4ac25f-f135-4066-b2a0-869ca8c6c4c7]
Para asegurar la adecuada lectura en todo tipo de correos electronicos, se han omitido intencionalmente los signos y acentos diacriticos del idioma castellano. La informacion contenida en este mensaje y cualquier archivo adjunto es confidencial y no puede ser usada por mas personas que sus destinatarios. El uso no autorizado de esta informacion puede ser sancionado de conformidad con el Codigo Penal chileno. Si ha recibido este correo por error, por favor notifique al remitente respondiendo este mismo mensaje y elimine el mensaje y todos los archivos adjuntos. Internet no puede garantizar la integridad de este mensaje, por lo que el Banco no se hace responsable si el contenido del mismo ha sido alterado.
Attachments:
[image/png] Outlook-dex3py5h.png (29.7K, 3-Outlook-dex3py5h.png)
download | view image
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: Question About Load Dara From DB2 LUW (AIX) to PostgreSQL
In-Reply-To: <CPWP152MB4029238E9CB0320422A2A46787B32@CPWP152MB4029.LAMP152.PROD.OUTLOOK.COM>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox