LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stunelson

Hi,
I have a scenario where I want to extract all records from all members within a PF - the PF can have any number of members. I can build the Member list using a DB Execute (with an iSeries/i5 CL Command) but what I am struggling with is passing the list of members as a parameter into a JDBC/ODBC Query/Execute node and retrieving all the records in each member.

Is this possible to do in LAE?

Thanks.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rboccuzzi

If I understand, I don't think you can create a list and pass it in the way you describe. You can do a JDBC Execute once for each member, using a bind syntax with one member per execution. You can also create a temporary table and load the data into the table and do a join and select the results, or you can do a select and pull all the data, and then do a lookup or join in the LAE to filter to what you need. Each of these has trade-offs based on the size of the data in the database, and the number of members being looked up.

Cheers
Rich

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stunelson

Thanks for the information Rich - would you be able to give me an example of the bind syntax for the JDBC Execute or an example graph that will achieve what you have outlined?

Thanks again,
Stu.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rboccuzzi

Sure, here you go (sorry about the delay!). This would need to be populated with your DB details (driver, url, etc), but it should give you the idea of how it works.

Cheers
Rich
Attachments:
Example of Bind.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stunelson

Hi Rich - I managed to resolve the issue by using LAE to issue a number of iSeries query commands and retrieving the data into LAE to perform the required analysis. Thanks for the example though.