Moving CLOB data from OS/390 DB2 to UDB V 8.2

beena

We have a mainframe DB2 table with CLOB data type...

What's the best way to transfer CLOB data from os/390 DB2
to UDB (8.2) on AIX 5.2.

We tried unloading data with fixed format and tried loading in UDB
using Method L.
Unloaded CLOB field seems to have \n which causes confusion with the
row delimitor (\n)...

Any suggestions...

Nov 12 '05 #1

Subscribe Post Reply

1861

Ian

beena wrote:

We have a mainframe DB2 table with CLOB data type...

What's the best way to transfer CLOB data from os/390 DB2
to UDB (8.2) on AIX 5.2.

We tried unloading data with fixed format and tried loading in UDB
using Method L.
Unloaded CLOB field seems to have \n which causes confusion with the
row delimitor (\n)...

Any suggestions...

Use "load from file of ASC MODIFIED BY RECLEN=xxx ..."

Nov 12 '05 #2

pshindle

Hi -

I believe that as long as you have DB2 Connect you can use the EXPORT
utility to read the LOB from DB2/Zos (LOB data flows over a DRDA data
stream) and then use the IMPORT utility to UDB. I'm not sure if the
table structures have to match though... It's worth a shot. Please
reply back when you find your solution - it would be valuable for
others to know how to do this. Thanks.

Perry Shindle

beena wrote:

We have a mainframe DB2 table with CLOB data type...

What's the best way to transfer CLOB data from os/390 DB2
to UDB (8.2) on AIX 5.2.

We tried unloading data with fixed format and tried loading in UDB
using Method L.
Unloaded CLOB field seems to have \n which causes confusion with the row delimitor (\n)...

Any suggestions...

Nov 12 '05 #3

Similar topics

Moving MySQL data to RAMDisk

by: Creigh Shank | last post by:

On moving my data files from /var/lib to /mnt/ramdisk I seem to be missing something. I've changed every .ini and .conf file I can find (/etc/my.cnf, /etc/init.d/mysql, /etc/init.d/mysqld,...

MySQL Database

moving XML data from client to server vice versa

by: Mr. x | last post by:

.... The second time I am sending this email ... .... I want a good solution, please. .... Thanks :) What I need is moving xml data from client to server & vice versa, but not using xml file....

.NET Framework

Stumped With Clob data

by: pankaj_wolfhunter | last post by:

I have a table with a clob column with 10 records and each record is around 1MB. I just want to know is there any way that i can export or send this clob data of each record into separate file....

DB2 Database

Updating an Oracle CLOB data type.

by: Jimm | last post by:

Can anyone advise me as to the best method for updating an Oracle CLOB data type. I have to update a single column of CLOB data type via a web service. Thank you in advance. Jimm.

.NET Framework

Update Oracle CLOB Data Type?

by: Jimm | last post by:

Can anyone advise me as to the best method for updating an Oracle CLOB data type. I have to update a single column of CLOB data type via a web service. Thank you in advance. Jimm.

.NET Framework

Create report that displays Oracle CLOB data correctly?

by: egarobar | last post by:

I am using Access 2003 (on WinXP) to read from an Oracle db, where there is a table with a CLOB which is a variable-size text field. In the 'linked table' which is created in the Tables panel of...

Microsoft Access / VBA

How do i get clob data using java and assign to a variable

by: kanthi84 | last post by:

Hiiiiii i am having a table in oracle. in that table one of the column is to store clob data. and in that clob column, the data is inserted like the following using separators kanthi~is a...

Oracle Database

Update time stamp for CLOB Data

by: vtang | last post by:

Is there a way using PL/SQL script to update the time stamp of a CLOB data in a table? Basically we can download the CLOB file to local and update the content with new time stamp.

Oracle Database

Unable to display clob data field with more than 32k characters on discover worksheet

by: pthai | last post by:

Discover worksheet only retrieved up to 32K characters for my discover worksheet that it pulls data from a clob data column value. I am new to discover plus. Any help would be appreciate. Thanks....

Oracle Database

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware