Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: storing byte values

Re: storing byte values

From: <pascal.dulleck_at_veda.net>
Date: Wed, 08 Aug 2007 09:06:54 -0700
Message-ID: <1186589214.691794.201180@o61g2000hsh.googlegroups.com>


On 8 Aug., 12:28, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
> Did you take a look at the Migration Workbench?!?
I did today... Nice tool indeed!
Unfortunately it seems to support only DB2/400 version V4R3 and V4R5. We have V5R4. But I tried it with an MS SQL-Server 2005 database which has been migrated from the DB2 before.

Anyway, the migration needs to be done from within our application with JDBC, but I can use the Migration Workbench for some tests and experiments.

As Vladimir pointed out in a previous post, the RAW type does NOT have the one-column-per-table restriction. I got confused with LONG RAW. So I can use RAW for the key fields and BLOB for larger fields that are not used as a key. This means that our migration has a restriction of binary keys with maximum 2000 bytes. I think we can live with that for some time. Received on Wed Aug 08 2007 - 11:06:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US