how to judge one journal record is insert/update/delete operation for one table?

Question

Question

wx fg · Apr 21, 2017

hi

I want to find the journal records that indicate the insert/update/delete operation for my table. I can read the journal file but there is so many records and I want to know is there some method or property which can judge one journal record for insert/update/delete operation for my table?

thanks

Discussion (5)0

Log in or sign up to continue

Dmitry Maslennikov · Apr 24, 2017

Caché stores data from tables in globals in $listbuild format. So you can use $listget, to get value from the particluar column, but you should know number for your column.

1 0

Dmitry Maslennikov · Apr 25, 2017

command WRITE, outputs $listbuild in binary format, if you would use ZWRITE, it would show you $lb

I've just made variable from your output

USER>zzdump val

0000: 02 01 04 01 61 61 04 01 4A 4A                           ....aa..JJ
USER>zwrite val
val=$lb("","aa","JJ")

Just read the documentation and you will get everything needed to work with $listbuild

1 0

score 0 · Answer 1 · 2017-04-21T12:27:44-04:00

You can run the List query in the %SYS.Journal.Record class, using the 'Match' parameter to match for specific global names (based on your table). It is documented (with some examples) here.

score 0 · Answer 2 · 2017-04-23T02:48:29-04:00

thanks very much!

Now I can get the records by your answer, and I can get the old/new value for each record like this

w rs.Get("NewValue")

the output likes this, aa jj is the value of 2 columns in my table

my question is: How to split these old/new value to each column?

score 0 · Answer 3 · 2017-04-24T23:18:38-04:00

thanks! But rs.Get("NewValue") returns string not list

I convert it to list like this:

set columnValues= $EXTRACT(s,5,*) //remove the header
set delimiter=$CHAR(4)_$CHAR(1)
set columnCount= $LENGTH(columnValues, delimiter)
SET list=$LISTFROMSTRING(columnValues,delimiter)

Is there other better method for convert to list?