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.
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center