×
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.
Collect before and after images
create schema rob130410
CREATE TABLE ROB130410/TEST (MYKEY INT not null
generated always as identity,
MYDATA CHAR (5 ) NOT NULL WITH DEFAULT, PRIMARY KEY (MYKEY))
INSERT INTO ROB130410/TEST (MYDATA) VALUES('A')
update rob130410/test
set mydata='B'
where mykey=1
dspjrn rob130410/qsqjrn
<just showing you the results of that last update>
Sequence Code Type Object Library Job Time
28 R UB TEST ROB130410 ROBS1 13:55:48
29 R UP TEST ROB130410 ROBS1 13:55:48
I hit the function key to display hex
Type . . . . . . . . : UB - Update, before-image
Entry specific data
* . . . + . . . . 1
'00000001C140404040'
Type . . . . . . . . : UP - Update, after-image
Entry specific data
* . . . + . . . . 1
'00000001C240404040'
Rob Berendt
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
