I have several datawindows coming from an old application with graphic SQL written win Powerbuilder outer Join syntax (*= or =*). For example:
select student.name, student_email.email from student, student_email where student.id *= student_email.id
become with ANSI
select student.name, student_email.email from student left outer join student_email on student.id = student_email.id
Changing the connection parameters for outer joins from PB to ANSI i have see that if I open a DW with a simple outer join the syntax changes from PB to ANSI but I have to made any little modify for saving the DW.
Without savig the DW (and so I have also to recheck the Update Properties) the syntax does not change.
Is there any "automatic" way for changing the old PB outer join syntax to the ANSI without re-opening the DW's and save them ?
I'm working with PB 12.5 and SQL 2012 or 2014