DB Inbound – Fail to convert resultset to row set

[Peter Heggie]

I am using a DB Inbound protocol and using a SQL statement, not a stored procedure. The SQL is a SELECT. The format is SELECT tablename.columnname, tablename.columnname, ……. WHERE tablename.columnname = ‘value’.

The invocation returns “Fail to convert resultset to row set:Index: 123, Size: 123”. What part is the resultset and what part is the row set? I am selecting specific columns, why would that cause some kind of indexing / number-of-items problem?

 

Peter

Peter Heggie
PeterHeggie@crouse.org

Topic

[Jim Kosloskey]

Peter,

I am curious if you tried this select outside of Cloverleaf (with something like DB Analyzer)?

If so, did that return multiple elements in the result set? Are you configured to handle multiple elements in the result set?

If you are configured for multiple elements in the result set, how is that configuration defined?

Jim

email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 60 years IT – old fart.

[Ramachandran R]

Dear Peter,
Please confirm if you have tried using select statements without table schema selected in the database inbound protocol properties? Thank you.

[Author]

Replies