private SQLRCursor getCursor()
{
if (_sqlrcur == null)
{
_sqlrcur = new SQLRCursor(_sqlrelaycon.SQLRConnection);
if (_sqlrelaycon._columnnamecase == "upper")
{
_sqlrcur.upperCaseColumnNames();
}
else if (_sqlrelaycon._columnnamecase == "lower")
{
_sqlrcur.lowerCaseColumnNames();
}
_sqlrcur.setResultSetBufferSize(_sqlrelaycon._resultsetbuffersize);
if (_sqlrelaycon._dontgetcolumninfo)
{
_sqlrcur.dontGetColumnInfo();
}
if (_sqlrelaycon._nullsasnulls)
{
_sqlrcur.getNullsAsNulls();
}
}
return(_sqlrcur);
}
public static void Main()
{
SQLRConnection con = new SQLRConnection("sqlrserver", 9000, "/tmp/example.socket", "user", "password", 0, 1);
SQLRCursor cur = new SQLRCursor(con);
cur.setResultSetBufferSize(5);
cur.sendQuery("select * from my_table");
Boolean done = false;
UInt64 row = 0;
String field;
while (!done)
{
for (UInt32 col = 0; col< cur.colCount(); col++)
{
field = cur.getField(row, col);
if (field != null)
{
Console.Write(field);
Console.Write(",");
}
else
{
done = true;
}
}
Console.Write("\n");
row++;
}
cur.sendQuery("select * from my_other_table");
public static void Main()
{
SQLRConnection con = new SQLRConnection("sqlrserver", 9000, "/tmp/example.socket", "user", "password", 0, 1);
SQLRCursor cursor1 = new SQLRCursor(con);
SQLRCursor cursor2 = new SQLRCursor(con);
cursor1.setResultSetBufferSize(10);
cursor1.sendQuery("select * from my_huge_table");
UInt64 index = 0;
while (!cursor1.endOfResultSet())
{
cursor2.prepareQuery("insert into my_other_table values (:1,:2,:3)");
cursor2.inputBind("1", cursor1.getField(index, 1));
cursor2.inputBind("2", cursor1.getField(index, 2));
cursor2.inputBind("3", cursor1.getField(index, 3));
cursor2.executeQuery();
}
}
