You are not logged in.
I have a input file delimited in entry with some column (14) ; I've to "extract" value from the thirth column ; select a value in a table where tableValue = column3.value ; get the result and write all result in another table ( .... )
right a little screenshoot.and more explanation :
make : select with tRow :
"select distinct devnolm from jmvbib.fdevis inner join jmvbib.facadh on facnopros1=" + row1.PDPADH + " and facnopros1=noprosp and devnolm>0"
and propagate result with tParseRecord Set ; after that map the throws Tmap to table As400 output
and got exception :
Exception in component tParseRecordSet_1 java.sql.SQLException: An undefined column name was detected. at com.ibm.as400.access.JDError.throwSQLException(JDError.java:389) at com.ibm.as400.access.JDError.throwSQLException(JDError.java:366) .......
work fine when I just match the resultset (without "propagate other value")
I have also try with 2 entry for the same file : one to match te resultset value and one for the 13 other column' values.
But the 2 entries don't work on the same time .
Normally I 've to have the solution for tonight ..so
If anyone could help me ... thanks a lot
Last edited by kzone (2008-12-15 16:58:08)
other way I've try to "synchronize" entry twice from the same tinputFile
And what means "lookup" in this case !??
Last edited by kzone (2008-12-15 17:25:35)
If I had red documentation more carefully ....
in fact it was "so" simple : with a request in the As400 input
"select distinct int(NOPROSP) as noprosp, max(DEVNOLM) as DEVNOLM from fdevis inner join facadh on fdevis.noprosp=facadh.facnopros1 group by INT(NOPROSP)"
and a "outer join" in the tMap shema
I was realy in the wrong way ...
Last edited by kzone (2008-12-16 15:14:19)