Re: [Fwd: DBD::AnyData & dbish]

On Fri, 2006-01-06 at 10:17 -0800, Jeff Zucker wrote:
> Scott T. Hildreth wrote:
>
> >I am missing something here (probably a few brain cells),
> >how do I set up the dsn for DBD::AnyData (fixed format)
> >when using dbish?
> >
> >
> Well, it's rather messy because dbish's execution of perl is a bit
> messy. But it works fine. Try this:
>
> 1) start dbish like this:
>
> dbish dbi:AnyData:f_dir=./mydb
>
> 2) within dbish, issue a perl command to set the catalog for a table:
>
> $sh->{dbh}->ad_catalog('foo','Fixed','foo.db',{pattern=>'A1
> A7'}) /perl
>
> Then you should be able to access "foo.db" as a Fixed file as the table
> "foo" with the specified pattern. $sh is the DBI::Shell object that
> holds the current $dbh in an attribute. dbish does a string eval on
> everything in the command buffer preceding "/perl".
>
> Let me know if this works for you.

Jeff,
I meant to reply to you on Friday. This worked.

Thanks,
STH
>
--
Scott T. Hildreth