Will ibmda400 support data shaping

[Guest.Visitor]

I recently experimented with trying to use ibmda400 in conjunction with the MSDataShape provider. It failed with the message ... Cannot do Relate, Compute By, or Sort operation on column(s) whose key length is unknown or exceeds 10k. Did it fail because I did something wrong or because ibmda400 ado just doesn't work in conjunction with MSDataShape? If data shaping doesn't work now can I hope that it might work in a future release of ibmda400? If so when is that likely to happen? For reference the following is a code snippit from the failed code... ShapeCn.Provider = "MsDataShape" ShapeCn.Open "DATA PROVIDER=ibmda400;" _ & "DATA SOURCE = qmfpoer1" MySQL = "Shape {Select * From taxdta.txpfclnt Where cmclnt = 14088} " _ & "Append ({Select * From taxdta.txpfprop} As Properties " _ & "Relate cmclnt To pmclnt)" MyRS.Open MySQL, ShapeCn, adOpenKeyset, adLockReadOnly Bill Hamaker

[Guest.Visitor]

Bill, I don't know any thing about data shaping, but I gotta believe that your SQL statement is not what you mean to do. Do you -really- want every field from the tables to be selected for this analysis? (That's what Select * means.) If not, then I would try just specifying the pertinent field names in the Select statement. Bill

[Guest.Visitor]

The example SQL wasn't for a real application, it was just a quickie test SQL statement I put together to test to see if the technology worked. Replacing the * with a particular list of fields doesn't get rid of the error message. For your reference data shaping is a new feature that Microsoft created as part of their ADO specification. It's their attempt to expand SQL so that it can return hierarchical record sets in addition to just flat tables.

[Guest.Visitor]

I looked up Data Shaping in MSDN, I guess you are doing it correctly - so I guess it must be a deficiency in the CA Driver. Bill