Does anyone have an example of an Inbound Database channel using Block Size

[former_member247972]

Does anyone have an example of an Inbound Database channel using Block Size.

In the retrieval detail above, the query is limiting the selection to 100 rows but the block size is 10.  The inbound message still shows 100 rows and no blocking.

Any clues?

Tom Arnold

[former_member247972 · Accepted solution]

It took a bit but, I believe I found the solution.  The below example is in HANHA.

The Retrieval Statement is as follows:

select top $Top

*

from

(

select

t0."ItemCode",

t0."ItemName",

row_number() over (order by t0."ItemCode") as "RowNum",

$BlockNo as "BlockNo"

from

"OITM" t0

order by t0."ItemCode"

) t0

where

t0."RowNum" > $BlockNo

Note the following $ keywords and their use:

$Top - equivalent to the Block Size

$BlockNo - the value of the last row number processed.  (0, 10000, 20000....)