Hi Dave, SQL statements with rowsets can be prepared from trafci, but we cannot execute them ssince we have not provided a way to sat array parameters from trafci/sqlci yet. To prepare we can use this syntax prepare s1 from insert into t1 values (?[10], ?[10]) ; Here 10 is the maximum size of input rowset.
We can test changes for rowset code using ODB. It uses rowsets to insert/upsert. I don't have a rowset for input JDBC example. I will look some more. Thank you Suresh On Tue, Jan 23, 2018 at 10:48 PM, Dave Birdsall <[email protected]> wrote: > Hi, > > Is there a way to use rowsets in Trafci? (Regression test executor/TEST015 > suggests that sqlci does not support rowsets.) > > Or must one write JDBC code to use rowsets? > > Are there examples of JDBC code that use rowsets for input? (I did find an > output example, in trafodion/core/conn/jdbc_type2/samples/ > JdbcRowSetSample.java). > > Thanks, > > Dave >
