-
1. Re: How to read multiple record from a database table
Hi Sparsh,
Are you using expression transformation?
or do you want to obtain data from multiple tables/objects at once
Please provide more details
-
2. Re: How to read multiple record from a database table
Hi Neeraj,
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.
Thanks
-
-
4. Re: How to read multiple record from a database table
Hi
You can try with SQL overide statment, in other case, can you explain a little more or maybe with an example?
-
6. Re: How to read multiple record from a database table
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.
HTH
Scott S Nelson
