[resolved] Put a result into context variable

[Anonymous]

Hi !
I have a query which gets the maximum enumerator from a AS400 table (select max(xxxx) from ...). After that, I would like to put this value into a context paramter.
Have you got and idea ?
Thanks a lot.
Kim

[c0utta · Accepted solution]

Hi Kim,
Since the result of "select max(xxxx) from ..." will only return one row, use a tJavaRow (or tPerlRow) after the t*Input.

context.count = input_row.count

Cheers,
c0utta

[Anonymous]

Thanks a lot !
It works fine 😉
kim

[Anonymous]

Hi, everyone!

I have a context variable RowCount, and I need to write javacode  which will input row count into this variable.

this code doesn't work:

context.RowCount = input_globalMap.put("tFileRowCount_1_COUNT");

Can u help me ?