1. Samuel Schimitzek
  2. PowerBuilder
  3. Wednesday, 11 September 2019

Hello,

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)?

Thanks

 

 

John Fauss Accepted Answer Pending Moderation
0
Votes
Undo

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.

Comment
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
There are no comments made yet.
  1. Wednesday, 11 September 2019
  2. PowerBuilder
  3. # 1
  • Page :
  • 1


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