About AS400 Relative-Record-Number

[iti-attunity-sup]

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.

[john_wang]

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.

[iti-attunity-sup]

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.

[john_wang]

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.

Opens in new window

PDF Download

Word Download

Excel Download

PowerPoint Download

Document Download

[iti-attunity-sup]

Hi John,

Can the RRN columns be removed by global transformation?

Best Regards,
Shohei.

[john_wang]

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.