Creating a Perl Object

Install Perl and create a Perl object before installing the new Perl object into the SAP Sybase IQ database.

Prerequisites

Install ActivePerl 5.6.0 on the database server computer. The database server computer must be able to locate the Perl executable.
Install the DBI Perl module on the database server computer.
Install the DBD::SQLAnywhere driver on the database server computer.
On Windows, install Microsoft Visual Studio and configure your environment.

Task

Run Makefile.PL:
- From the SDK\PerlEnv subdirectory (Windows):
```
perl Makefile.PL
nmake
nmake install
```
- From the sdk/perlenv subdirectory (UNIX):
```
perl Makefile.PL
make
make install
```
Verify that the database server is able to locate and start the Perl executable:
```
START EXTERNAL ENVIRONMENT PERL;
```

Write Perl scripts that use the DBD::SQLAnywhere interface. Sybase recommends running Perl in strict mode:

#!/usr/local/bin/perl -w
#
use DBI;
use strict;
my $database = "demo";
my $data_src = "DBI:SQLAnywhere:SERVER=$database;DBN=$database";
my $uid      = "DBA";
my $pwd      = "sql";
my %defaults = (
     AutoCommit => 1, # Autocommit enabled.
     PrintError => 0  # Errors not automatically printed.
   );
my $dbh = DBI->connect($data_src, $uid, $pwd, \%defaults)
  or die "Cannot connect to $data_src: $DBI::errstr\n";
$dbh->disconnect;
exit(0);
__END__