use strict;
use DBI;
use DBD::Sybase;

my $CX = <...database connection info...>

sub executeSelect {
  my($CX, $SQL, $params) = @_;
  my $resultset = [];

  # Get the database handle for the currently selected connection
  my $dbh = _getDBHandle($CX);

  my $sth = $dbh->prepare($SQL);

  my @params = @$params;
  for (my $I = 0; $I <= $#params; $I++) {
    $sth->bind_param($I + 1, $params[$I]);
  }
  $sth->execute();

  while (my @row = $sth->fetchrow_array) {
    push(@$resultset, \@row);
  }
  return $resultset;
}

###  MAIN  ###
my $SQL = qq(
  SELECT JobN, JobDescription, CustomerOrderN, BookedDate, DueDate, Quantity
    FROM OpenJob
   WHERE JobN = ?
ORDER BY DueDate desc);

my $params = [ 68104 ];

my $records = executeSelect($CX, $SQL, $params);