create or replace and compile java source named "ODBCSample"
as
 public   class  ODBCSample {

	 public   static   class  resElement
	{
	String Town;
	 int  tns;
	
	resElement(String argTown,  int  argtns)
		{
		Town = argTown;
		tns = argtns;
		}
	}
	
	 public   static  resElement[] ODBCres()
		{
		String ODBCQuery = "SELECT Город, tns FROM `'Лист 2$'` where Город is not null and tns is not null";
		String ODBCSource = "SMPS";
		resElement[] resElArray =  new  resElement[ 200 ];
// Далее производим заполнение resElArray, ну и, соответственно возврат...