Toad World® Forums

Toad for DB2 LUW v5.6 b2567 - Procedure Parameters not Displayed When Called from Editor

When a stored procedure is first created (or recreated) and you call it from within the Editor for the first time, one of the first two forms (listed below) appears when using code-completion. After the first time being called only the third form (correct form) appears when using code-completion.

CALL DMA01WK.SSRS_DSSG_STORE_TRANSIT_VOLUME();

CALL DMA01WK.SSRS_DSSG_STORE_TRANSIT_VOLUME(DATE,DATE);

CALL DMA01WK.SSRS_DSSG_STORE_TRANSIT_VOLUME(‘P_START_DT’, ‘P_END_DT’);

Hi Richard,

I'm having trouble recreating the issue. Can you send me some screen shots and the DDL (or similar) for the procedure?

Here's what I see on the first try after creation

callproc.png

I cannot get it to occur again either in B2662, so I’m not going to pursue it at this time.

Thanks Adam.

Richard Chouanard, analytics consultant

DB2 Database Administrator

*Payment Operations Management/Float Datamart

*Ph: 480-724-2142

From: Adam Ririe [mailto:bounce-adamririe_906@toadworld.com]

Sent: Tuesday, February 25, 2014 6:36 AM

To: toaddb2beta@toadworld.com

Subject: RE: [Toad for IBM DB2 - Beta Discussion Forum] Toad for DB2 LUW v5.6 b2567 - Procedure Parameters not Displayed When Called from Editor

RE: Toad for DB2 LUW v5.6 b2567 - Procedure Parameters not Displayed
When Called from Editor

Reply by Adam Ririe

Hi Richard,

I’m having trouble recreating the issue. Can you send me some screen shots and the DDL (or similar) for the procedure?

Here’s what I see on the first try after creation

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for IBM DB2 - Beta
notifications altogether.

Toad for IBM DB2 - Beta Discussion Forum

Flag
this post as spam/abuse.