topic Re: About AS400 Relative-Record-Number in Qlik Replicate

About AS400 Relative-Record-Number

iti-attunity-sup — Wed, 23 Apr 2025 07:29:41 GMT

Hi team

I have the following questions:

1.Is it possible to get Relative-Record-Number of AS400 by AR_H_STREAM_POSITION of Qlik Replicate?

2.Is there any header or variable to output Relative-Record-Number other than AR_H_STREAM_POSITION?

I would like a primary response by 2025.4.25.

Re: About AS400 Relative-Record-Number

john_wang — Wed, 23 Apr 2025 14:25:46 GMT

Hello Team ITI, @iti-attunity-sup

There is an option Add RRN column to all tables in the DB2i source endpoint:

so far you can get RRN easily.

Hope it helps.

John.

Re: About AS400 Relative-Record-Number

iti-attunity-sup — Thu, 24 Apr 2025 00:45:29 GMT

Hi John,

What if I don't want to add it as a column, but only want to use the value in the transform?

Best Regards,
Shohei.

Re: About AS400 Relative-Record-Number

john_wang — Thu, 24 Apr 2025 15:57:03 GMT

Hello Shohei, @iti-attunity-sup

There are no header columns that contain the RRN values. You can certainly remove the RRN column from the transformation columns list if it’s not needed in the target. However, you can still use it within the transformation logic if required.

Please see below for the expression I used and the corresponding sample result in the SQL Server target.

The expression is: 'KIT400K RRN IS ' || $RRN || '#'

The results in target table:

Hope this helps.

John.

Re: About AS400 Relative-Record-Number

iti-attunity-sup — Wed, 30 Apr 2025 05:38:22 GMT

Hi John,

Can the RRN columns be removed by global transformation?

Best Regards,
Shohei.

Re: About AS400 Relative-Record-Number

john_wang — Thu, 01 May 2025 02:23:56 GMT

Hello Shohei, @iti-attunity-sup

Removing RRN columns in Global Transformation means you need NOT it. then you can suppress RRN in Endpoint setting:

If you still need the RRN in some expressions but you want to remove it from all target tables, then Global Transformation "Drop column" can be used to remove it:

Regards,

John.