How to add iSeries journal columns to Change Data tables

[EricC_BI_Developer]

We need to add the sequence number and timestamp from the iSeries DB2 journals to the Change Tables.  My guess is Global Transformations is the place to do it (via Add Column) but I only see Attunity related columns in it.  Any ideas on how to add entry_timestamp and sequence_number to the __ct tables?

[Madhavi_Konda]

Hi,

Did you explore AR_H_TIMESTAMP,AR_H_COMMIT_TIMESTAMP and AR_H_CHANGE_SEQ replicate predefined columns
which you can use for your own variables(timestamp and sequence_number) in global transformations?

Thanks,
Madhavi

[EricC_BI_Developer]

Hi Madhavi, yes I tested AR_H_CHANGE_SEQ as a computed expression in a global transformation but it is the same value as already provided in header__change_seq.  I've looked through everything else in the Expression Builder and don't see any other options for getting the original journal seq # from the iSeries journals.  

Any other ideas are much appreciated.

Thanks, Eric

[Madhavi_Konda]

Hi Eric,

As you are using change tables on the target, header_stream_position and header_timestamp are the predefined fields that you can use it for your purpose without having any global transformations.

Thanks,
Madhavi

[EricC_BI_Developer]

Header__timestamp isn't what I need because it contains the Qlik/Attunity version of the timestamp, not the original one from the iSeries journals. 

I'm trying to find out if the original iSeries DB2 journal timestamp and sequence values are available in the Task so they can be written to the change tables.  Are they?

[Madhavi_Konda · Accepted solution]

Hi Eric,
You need to adjust header__timestamp(transaction entry_timestamp into the journal) as this is in UTC timestamp format(need to change according to your local timezone).
header__stream__poistion will give you receiver_library:receiver_name:journal change_seq

If you are still not satisfied and would like to have working session, Please open a support ticket in the support portal https://attunitysupport.qlik.com/login?ec=302&startURL=%2Fs%2F.

Thanks,
Madhavi