Neil Lunn writes:
> > From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
> >
> > You sure that's an ANSI SQL statement. Looks like a
> > procedure. I am not
>
> Yes it's a Transact SQL statement. Should work directly against Sybase as
> well but it's not valid ANSI SQL.
>
> Either it needs to be translated through to Perl acting on a result set
> (client) or act as a stored procedure (server).
Well - IMHO it should still work. This query should only return one
result set, and DBD::ODBC and/or DBD::Sybase should just send that
statement to the server for execution.
Michael
--
Michael Peppler - Data Migrations Inc. - [EMAIL PROTECTED]
http://www.mbay.net/~mpeppler - [EMAIL PROTECTED]
International Sybase User Group - http://www.isug.com
Sybase on Linux mailing list: [EMAIL PROTECTED]