Help for this page

Select Code to Download

Select or download this

my $dbh = DBI->connect( 'dbi:AnyData(RaiseError => 1):' );
$dbh->func( 'sms', 'Tab', $file, 'ad_catalog');
...
$sth->execute( 'ACTIVE' );

return $sth->fetchall_hashref( 'System Number' );

Select or download this

System Number\tSystem Status\tSystem Duration
10001        \tACTIVE       \t600
10002        \tINACTIVE     \t0
10003        \tACTIVE       \t900
...