Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 22 Dec 2011 @ 09:09:16 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Unique syntax in sql {oj...}
From:   Anomy Anom

<-- Anonymously Posted: Thursday, December 22, 2011 03:23 -->

Hi Folks,

I came over this sql which although simple caught my attention because it had a syntax something like a {oj .... } as part of it. The sql is given below :

     { oj ((TAB1 A LEFT OUTER JOIN TAB2 B ON A.COL1 = B.COL1 )
           INNER JOIN TAB3 C ON B.COL2 = C.COL2 )
           LEFT OUTER JOIN TAB4 D ON C.COL3 = D.COL3 }
     A.SOMECOL = 'Active'

Does anyone know what the {oj .... } means ? this is the first time I have come across such a syntax.

Any clarification would be of great help


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016