[freetds] Newbie select question

Paul Key pkey at sghms.ac.uk
Wed Feb 23 07:18:18 EST 2005


Hi

I have built freetds and dbd:sybase on solaris and can access my 
database server using: the following.

Fine - but how can I retrieve data from one of these tables?  I can't 
find the code anywhere and the archives for this list are not searchable 
as claimed.

Thanks

paul

use DBI;

BEGIN {
        $ENV{SYBASE} = '/usr/local/freetds';
        $ENV{TDSVER} = '42';
      }

$data_source = "DBI:Sybase:ntws";
$database    = "test";
$username    = "xx";
$password    = "xxxxxx";

$dbh = DBI->connect($data_source, $username, $password) || die;
$sql_statement = "SELECT table_name " .
                            "FROM $database.information_schema.tables";
$sth = $dbh->prepare($sql_statement) || die;
$sth->execute || die;
while (($table) = $sth->fetchrow_array)
{
    print "Database $database contains table $table\n";
}
$sth->finish;
$dbh->disconnect;



-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.



More information about the FreeTDS mailing list