RE: [SPAM] SQL SERVER/ISERIES INTEGRATION

["Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Rosalie,

CREATE COLLECTION and CREATE SCHEMA are SQL standards and automatically
start journaling in that collection/schema/library, again per SQL standards.
CRTLIB is OS400 native command and does not comply with SQL standards (nor
should it), so it does not automatically start journaling.

By default, most ODBC or JDBC drivers have AutoCommit set to true and
Transaction Level set to something other than NONE (NC).

If you want to create new table in a library created using CRTLIB command
and update its data (i.e. via INSERT), then you need to tell the SQL
driver/server/connection not to AutoCommit and set the Transaction Level to
NONE.

SQL command is SET TRANSACTION ISOLATION LEVEL NONE.

Alternatively, you could start journaling on that library, but that is more
involved solution and requires some planning.  Not to say that there's
anything wrong with it :)

Elvis


-----Original Message-----
Subject: [SPAM] 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