Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Oracle 2 PostgreSQL

  1. How-to
0
Votes
Undo
  1. Gimmy Susan
    Gimmy Susan
  2. PowerBuilder
  3. Sunday, 1 December 2019 13:02 PM UTC
Good morning
 
I'm doing tests on how to convert a ns. application that works on Oracle to PostgreSQL.
In particular, I am checking the following settings:
 
 
What is the difference between: ANSI, ANSI_ESCAPE. PB ?
 
Example in PostGreSQL:
jo in ANSI_ESCAPE
  SELECT azazienda.aztoken,  
         afassofiscal.aftoken 
    FROM {oj afassofiscal LEFT OUTER JOIN azazienda ON afassofiscal.cdazie = azazienda.cdazie}  

jo in ANSI
  SELECT afassofiscal.aftoken,  
         azazienda.aztoken 
    FROM afassofiscal LEFT OUTER JOIN azazienda ON afassofiscal.cdazie = azazienda.cdazie  
 
jo inPB
  SELECT afassofiscal.aftoken,  
         azazienda.aztoken 
    FROM {oj afassofiscal LEFT OUTER JOIN azazienda ON afassofiscal.cdazie = azazienda.cdazie}
 
What is the difference between ANSI_ESCAPE and PB ? Look the same.
 
What is the difference between ANSI_ESCAPE and ANSI ?  it's just a matter of syntax? Which one is the best? Which one should you choose?
 
 
Example in Orale:
jo in ANSI_ESCAPE
unplanned option
jo in ANSI
  SELECT assofiscal.cdfisc,  
         azienda.cdazie 
    FROM assofiscal RIGHT OUTER JOIN azienda ON assofiscal.cdazie = azienda.cdazie 
jo inPB
  SELECT assofiscal.cdfisc,  
         azienda.cdazie 
    FROM assofiscal,  
         azienda 
   WHERE ( assofiscal.cdazie = azienda.cdazie (+))
 
 
Why is PB option different from Oracle and PostgreSQL?
If my application needs to be compatible with both databases, I have to choose ANSI ?
Is it just a jo problem?
 
thank you early for the answers
 
Gimmy
Bug reports - powerserver OR powerserver?! why two...
Web Service with PowerBuilder
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Sunday, 1 December 2019 15:06 PM UTC
  2. PowerBuilder
  3. # 1

Hi Gimmy;

   FWIW: The ANSI setting directs PB to use latest SQL standard. That's the setting that I always use if I can. 

Regards ... Chris

Comment
mike S
  1. mike S
  2. Sunday, 1 December 2019 17:11 PM UTC
yeah, i never understood what ANSI_ESCAPE actually did other than use very obscure syntax that is impossible to read. did anyone ever use that option? Of all the things that sybase could have spent time on, they chose that?



it should default to ANSI.



i would get rid of PB option entirely, same with ansi_escape.



does anyone use any settings other than ansi?
  1. Helpful
Michael Kramer
  1. Michael Kramer
  2. Monday, 2 December 2019 13:14 PM UTC
Hi Mike S, removing these options risks breaking code. But I agree, my advise any day is do ANSI only!

Ignore the other options as they exist solely to "keep legacy code intact".
  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.