-
1. Re: How to read multiple record from a database table
Neeraj Upadhyay May 24, 2016 4:59 PM (in response to scuser16967)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
scuser16967 May 25, 2016 6:57 AM (in response to Neeraj Upadhyay)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
-
3. Re: How to read multiple record from a database table
scuser16967 May 26, 2016 9:38 AM (in response to Neeraj Upadhyay)Any tips on this?
-
4. Re: How to read multiple record from a database table
acervantes May 26, 2016 12:56 PM (in response to scuser16967)Hi sparsh parimoo,
You can try with SQL overide statment, in other case, can you explain a little more or maybe with an example?
-
5. Re: How to read multiple record from a database table
Uma Ashok May 27, 2016 12:06 AM (in response to scuser16967) -
6. Re: How to read multiple record from a database table
Scott Nelson Sep 18, 2017 8:30 AM (in response to Uma Ashok)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