Db2

 View Only
  • 1.  Creating a report off a MEMBER of aFile

    Posted Wed August 24, 2022 08:54 PM

    Is there a way to create metadata of a member of a file...? if so how..

    Need to create report based on certain members and not *first






    #Db2
    #Support
    #SupportMigration


  • 2.  RE: Creating a report off a MEMBER of aFile

    Posted Wed August 24, 2022 09:07 PM

    You could create an SQL alias (CREATE ALIAS) for the file/member, then create a synonym from that alias.






    #Db2
    #Support
    #SupportMigration


  • 3.  RE: Creating a report off a MEMBER of aFile

    Posted Thu August 25, 2022 02:31 PM

    Hi,

    Please see the stored procedure approach outlined in this article: https://www.ibm.com/support/pages/sites/default/files/inline-files/$FILE/Members%20Only%20-%20No%20Problem%20with%20DB2%20Web%20Query.pdf

    Note that the screenshots are quite old, but the approach still works! If you need any help, please reach out to us at QU2.






    #Db2
    #Support
    #SupportMigration


  • 4.  RE: Creating a report off a MEMBER of aFile

    Posted Thu August 25, 2022 03:47 PM

    Thank You... will have a look at both suggestions..






    #Db2
    #Support
    #SupportMigration