Are you using expression transformation?
or do you want to obtain data from multiple tables/objects at once
Please provide more details
I'm trying to read multiple records from a single table. So far i've been able to get fields from a single record. I need to understand how to iterate through the logic and get all the records.
I was told that object lists/embedded guides provide this functionality. But so far i have been unable to identify exactly how this can be done.
Any tips on this?
Hi sparsh parimoo,
You can try with SQL overide statment, in other case, can you explain a little more or maybe with an example?
To expand on Uma's recommendation, the JDBC (and other database connectors) return the results as a list. If you reference the results in your process you will only get the first row of the list. You need to iterate through the list to access all rows.
Scott S Nelson