URGENT:Exportin g and Importing data using IXF format

rafeekb

Hello All,

Is there any way to export data in the IXF version 1 format from a DB2
v8.2 database ?

The problem I am facing is to get the data from a v8.2 database which
produces a version 2 IXF and import it on to a v5.2 database which
knows only about version 1 IXF format.

Any suggestions, help is much appreciated.

Regards.

Nov 12 '05 #1

Subscribe Reply

4380

Mark A

<ra*****@techie .com> wrote in message
news:11******** *************@g 47g2000cwa.goog legroups.com...

Hello All,

Is there any way to export data in the IXF version 1 format from a DB2
v8.2 database ?

The problem I am facing is to get the data from a v8.2 database which
produces a version 2 IXF and import it on to a v5.2 database which
knows only about version 1 IXF format.

Any suggestions, help is much appreciated.

Regards.

Use a format other than IXF. Is there a legitimate reason why you must use
IXF format? Get the DDL separately with db2look command.

Nov 12 '05 #2

rafeekb

The source data is coming from an AS/400 machine and going to a UNIX
box and the reason for using IXF format is to take care of the EBCDIC
to ASCII convertions. I believe IXF is mainly used for transferring
data across platforms. Its the format thats causing the problem.

Cheers.

Nov 12 '05 #3

Walter Schneider

Hello,

the codepage conversion between DB2 databases on different platforms has
*nothing* to do with export/import formats! DB2 already presents the data
to the export utility converted to the codepage applicable for the platform
where it is running.

Only thing I know about is, that export and import are restricted to
IXF-format when running them against remote DB2 databases on AS/400 or z/OS
(f.k.a. OS/390).

But perhaps this trick may help you: export your AS/400 data in IXF-format,
create a "transfer" database in your DB2 V8.2 and import the IXF-files there
(they inherit the table definition as well, if you used the proper
parms...). Afterwards, export the data again from the "transfer" tables, but
this time in DEL-format (for example). This DEL-export files can then be
imported to your V5.2 database on UNIX.

Cheers - Walter.

<ra*****@techie .com> schrieb im Newsbeitrag
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .

The source data is coming from an AS/400 machine and going to a UNIX
box and the reason for using IXF format is to take care of the EBCDIC
to ASCII convertions. I believe IXF is mainly used for transferring
data across platforms. Its the format thats causing the problem.

Cheers.

Nov 12 '05 #4

Pierre Saint-Jacques

I don't think so.
If your problem is to use the IXF to create the table in 5.2 db then:
1) Use db2look on V8 to extract the ddl
2) Edit the output file to bring it to the 5.2 reqts.(db name, target
tblspc, etc..)
3) Export your data in filetype of DEL
4) Run the db2look output on V5.2
5) Import ... of DEL in your newly created table.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<ra*****@techie .com> a écrit dans le message de news:
11************* ********@g47g20 00...legro ups.com...

Hello All,

Is there any way to export data in the IXF version 1 format from a DB2
v8.2 database ?

The problem I am facing is to get the data from a v8.2 database which
produces a version 2 IXF and import it on to a v5.2 database which
knows only about version 1 IXF format.

Any suggestions, help is much appreciated.

Regards.

Nov 12 '05 #5

Similar topics

10717

How to disabled all constraints when importing data (urgent)

by: Paul | last post by:

Hi: I am not sure whether somebody can sort it out for me. I am doing data transfer from one oracle database to another. Both of them has the same structure (like same tables etc).the only thing i need to do is data transfering. i designed a vb program to do this, What i am worrying is when I run this program it might fire some constrants. Anybody can give me some

Oracle Database

1803

URGENT!! Problem sending data to field

by: James | last post by:

Hi, I have a combo box(cmboParts) and the row source is a part name. Once a part is selected I have button(cmdOrderAdd) to add data about this part to a sub-form(frmParts_Ordered). However this sub-form does not have the field PartName. Instead it has a field called PartCode. Therefore i have had to set up a QBE to find PartCode(both PartName and PartCode are in the same table 'tblPart') and this will be used in the code for the button.

Microsoft Access / VBA

1192

very urgent-display html data

by: samir dsf | last post by:

hi this is kinda urgent ... i will insert some data in html format..i just need to know how to disply it back.its urgent...so if anyone can suggest pls tell me i simply need to know that if i store it in bold or something ..then how will i retreive it thnkas

ASP.NET

1095

Urgent - Some sql data in html table not showing after server move

by: Joey Martin | last post by:

This is urgent, so any quick help is much appreciated!!!! I have an ASP page that pulls data from a SQL table and puts it into a basic html table. This is basic stuff. I moved my pages from a SQL 2003 Standard Edition server to a SQL 2003 Web Edition Server. After this, some of my data is not showing in a standard html table.

ASP / Active Server Pages

4141

Urgent Memory Leak Problem Using Type Dataset. Please help! :-(

by: Simon | last post by:

Hi all, I'm having a baffling problem with a windows service that I'm working on. Basically, I am using a typed dataset to insert a large number of rows into an SQL Server 2005 database. But there's a memory leak that seems to be to do with calling the data adapters update method. It's making the memory usage go through the roof and ultimately the service crashes after running out of memory.

C# / C Sharp

24958

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 good girl~she is very pretty~,^mamy~is a good girl~ wat i need is , i need to get them separately

Oracle Database

922

Importing data

by: ITCraze | last post by:

Hey everyone: I just want to discuss the problem releted to ASP.NET 2005 and MySQL database.I have a text file with delimiter as space.Now I want to import the text file data into MySQL database.Suppose text file contains : sdf dfdsf dfdsf Now in the database I have three fields , so above text file data should go to the database in particular fields. I have used LOAD DATA INFILE 'pathname' into table table name fields terminated...

.NET Framework

1410

problem entering data using a web form

by: arial | last post by:

Hi all, I am not sure this question will belong to a sql group or .net. but the problem I have is, my data entry forms crashes when some enter a apostrophe character in one of the field. that field is of type varchar in sql server 2000. for ex, Ryan O'neill will crash the application. what should I need to do to allow user to add apostrophe and not to have application crash?

.NET Framework

2467

Truncated data using .NET 3.5 sockets VS 2008

by: Kenny D | last post by:

I am having trouble sending streams of data from one socket to another using the following code. When the transmitter is running on the same machine as the receiver, the data transmits perfectly. When the transmitter runs on another machine, the data gets truncated at semi random places. The data being transmitted is a unicode XML string. There is nothing special about it other than being unicode.

C# / C Sharp

8392

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8726

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8503

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8603

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

5632

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4151

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4301

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1944

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1604

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General