6 use Data::Dump qw(dump);
8 my $dbh = DBI->connect ("dbi:CSV:", "", "", {
17 my $sth = $dbh->prepare( $sql );
20 while( my $row = $sth->fetchrow_arrayref ) {
21 $data->{ $row->[0] } = $row->[1];
27 my $names = lookup( qq{
28 select Id, texteEN from "SymbolNames"
31 #warn "# names = ",dump( $names );
33 my $hints = lookup( qq{
34 select Id, texteEN from "SymbolHints"
37 my $types = lookup( qq{
38 select TypeId, TypeName from "DataTyps"
41 my $units = lookup( qq{
42 select Id, TexteEN from "UnitNames"
45 my $sth = $dbh->prepare( qq{
46 select * from "ComuInfos"
51 while( my $row = $sth->fetchrow_hashref ) {
52 my $hint = $hints->{ $row->{texteid} };
53 $hint =~ s/[\r\n]+/ | /gs;
54 printf "%-3d %02x %-27s %-15s %s %s [ %s ]\n",
57 $types->{ $row->{typid} },
58 $units->{ $row->{id} },
60 $names->{ $row->{texteid} } || $row->{symbolname},