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.

 

[TomSark]

You should refer to the ANSI 92 standard for SQL and ensure that your SQL conforms to this standard, and, make sure that it fully works on both server s after verifying that it conforms... there is no 'compiler' for SQL Server that allows you to do this...

Tom Davis
tdavis@sark.com

http://www.sarkdallas.com

 

[Orbt]

Thanks Tom,
I was hoping I wouldnt have to do it that way. Was looking for a compiler that was ANSI 92 compliant only. It would then tell me I had errors on line x. You know, the "automated" (or lazy) man's approach.

Matt Jones
WSRC
matthew.jones@srs.gov

 

[neamtu]

use

SET FIPS_FLAGGER FULL

this it will tell you when your queries don't follow the
SQL 92 exactly

 

[TomSark]

Yes, the FIPS_FLAGGER will enforce ansi compliance... I completely forgot about it...

Thanks neamtu for helping an old man out...
Tom Davis
tdavis@sark.com

http://www.sarkdallas.com