Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only
  • 1.  Report-Extract Data from Multimember file

    Posted 06/15/22 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 06/15/22 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 06/16/22 03:02 AM

    Thanks Ann. I will check it.






    #Db2
    #Support
    #SupportMigration


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

    Posted 06/17/22 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 06/23/22 03:49 PM

    Hi,


    Are you on step 12 of the document?






    #Db2
    #Support
    #SupportMigration


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

    Posted 06/24/22 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 06/24/22 03:00 PM

    Hi,


    Please send an email to QU2






    #Db2
    #Support
    #SupportMigration