Consultor Eletrônico



Kbase 19224: Updating DB2/400 Dataserver Created Databases With Apptivity
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   15/10/2008
Status: Verified

FACT(s) (Environment):

Progress/400
Progress 8.0C

SYMPTOM(s):

The issue was found in 8.0C60

Databases updates is being done with Apptivity

DB2/400 Database created via Progress/400 Dataserver

Word index causes ADD and UPDATE operation(s) from non Progress SQL applications like; AS/400 SQL, MSQuery with Client Access using the IBM ODBC DRIVER, Apptivity using the JDBC-ODBC bridge, to fail.

The following errors message is received when using MSQuery is updating db.

MCH3401 - Cannot resolve object #SYSUTIL. Type and Subtype
x'0203' Authority X'0000'.

The following errors message is received when using Apptivity is updating db.

Updates not allowed on dsCust,No Unique Row Identifier
or Primary Keys, not updatable, changes canceled.

CAUSE:

Known issue.

FIX:

Workaround is to add the Progress/400 install library to the library list