Powerbuilder using ODBC connection
Working on project to convert Powerbuilder application working with Microsoft
SQL server to DB2.
Is there anyway arround changing the syntax of SQL statements. I am having
to change strings that are inclosed in double quotes
Emp_Status = "ACTIVE" to EMP_Status = 'ACTIVE'
and date comparisions
Date = "12/31/2999 to Date = '12/31/2999'
there is also problems with the syntax of inner joins
*= and =* having to convert to the ansi standard
There is a lot of existing code and I was hopeful some magic bullet existed
(like some parameters in a odbc driver that would take care of this.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL