1. Markus Schröder
  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.

  1. John Fauss
  2. Wednesday, 11 September 2019 13:48 PM UTC
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. 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.