Jump to content

Wire AS400 ODBC driver only permits one SQL Collection

Manoj Chaurasia

Recommended Posts

I am using Scribe with Wire ODBC driver for AS400 iSeries as recommended by Scribe.

Today I want to use " update Source" feature in Scribe Workbench, however as I am using a simple SQL Select string this does not seem possible as I get " Source Query is not updateable" .

OK, I say, I will try using file selection tool instead. Unfortunately my Wire ODBC driver only permits one " SQL Collection" . Collection is similar to AS400 concept of Library, however I need multiple libraries in my integrations. Typically AS400 ODBC drivers permit multiple libraries in " Library List" .

Question: is there a way to

1) use " update Source" using SQL String, or

2) allow multiple " collections" in using Wire Driver. Other AS400 drivers permit this.

Posted by Martin C. on Nov 27 2015 8:51PM { U5886 , F8 , T4177 , C12470 }

Link to comment
Share on other sites

A: The Update Source is very finicky and I would recommend using an Update step in the target instead (use a separate connection not the source connection)

The Scribe DB2 Wire Protocol driver is a 3rd party drive from DataDirect - so there isn't much that can be done in that regard

Q: Are you suggesting using a separate ODBC definition/connection for source and destination

A: A separate connection for use by the Update step in the target (configure steps)

Sometimes there are locking issues if updating the source using the same connection as the source

What I'm recommending is not using the Update Source in Configure Source but an Update Step in Configure Steps

Posted by Martin C. on Nov 30 2015 7:08PM { U5886 , C12471 }

Link to comment
Share on other sites

  • 3 years later...
Did you ever find a solution I am running into the same issue where the Wire Protocol driver only supports one "collection". I was forced to use the Wire Protocol driver some time ago as an update to Scribe broke my existing ODBC connection. Very frustrating.
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...