1. Samuel Schimitzek
  2. PowerBuilder
  3. Wednesday, 11 September 2019 09:38 AM UTC


for simple SQL Parsing we have been using the PFC SQL Parser (pfc_n_cst_sql).

Now we switched from Oracle Join Syntax (+) to ANSI Join Syntax (left outer join...).

Is there already a parser that can handle this (preferably in Powerscript)?




John Fauss Accepted Answer Pending Moderation
  1. Wednesday, 11 September 2019 13:43 PM UTC
  2. PowerBuilder
  3. # 1

Hi, Samuel -

The simple SQL parsing performed by the PFC's pfc_n_cst_sql object (the of_parse function) only parses the "FROM" clause in its entirety. It does not examine Join syntax. I've checked the code in the 2017 Release of the PFC.

Oops! After a more careful reading of your question, I see that this is why you are asking...Doh! I assume you are wanting to not have to manually inspect/change the SQL syntax in your app?
  1. John Fauss
  2. Wednesday, 11 September 2019 13:48 PM UTC
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.