×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Yes, I checked the journal and determined the UPDATE is the problem. The programs are basically services that feed data to clients. The clients are passing back data for the update, and the clients are dropping off the identity column.
I already have an update trigger, so I patched this there. I'm still shocked the Db2 allows me to wipe an identity column.
RFE:
https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=116091
-----Original Message-----
From: Rob Berendt [mailto:rob@xxxxxxxxx]
Sent: Wednesday, February 07, 2018 8:06 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: Identity value of 0
Well, I would question as to why it would override the update with 0.
Shouldn't it have put what was in the READ?
Are you really doing a WRITE, followed quickly by an UPDATE in your logic or are you basing that on what you are seeing in the journal entries? Not to be a stupid question as you are probably more familiar with the program logic, but I did hear you mention the journal entries...
Are you doing a READ in between the WRITE and the UPDATE?
This may be a time to use %FIELDS. Or to create an RFE to somehow handle not updating GENERATE ALWAYS columns.
Rob Berendt
midrange.com
