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.  Help/examples for testing stored procedures?

    Posted 11/02/20 07:58 PM

    Does anyone know where to find help and/or examples for testing stored procedures in Data Studio?

    I can create a test case and give it a set of values to test, and I see the tabs for 'Before Run', 'After Run', and 'Compare Results', which sounds like what I'm looking for, but can't find any specifics about how to make it work.

    Pressing F1 for Help, brings up a page with some vague information, and the link to 'Creating routine test configurations', tells me 'Topic not found...'

    Specifically, one of the tests I want to automate is where I have input parameters that get validated in the procedure, and if missing or invalid, returns an error code in an out parameter. But I can't figure out how to test an OUT parameter that returns the specific error code I'm returning for the test case.

    Has anybody else used the test framework, or can point me to some documentation?

    Thank you






    #Db2
    #Support
    #SupportMigration


  • 2.  RE: Help/examples for testing stored procedures?

    Posted 11/02/20 08:01 PM

    P.S. I have Data Studio version 4.1.3 installed.






    #Db2
    #Support
    #SupportMigration


  • 3.  RE: Help/examples for testing stored procedures?

    Posted 11/03/20 04:07 PM

    P.P.S. I came across DB2Unit testing framework, but seems specific to DB2 for LUW. I am working with DB2 for i (formerly AS/400), so I need tools that work on that platform.






    #Db2
    #Support
    #SupportMigration