trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Selva Govindarajan <>
Subject RE: Rowsets in Trafodion
Date Wed, 24 Jan 2018 16:38:39 GMT
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.


-----Original Message-----
From: Suresh Subbiah [] 
Sent: Wednesday, January 24, 2018 6:19 AM
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

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

On Tue, Jan 23, 2018 at 10:48 PM, Dave Birdsall <>

> 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/
> Thanks,
> Dave
View raw message