RE: SQL SERVER/ISERIES INTEGRATION

First off, there is absolutely no valid reason why the files in your ERP
application can't be journaled.

Journaling is difference than commitment control.  Commitment control needs
journaling, but journaling doesn't require or imply the use of commitment
control.  You have to modify applications to use commitment control.  But
you can start journaling without affecting anything.

Many shops, mine included, use journaling without commitment control for
auditing purposes.


Now having said that.  The problem is SQL server expects to be able to use
commitment control, which as mentioned above requires the files to be
journaled.  If you chose not to simply start journaling, then you need to
find out how to tell SQL server not to use commitment control (aka
transactioning on SQL server) when writing to the table linked to the
iSeries.

Unfortunately, I don't know off the top of my head how to do that.  It may
not even be possible.


Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: Rosalie Ducasse [mailto:rosalie@xxxxxxxxxxx]
> Sent: Tuesday, November 09, 2004 8:25 AM
> To: midrange-l@xxxxxxxxxxxx
> Subject: SQL SERVER/ISERIES INTEGRATION
> 
> 
> I am trying to export data from a table on a sql server 
> database using a
> linked server to our iSeries.  The table gets created however 
> it does not
> populate the data and I get the following message :-
> 
> (Embedded image moved to file: pic12859.pcx)
> 
> None of the files or libraries that we need to populate on 
> the iSeries are
> journaled and we cannot journal them as they are part of an 
> ERP package.
> When I create a library through a SQL statement using "create 
> collection
> testlib" and try to populate the table it then works, however 
> when trying
> to update an existing table in an existing library it does 
> not.  I notice
> that the library "testlib" is created with journals.
> Can anyone help please?
> 
> Rosalie Ducasse
> Omnia iTs - Fertilizer CONTACT DETAILS:
> Tel:    + 2711 709 8816
> Fax:    + 2711 463 6045
> Cell:    + 2783 679 1415
> E-mail:    rosalie@xxxxxxxxxxx
> Website:    http://www.omnia.co.za/
> 
>