Re: DBI with Oracle & Sybase

I am trying to write an app which connects to both Oracle and Sybase db's. I'm trying to write my app in a generic manner, so that it runs without needing databse specific code.
The speil about DBI claims you can write your code independantly of db and just change drivers.
I'm finding this is isn't 100% correct. I'm familiar with Oracle but new to Sybase.
It appears there are subtle differences in syntax and behaviour between Oracle and Sybase.
(For example use of quotes when inserting, and enabling disabling of constraints.)

I'm assuming that in many cases DBI is providing some insulation from database specific commands.
Ideally I'd like to know what the 'generic' commands are so I can use them in my code, and avoid db specific coding.

(I'm a bit sketchy here but:) As both databases conform to the Codd relational model and also comply with the SQL(92?) stadard there must be some commonality between them with achitechture, behaviour and commands which control them.
(a specific example would be how to disable a constraint in both Oracle and Sybase.)

A document that lists "what I can do" with DBI would be handy... A document listing commonality between DBD commands for Oracle and Sybase etc would be handy...
A document showing clever ways to get round the bloody annoying quirks of sybase would be handy...

But since I doubt I am that lucky that such a document exists... I wanted avoid writing the above novel... I just asked for docs and expected to skim/read them myself.

P

"Ron Reidy" <r_reidy_at_comcast.net> wrote in message news:3EEA5718.9090606_at_comcast.net...
> So what exactly are you looking for? Did you read the DBD::Oracle docs
> and the DBD::Sybase docs?
>
> ThePotPlants wrote:
> > Hi.
> >
> > Does anyone know of any useful resources/links for DBD commands for
Oracle &
> > Sybase?
> > (I have the Oreilly book (Programming the Perl DBI ) but have pretty
much
> > exhausted that already.
> >
> > Any help would be appreciated.
> >
> > Thanks
> >
> >
>
>
> --
> Ron Reidy
> Oracle DBA
>
Received on Sat Jun 14 2003 - 21:25:49 CDT