//Create the connection
 string cacheString =
 "Server=localhost;Port=1972; Log File=c:\\MVTutorial.log;Namespace=MYACCOUNT;" 
 + "Password=SYS;User ID=_system;";
  cnCache = new CacheConnection(cacheString);

  //Open the connection
  cnCache.Open();

  //Create and execute the update
  String sql = "UPDATE MVFILE.PERSON (AGE,PHONE) VALUES" +
  " ('41','111-111-1111,222-222-2222') WHERE NAME='IDLE,JIM'";
  CacheCommand command = new CacheCommand(sql, cnCache);
  int rows = command.ExecuteNonQuery();
           
  //Display the number of affected rows
  Console.WriteLine("rows {0}", rows);
            
  //Close the connection
  cnCache.Close();