Hi Dave, There is sample program at $TRAF_HOME/../conn/jdbcT4/src/main/samples/BatchSample directory. This directory also has README file containing the instructions to compile and run the program.
Selva -----Original Message----- From: Suresh Subbiah [mailto:[email protected]] Sent: Wednesday, January 24, 2018 6:19 AM To: [email protected] Subject: Re: Rowsets in Trafodion 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 >
