odbtools/odbctest/mql/basic/37prepare_batch/11insert_data.mql

BEGIN BATCH

insert into /test/batch (v_varchar, v_text, v_int, v_bigint, v_float, v_double, v_smalldouble, v_bool) values (?, ?, ?, ?, ?, ?, ?, ? );
insert into /test/batch (v_varchar, v_text, v_int, v_bigint, v_float, v_double, v_smalldouble, v_bool) values (?, ?, ?, ?, ?, ?, ?, ?  );
insert into /test/batch (v_varchar, v_text, v_int, v_bigint, v_float, v_double, v_smalldouble, v_bool) values (?, ?, ?, ?, ?, ?, ?, ?  );
insert into /test/batch (v_varchar, v_text, v_int, v_bigint, v_float, v_double, v_smalldouble, v_bool) values (?, ?, ?, ?, ?, ?, ?, ?  );
insert into /test/batch (v_varchar, v_text, v_int, v_bigint, v_float, v_double, v_smalldouble, v_bool) values (?, ?, ?, ?, ?, ?, ?, ?  );
insert into /test/batch (v_varchar, v_text, v_int, v_bigint, v_float, v_double, v_smalldouble, v_bool) values (?, ?, ?, ?, ?, ?, ?, ?  );
insert into /test/batch (v_varchar, v_text, v_int, v_bigint, v_float, v_double, v_smalldouble, v_bool) values (?, ?, ?, ?, ?, ?, ?, ?  );
insert into /test/batch (v_varchar, v_text, v_int, v_bigint, v_float, v_double, v_smalldouble, v_bool) values (?, ?, ?, ?, ?, ?, ?, ?  );
insert into /test/batch (v_varchar, v_text, v_int, v_bigint, v_float, v_double, v_smalldouble, v_bool) values (?, ?, ?, ?, ?, ?, ?, ?  );
insert into /test/batch (v_varchar, v_text, v_int, v_bigint, v_float, v_double, v_smalldouble, v_bool) values (?, ?, ?, ?, ?, ?, ?, ?  )

END
/**
params("4006", "hello word 2003", 4006, 4006, 1.1, 1.1234567890123456, 1.123456, true,
    "40", "hello word 2003", 40, 40, 1.1, 1.1234567890123456, 1.123456, false,
    "400", "hello word 2003", 400, 400, 1.1, 1.1234567890123456, 1.123456, true,
    "74006", "hello word 2003", -4006, 4006, 1.1, 1.1234567890123456, 1.123456, false,
    "409", "hello word 2003", -40, 40, 1.1, 1.1234567890123456, 1.123456, true,
    "500", "hello word 2003", -400, 400, 1.1, 1.1234567890123456, 1.123456, false,
    "600", "hello word 2003", 370, 370, 1.1, 1.1234567890123456, 1.123456, true,
    "700", "hello word 2003", 580, 580, 1.1, 1.1234567890123456, 1.123456, true,
    "602", "hello word 2003", -370, -370, 1.1, 1.1234567890123456, 1.123456, true,
    "708", "hello word 2003", -580, -580, 1.1, 1.1234567890123456, 1.123456, true)
**/
;

/**
sleep(10s)
**/
;