Journal Sequence number - Connect_CDC - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

Method: Journal Sequence Number

Function name: rowjrnlseqno

Parameter list: none

Return type:   CHAR

What the method does: The implied input is the current data row. For the current data row being processed this method returns a 20 digit number in character format (with left-filled zeros) that is the sequence number of the System i5 journal record from which the data in the data row is derived.

For example, if the number of the journal record is "123456"; then this method will return the value, "00000000000000123456." Note, that this output is a character string. If you want this value to be output as a number, then you could code it as follows, "tonumber(rowjrnlseqno());"