I have been using this module, and there is really nothing to say beyond the
synopsis given in the README. It bolts the XML together as a big string and
returns it (ie not using the DOM or any other dependancies). Just check you
can make a regular connection using DBI before you use this.
I had specific issues with:
>Quoting rules are not quite correct.
>No way to name a result set other than by the query used.
>No support for specifying the character set in the XML (so non-standard
characters tend to get lost in the wash)
>No way to re-use an existing connection when invoking and XML_RDB session.
Also, take note:
>No support for multiple result sets from one query (for Sybase users)
>NULL fields disappear completely from the output.
>Incompatible with DBD::RAM (if you want to actually store your data as XML,
use this - DBD::XML_RDB is for reporting)
I don't know if any of this is of interest?
TIM
> -----Original Message-----
> From: Paul DuBois [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, April 23, 2001 3:18 PM
> To: Matt Sergeant
> Cc: Thirumalai, Radhika; [EMAIL PROTECTED]
> Subject: Re: DBIx-XML_RDB
>
> On Mon, Apr 23, 2001 at 03:06:32PM +0100, Matt Sergeant wrote:
> > On Mon, 23 Apr 2001, Thirumalai, Radhika wrote:
> >
> > > Can someone suggest me (any url / reference manual...) where I can
> find a
> > > working example of the perl module DBIx-XML_RDB? Thanks
> >
> > It comes with two scripts - sql2xml and xml2sql. They are the best
> > references it has.
> >
> > --
> > <Matt/>
>
> Just noticed this:
> ----------------------------------------------------------------------
> % sql2xml.pl
> Usage:
> sql2xls.pl {Options}
>
> where options are:
>
> Option ParamName ParamDesc
> -sn servername Data source name
> [-driver dbi_driver] Driver that DBI uses. Default is ODBC
> -uid username Username
> [-pwd password] Password
> -table tablename Table to extract
> -output outputfile File to place output in (excel file)
> [-db dbname] Sybase database name
> [-v or --verbose] Verbose output
> ----------------------------------------------------------------------
>
> Notice that it reports its name as sql2xls.pl and references excel in the
> usage
> message. Leftovers from some other script?
