Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Sybase 11.9.2 & INFOPUMP

2 posts in Migration Last posting was on 2000-11-18 05:40:16.0Z
wang_mary Posted on 2000-11-13 19:52:55.0Z
From: wang_mary@jpmorgan.com
Date: Mon, 13 Nov 2000 14:52:55 -0500
Newsgroups: sybase.public.sqlserver.migration
Subject: Sybase 11.9.2 & INFOPUMP
Message-ID: <4F9F2D6B825D2FF8006D374185256996.006D375985256996@webforums>
Lines: 5
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.migration:370
Article PK: 1067794

Is anyone still using Infopump (3.1.0) with Sybase 11.9?
We have experienced differences in the execution of Infopump scripts that
transport data from DB2 into Sybase. Any table over a 2000 rows failed.
Are there changes necessary for the Open Client software.
Any help would be appreciated.


Anthony Mandic <amandic Posted on 2000-11-18 05:40:16.0Z
Date: Sat, 18 Nov 2000 16:40:16 +1100
From: Anthony Mandic <amandic@*t.com.au>
Organization: Mandic Consulting Pty. Ltd.
X-Mailer: Mozilla 4.61 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Sybase 11.9.2 & INFOPUMP
References: <4F9F2D6B825D2FF8006D374185256996.006D375985256996@webforums>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Message-ID: <Lk2n7RSUAHA.162@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.migration
Lines: 25
NNTP-Posting-Host: pix208a.magna.com.au 203.111.111.208
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.migration:366
Article PK: 1067790


wang_mary@jpmorgan.com wrote:
>
> Is anyone still using Infopump (3.1.0) with Sybase 11.9?

Infopump?

> We have experienced differences in the execution of Infopump scripts that
> transport data from DB2 into Sybase. Any table over a 2000 rows failed.
> Are there changes necessary for the Open Client software.

If it worked before, it should still work unless it was using a
"feature" that worked in an earlier version of Open Client that
has since been fixed.

However, if you can't get it to work, there are other, probably
better, ways to transfer data between DB2 and Sybase. Please
investigate Sybase's Omni products and the CIS features in
ASE 11.9.2. Simply put, you would only need an Omni or Connect
(I'm not quite sure what Sybase are calling these products now)
module for DB2. And then configure this to gain access to your
DB2 databases thru CIS. Then its a simple matter of writing
T-SQL scripts to do what you require.

-am