InfoSphere Optim

 View Only
  • 1.  Optim Archive support for DB2 Left join functionality

    Posted Tue July 13, 2021 04:52 PM
    We have the need to be able to put left join functionality within the sql for a number of archive modules we are developing for DB2 mainframe.  It does not look like Optim supports this. 

    IBM - Does it support Left joins?  If not, is it on the roadmap?

    Others - How have you gotten around this deficiency?

    Thanks,

    Phil​

    ------------------------------
    [Phil] [Neff]
    [Expert Infrastructure Architect]
    [J.B. Hunt Transport]
    [Lowell] [AR]
    ------------------------------

    #InfoSphereOptim
    #Optim


  • 2.  RE: Optim Archive support for DB2 Left join functionality

    Posted Tue June 07, 2022 12:33 PM
    Hi Phil,


    Did you get any solution for this? Any idea how to use the inner joins or left joins with IBM optim.

    Thanks,
    Kajal

    ------------------------------
    Kajal Bonde
    ------------------------------



  • 3.  RE: Optim Archive support for DB2 Left join functionality

    Posted Tue June 07, 2022 01:37 PM
    Nothing from IBM.  Not suprised.  Every time I asked about new functionality they always said not on their roadmap.  So I quit asking.

    Phil

    ------------------------------
    [Phil] [Neff]
    [Expert Data Architect]
    [J.B. Hunt Transport]
    [Lowell] [AR]
    ------------------------------