trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Suresh Subbiah <>
Subject Re: Rowsets in Trafodion
Date Wed, 24 Jan 2018 14:19:01 GMT
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

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

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message