Multi-DBMS SQL :: PB specific tool to locate violations

[Former Member]

Hello All,

Every DBMS vendor has its own functions and unique SQL extensions that are invalid in another vendor's implementation

Is there a tool that finds and reports such occurrences in DataWindow and embedded SQL?

In the current specific case I am concerned about MSSQL and Oracle SQL compatibility

Thanks

[Former Member]

Hi Yakov

I'm not aware of any such tool, but it would be nice

I had a similar issue with SQL Server no longer supporting star joins, trying to find that syntax and fix it. Let see is someone comes up with a viable solution.

Cheers

David