Search found 48 matches
- Tue Oct 02, 2007 3:52 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Transaction Management on the target database
- Replies: 11
- Views: 3046
Transaction Management on the target database
Scenario: Transferring transactions/data between two transactional databases. Transaction Management on the target database (Loading): If a unit of work requires completion of inserting data into multiple tables then, how do we manage the transaction from DataStage? Queries: - Can we handle transact...
- Fri Aug 10, 2007 3:00 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Loading to Sybase is very slow
- Replies: 4
- Views: 1257
Re: Loading to Sybase is very slow
you can use Sybase BCP load stage
[quote="sureshchandra"]Hi,
I am trying to insert 5,00,000 records from sql server to sybase
using odbc stage. the performance is very bad- 5 rows/sec. Any inputs.
Thanks in advance[/quote]
[quote="sureshchandra"]Hi,
I am trying to insert 5,00,000 records from sql server to sybase
using odbc stage. the performance is very bad- 5 rows/sec. Any inputs.
Thanks in advance[/quote]
- Fri Aug 10, 2007 2:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sybase Sql error
- Replies: 6
- Views: 3421
Re: Sybase Sql error
AS much i know about Sybase ase maximum date it allow is 6/6/2079 and if you fire your query mentioned in thread in isql it will give you arithmetic overflow. Hi All, I am using one sybase database table 'XXX'as my source ,and it contains one column like 'enddate'. and the values are like for this c...