Db2

Db2

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  Report-Extract Data from Multimember file

    Posted Wed June 15, 2022 10:01 AM

    How to extract data from multimember file via parameter option. Report will generated for particular member giving in parameter option. Any lead for creation of synonym for multimember.






    #Db2
    #Support
    #SupportMigration


  • 2.  RE: Report-Extract Data from Multimember file

    Posted Wed June 15, 2022 02:51 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


  • 3.  RE: Report-Extract Data from Multimember file

    Posted Thu June 16, 2022 03:02 AM

    Thanks Ann. I will check it.






    #Db2
    #Support
    #SupportMigration


  • 4.  RE: Report-Extract Data from Multimember file

    Posted Fri June 17, 2022 05:19 AM

    As per document, uploading members name of file uploading from data source option via dynamic parameter. But in my 2.3.0 version there is no option of data source. Is i am missing anything to get the data source option. can anyone help on this.






    #Db2
    #Support
    #SupportMigration


  • 5.  RE: Report-Extract Data from Multimember file

    Posted Thu June 23, 2022 03:49 PM

    Hi,


    Are you on step 12 of the document?






    #Db2
    #Support
    #SupportMigration


  • 6.  RE: Report-Extract Data from Multimember file

    Posted Fri June 24, 2022 03:10 AM

    yes, on step 12. There is no option to select data source for values.






    #Db2
    #Support
    #SupportMigration


  • 7.  RE: Report-Extract Data from Multimember file

    Posted Fri June 24, 2022 03:00 PM

    Hi,


    Please send an email to QU2






    #Db2
    #Support
    #SupportMigration