I'm currently working on a migration of a DB2 VM V7.2 database to DB2 UDB
Linux V8.2.
In the first stage the applications will stay on VM only the database will
be migrated.
Applications will be migrated in a second stage in the future.
The connectivity between DB2 VM as a DRDA requester and DB2 UDB as DRDA
server has been established.
At a first look at the applications one thing came up: they use SQL INSERT
via a CURSOR.
This works that way:
- a cursor is declared for INSERT
- the cursor is opened
- Rows are inserted via SQL PUT
- PUT will not immediately insert that row, but will store the rows in a
memory block until this block is full.
At that time the accumulated rows will get inserted all together.
Unfortunately DB2 UDB does not support INSERT via CURSOR (at least AFAIK).
My question: will it be possible to run the COBOL programs unchanged against
a DB2 UDB database?
Means will DRDA emulate a INSERT via cursor as it for example emulates
COMPOUND SQL against platforms that do not support COMPOUND SQL.
I do not have a VM system at the moment to run tests, but need to clarify
this.
Any comments or links ?
TIA
Jo