One Star

[resolved] Put a result into context variable

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
1 ACCEPTED SOLUTION

Accepted Solutions
One Star

Re: [resolved] Put a result into context variable

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
2 REPLIES
One Star

Re: [resolved] Put a result into context variable

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
One Star

Re: [resolved] Put a result into context variable

Thanks a lot !
It works fine ;-)
kim