Topic
  • 1 reply
  • Latest Post - ‏2013-04-24T15:57:53Z by David.Zhu
SystemAdmin
SystemAdmin
1632 Posts

Pinned topic Data Studio 3.1.1 - Clean up Routine Preferences and Settings

‏2013-03-12T23:26:56Z |
Hello,

Can anyone help me with option for clearing up the settings and preferences for a stored procedure that is debugged once thru Data Studio. Here is my situation.

1. Created a new native SQL procedure (4 parameters) and deployed and ran couple of debug using routine editor / data project explorer.
2. Dropped the stored procedure and created a new one with same name and additional output parameters (10 parameters) and deployed successfully.
3. When Debug is initiated thru Data Source explorer, Schema > Stored Procedures, it is picking up the old settings (parameter list) and failing
{? = CALL schema.SP_TEST(?,?,?,?)}
NO AUTHORIZED PROCEDURE NAMED schema.SP_TEST HAVING COMPATIBLE ARGUMENTS WAS FOUND. SQLCODE=-440, SQLSTATE=42884, DRIVER=4.13.111
Run of routine failed.
- Roll back completed successfully.

So, my question is how can clear the settings for a stored procedure when it is being dropped or recreated.

Thanks
  • David.Zhu
    David.Zhu
    67 Posts

    Re: Data Studio 3.1.1 - Clean up Routine Preferences and Settings

    ‏2013-04-24T15:57:53Z  

    You can try to remove the files in the <your workspaces>\.metadata\.plugins\com.ibm.debug.spd\* .