Help for this page

Select Code to Download


  1. or download this
        my $dbh = DBI->connect( 'DBI:ODBC:ALIAS', $username, $password);
        my $stmt = $dbh->prepare('SELECT * FROM SCHEMA.TABLE');
        $stmt->execute();
        ...
    
  2. or download this
        my $type_ref =  $stmt->{TYPE};
        my $precision_ref =  $stmt->{PRECISION};
        my $scale_ref =  $stmt->{SCALE};
        my $colnames = $stmt->{NAME};
        my $nullable = $stmt->{NULLABLE};