Beispiel #1
0
 db2client.query("call "+schema+"."+procedure+"("+"?".concat(Array(array.length).join(",?"))+")", array, function (err, rows) {
   if(err){
     cb(err, undefined);
   } else {
     db2client.close(function () {
       cb(null, rows);
     });
   }
 })
Beispiel #2
0
 db2client.query("select "+colStrList+" from "+ tableName+conditions, function (err, rows) {
   if(err){
     cb(err, undefined);
   } else {
     db2client.close(function () {
       cb(null, rows);
     });
   }
 })
	db.query(sql, function(err, rows, rs){
		//console.log(rows);
		var i=0;
		for (i=0; i<rows.length; i++) {
			console.log([
				i,
				rows[i]["foo"],
				rows[i]["bar"]
			].join(", "));
		}

		db.close(function(){
			console.log("close.");
		});
	});