Best way to transfert high volume data between AS400/DB2 to Unix-Sybase

[etienno]

Hi,

what would be the best way to transfert high volume data (100 tables,
500Meg each) between DB2/AS400 to Sybase?

Thanks Etienne.
Montreal

[dotyet]

do a del-ascii export from db2 side
do a bcp import on sybase side

you will have to manually or through scripts, process the data for
things like timestamps, "-" instead of "NULL".

regards,
dotyet

[Etienne]

Thank dotyet,

Do you know what kind of other exceptions I would need to check in the
data?

Does most of the datatype are compatible between db2 and sybase? Per
exemple, can varchar in db2 be higher than 255 characters? I know that
in sybase a varchar is limited to 255 chars.

Thanks,
Etienne

"dotyet" <do****@yahoo.com> wrote in message news:<11**********************@z14g2000cwz.googleg roups.com>...

do a del-ascii export from db2 side
do a bcp import on sybase side

you will have to manually or through scripts, process the data for
things like timestamps, "-" instead of "NULL".

regards,
dotyet

[Karl Hanson]

Etienne wrote:

Thank dotyet,

Do you know what kind of other exceptions I would need to check in the
data?

Does most of the datatype are compatible between db2 and sybase? Per
exemple, can varchar in db2 be higher than 255 characters? I know that
in sybase a varchar is limited to 255 chars.

Thanks,
Etienne

"dotyet" <do****@yahoo.com> wrote in message news:<11**********************@z14g2000cwz.googleg roups.com>...

do a del-ascii export from db2 side
do a bcp import on sybase side

you will have to manually or through scripts, process the data for
things like timestamps, "-" instead of "NULL".

regards,
dotyet

Check limits in Appendix A of the SQL Reference:
http://publib.boulder.ibm.com/infoce...mstlimtabs.htm
http://publib.boulder.ibm.com/infoce.../rzahgdref.htm

--
Karl Hanson