Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
5 replies Latest Post - ‏2013-04-05T03:55:14Z by TulasiDas
OptimDev
OptimDev
54 Posts
ACCEPTED ANSWER

Pinned topic Optim View error

‏2013-04-02T20:37:44Z |
Hello All,
I have created a view in a DB and trying to extract the same using Optim .Unfortunately the status of the view in optim is view error.Please let me know if there any limitations on Views accessibility in optim. If so please let me know the work around.
Thanks
Updated on 2013-04-05T03:55:14Z at 2013-04-05T03:55:14Z by TulasiDas
  • TulasiDas
    TulasiDas
    62 Posts
    ACCEPTED ANSWER

    Re: Optim View error

    ‏2013-04-02T22:53:15Z  in response to OptimDev
    Hi,

    Would it be possible for you to post the definition of the view?

    Thanks,
    Tulasi
    • OptimDev
      OptimDev
      54 Posts
      ACCEPTED ANSWER

      Re: Optim View error

      ‏2013-04-03T12:43:34Z  in response to TulasiDas
      Select
      test_copy.test_copy_ID,test_copy.Payment_ID,test_copy.cousin_Role_ID,test_copy.Provider_ID,cousin.Last_Name,test_copy.Address,test_copy.City,test_copy.State_Code,test_copy.Country_Code,test_copy.Zip_Code,test_copy.Recipient_Ind
      from cousin_role,test_copy,cousin
      where test_copy.cousin_role_id=cousin_role.cousin_role_id
      and cousin.cousin_id=cousin_role.cousin_id
    • OptimDev
      OptimDev
      54 Posts
      ACCEPTED ANSWER

      Re: Optim View error

      ‏2013-04-03T12:47:41Z  in response to TulasiDas
      Thanks for the quick response. I have used Inner join before and optim has thrown the same error.So i went ahead and changed the query to a where clause and it still did not work.Please let me know if there are any rules in creating a view so that optim can access it successfully.
      • OptimDev
        OptimDev
        54 Posts
        ACCEPTED ANSWER

        Re: Optim View error

        ‏2013-04-03T12:52:25Z  in response to OptimDev
        Just to add on, these views are working fine in the DB level
        • TulasiDas
          TulasiDas
          62 Posts
          ACCEPTED ANSWER

          Re: Optim View error

          ‏2013-04-05T03:55:14Z  in response to OptimDev
          Can give below details:

          1) Optim Version
          2) Which database and it's version

          If possible please attach Optim trace file