Seventeen Stars

select a table row value where equals to rows from file text .

hi,
I've got a delimited file with several rows and values (a normal one so), wherein for each value from the column "untel" I've got a "correspondante " value store in a As400 table
I've tried to use TfileDelimited => tAS400Row with a query : "SELECT FDEVIS.DEVNOLM FROM FDEVIS where row2.column0 = FDEVIS.NOPROSP" => and tFileOutputDelimited (or another table ... never mind)
but doesn't work !
I've red help content help but nothing with a value in entry ...
In "summary"(lol) :: read a (foreach) value => looks for equivalence in a table (select)=> write result !
Looks simple but need your help
by advance thanks a lot
8 REPLIES
Highlighted
Seventeen Stars

Re: select a table row value where equals to rows from file text .

... give you more "details" on my needs.
Is it enought explicit !?
Which Component to use in this case !?
Seventeen Stars

Re: select a table row value where equals to rows from file text .

Actually the only thing i got it's an iteration on the syntaxe Sql (System.out.println(((String)globalMap.get("tAS400Row_1_QUERY")))
with a request in AS400Row :
"SELECT FDEVIS.DEVNOLM FROM FDEVIS WHERE "+row1.NOPROSP+"=FDEVIS.NOPROSP"

for a result :
SELECT FDEVIS.DEVNOLM FROM FDEVIS WHERE 0000000482391=FDEVIS.NOPROSP
SELECT FDEVIS.DEVNOLM FROM FDEVIS WHERE 0000000440281=FDEVIS.NOPROSP
SELECT FDEVIS.DEVNOLM FROM FDEVIS WHERE 0000000460825=FDEVIS.NOPROSP
SELECT FDEVIS.DEVNOLM FROM FDEVIS WHERE 0000000431051=FDEVIS.NOPROSP
SELECT FDEVIS.DEVNOLM FROM FDEVIS WHERE 0000000509042=FDEVIS.NOPROSP
SELECT FDEVIS.DEVNOLM FROM FDEVIS WHERE 0000000431051=FDEVIS.NOPROSP
SELECT FDEVIS.DEVNOLM FROM FDEVIS WHERE 0000000504413=FDEVIS.NOPROSP
... etc

from an input file
NOPROSP
0000000482391
0000000440281
0000000460825
0000000431051
0000000509042
0000000431051
0000000504413
...etc

... but of course i need THE RESULT of "SELECT FDEVIS.DEVNOLM FROM FDEVIS WHERE 0000000482391=FDEVIS.NOPROSP" ...etc not the syntax (lol)
... any help !??
thanks
Seventeen Stars

Re: select a table row value where equals to rows from file text .

if I read "help Content" for tmysqlrow :
Le suffixe Row signifie que le composant met en place un flux dans le job bien que
ce composant ne produise pas de données en sortie.

... seems meaning " no output data for a txxxRow" !!
How can I catch those data so !? no with a tAS400Row !?
Seventeen Stars

Re: select a table row value where equals to rows from file text .

any idea or some informations ...!?
I've tried with filter Row but no sure it's the good one .
I'm just a little "lost" ...
++
laurent
Employee

Re: select a table row value where equals to rows from file text .

If you really don't want to use a tMap, you can do
tFileInputDelimited -> tAs400Row -> tParseRecordSet -> ....
Add a new object column in tAS400Row schema.
Define it in tAS400Row -> Advanced Settings -> Propagate QUERY RecordSet option.
and in tParseRecordSet to parse the results from tAS400Row "select" request.
HTH,
Seventeen Stars

Re: select a table row value where equals to rows from file text .

hi mhirt,
It it's possible with tMap .... I take it!
I've tried with your solution but always 's got some errors ...(a "red" alert like on your screenshoot).
So i've tried with tMap : get 2 entries (as400 input and tfileinput z value) => tMap ....
But now how to put my condition !? (select mytable.X from mytable Where mytable.y = z)
I've got all value to do my job but don't find the right way !!(sic)
My problem is to include the variable Z in the query !
With tparseRecord set, it propagate the result (if i 've unterstood the goal of this component) !
but a tmap solution can be the good one ...
EDIT : tparse error => (*** ERROR in Table ***); due to a bad request i guess because didn't recognize th value in my select query (!!?)
the entire java generated code error :
row3.NOPROSP = re_tParseRecordSet_1.getObject(*** ERROR in Table ***);
Employee

Re: select a table row value where equals to rows from file text .

You didn't configure properly the tParseRecordSet "Attribute table".
Verify it according to my last screenshot.
Seventeen Stars

Re: select a table row value where equals to rows from file text .

hi, mhirt,
Ok , now it's work fine !
You let me expexted that it could work with a tMap component as well !
Can you give me the way to do it with it ....(not entire solution, but the "suite of" component) .
I still have some "problems" with the passed value throws different component .
anyway, thanks a lot for your help
laurent