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(); } }