An IXF format should be platform independent and will contain all indexes and primary keys for the table including the data itself.

I see NO problem with your method as long you extract the data with a simple EXPORT statement (without invoking EXPORT with options specific to only version 8.1. For example: LOBS option will be processed in version 8 differently then in version 7.2 and 5, etc.).

Regards,

Perluser.


----- Original Message -----
From: "Tabet, Fayek" <Fayek.[Email Address Removed] Monday, November 3, 2003 9:31 am
Subject: Export / Import Data

> Hello all;
>
> If I do export of data from a DB2 UDB Database on UNIX Solaris to a
> IXF or DEL format of lower version (5.2) wow to old of DB2/UDB
> Can I load these data back on an NT DB2 UDB Database (V8.1)
>
> I am planning to create these tables with the new version 8 first.
> These tables have no constraints, no stored proc no auditing.
> Just a small plain tables that each have a primary key.
>
> Theoretically This is very possible. Should I worry about the new
> tables on version 8 or they will be create as described by the DDL?
>
>
> DOES ANY ONE KNOW IF THIS CAN BE DONE HAS IT EVER BEEN TESTED?
> OR I HAVE TO UPGRADE THIS DATABASE FROM 5.2 TO 6.0 THEN 7.0 THEN
> 8.0?
>
>
>
>
>
> Can anyone help
>
>
>
> Fayek Tabet
> HQMVAC Chair
> DSD / Distributed Database
> (613) 952-9019
> <<...OLE_Obj...>>
> May The Peace & happiness be with you at all time.
>
>
>
> -------------------------------------------------------------------
> --
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> Get today's cartoon: http://www.LazyDBA.com
> To unsubscribe, e-mail: db2udbdba-[Email Address Removed] For additional commands, e-mail: db2udbdba-[Email Address Removed]
>

DB2 & UDB email list listserv db2-l LazyDBA home page