ANSI Standard Compiler Needed

[Orbt]

Does anyone know of a compiler I can run scripts through to ensure ANSI Standards? We use SQL Server, but need to run the same scripts and stored procedures on Oracle 8i in the future. I need to locate the non ansi standard parts and "fix" them somehow.

 

[listener22]

Since you specifically want everything to work with Oracle,
you might be better off just testing on Oracle. My understanding
is that there are several versions, e.g. 8.1.7 for linux, that can
be downloaded from Oracle's site, or purchased on CD for a
nominal fee. It might not support your whole set of databases
and applications, but you could at least test sections of them. Jim

oracle, vb

 

[Orbt]

Thanks Jim,
We are working for a database independency. Basically, we want to make our scripts able to run on any dbms that supports ANSI SQL, not just Oracle. Since Oracle is one of the big hitters, I used it as on example. Sorry about the incomplete requirments, thus is the story huh!

Matt Jones
WSRC
matthew.jones@srs.gov

 

[vineetb]

We also need ANSI SQL standard compliance for our product so that it can work with any RDBMS like MS SQL Server, Oracle, Ingres, DB2, etc.
How can we write SQL which works across all these databases?.
We are running into issues like data-type conversion, table join syntax, etc.

- vineet

 

[pgulutzan]

You can download a DBMS from Ocelot (which I work for) from

http://ourworld.compuserve.com/homepages/OCELOTSQL/download.htm

It allows all syntax that is official SQL-92 standard and a few SQL-99 extensions. It disallows any syntax that is non-official-standard, even if it's a common extension like "CREATE INDEX". I warn that stored procedures are not official SQL-92 standard.
Peter Gulutzan
Ocelot Computer Services Inc.