1. Gimmy Susan
  2. PowerBuilder
  3. Thursday, 3 May 2018 11:04 AM UTC
Good morning.

I'm trying to convert an application from oracle db to the PostgreSQL db.
In the DW SQL we have some proprietary syntax that does not work in the destination db.

Is there a utility that checks DW sintax  to understand its compatibility with the db?
I remember something similar in some past PB edition. Am I wrong?

THY Gimmy
Accepted Answer
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 3 May 2018 14:06 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Gimmy;

    That is correct .. but, application SQL updating its still part of many of these commercial tools. The only issue is that the SQL has to be in the form that these tools can parse and of course, the PBSELECT format in the DWO's are not.

    I did write a utility to use to help people change or fine tune any DataWindow's SQL. The utility is called SqlXtract. SqlXtract will reconstitute the PBSELECT into normal SQL syntax that your app is using today and then output that in a text file. The text file can then be processed by these DML processing tools and then after being tuned and/or corrected, the resulting SQL can then be imported back into the DWO's.

    Maybe that is the App you were thinking of?

Regards ... Chris

Comment
There are no comments made yet.
René Ullrich Accepted Answer Pending Moderation
  1. Thursday, 3 May 2018 13:41 PM UTC
  2. PowerBuilder
  3. # 1

Hi Gimmy,

you may try the PB code analyzer but there is no version for PB2017. As far as I know there should be a check of SQL against database as part of the code analyze. If your datawindows were created with PB up to 12.5 it should work.

Or you write a simple application. You have to add the libraries withe the datawindows to check, scan the libraries for datawindow, use each datawindow in a datawindow or datastore, check for retrieval arguments and fill it for retrieve, do a retrieve and check for errors.

HTH.

Comment
There are no comments made yet.
Gimmy Susan Accepted Answer Pending Moderation
  1. Thursday, 3 May 2018 13:13 PM UTC
  2. PowerBuilder
  3. # 2
It seems to me that it was a program written in Powerbuilder used as an example together with APU, etc.
Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 3 May 2018 12:57 PM UTC
  2. PowerBuilder
  3. # 3

Hi Gimmy;

   As far as I can remember, PB never had such a feature. There are commercial 3rd party products out there that do SQL reverse engineering from on DBMS vendor to another.

Regards ... Chris

Comment
  1. Gimmy Susan
  2. Thursday, 3 May 2018 13:27 PM UTC
i have to convert dw not database.

  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.