SetAlias

Sets an alias name to a OZ server connection pool.

Prototype

void SetAlias(string AliasName)

Parameters

Reference

Use to get a connection from OZ server.

Example

function prepareStatementSample(){

   var con = OZCreator.GetBuiltInObject(OZBuiltInObject.DBCONNECTION);

   con.SetAlias("ozcar");

   con.Connect(true);

   var pstmt = con.PrepareStatement("select * from car where Maker = ? ");

   pstmt.SetParameter(1, "HYUNDAI");

   var rs = pstmt.ExecuteQuery();

   var meta = rs.GetMetaData();

   for(var i=0; i<meta.getColumnCount(); i++) {

       _DEBUG(i+"= column Name="+meta.getColumnName(i+1)+"type="+meta.getColumnType(i+1));

   }

   while(rs.Next()) {

       var data = "";

       for(var i=0; i<meta.getColumnCount(); i++) {

           data = data + rs.GetString(i+1) + ",    ";

       }

       _DEBUG(data);

   }

   rs.Close();

   pstmt.Close();

}