Does it work from DB2 Command center... Scott Lemieux 16.Sep.03 01:44 PM a Web browser LC LSX Lotus Connectors - All ReleasesiSeries
Hi David,
This might be a nieve question, but have you run the join query successfully from a DB2 Command window (or other query tool)? Also, are you using the LSX's connection.Execute method to perform the query or builing your query via a LCFieldList and the connection.Select method? If you are not using the Execute method I suggest writing a [simple] test script that connects to DB2, runs the query and the Fetchs through the result set counting the records.
Scott