AnsweredAssumed Answered

BOARD 11 SQL titles not displayed in procedure step details

Question asked by Paul Wyatt - Avison Young UK on May 24, 2019
Latest reply on May 24, 2019 by tg_jbaetens

QUERY

Has anyone been able to display the SQL data reader details in DB Procedures?  

 

DETAILS

In re-writing a dataload procedure, I noticed that SQL data reader details are not shown and require the user to open the step but text file data readers (ascii) do display the title of the reader.  Image 1 below shows Steps 11 to 14 have no details but all contain SQL data readers.  Step 15 is a text reader step for which the title of that reader is clearly displayed in the details column.

 

WORKAROUND

If this is an oversight, I will have to use the comments to manually type in each SQL reader routine title.  Whilst this is a bit of a bind and a duplication of effort, at least the comments are now directly accessible and don't require the steps to first be opened in order to see what's inside.  However, for speedy error checking and development, it is essential that I can see at a glance where my readers are called.

 

Image 1: BOARD 11 Procedure showing SQL and ASCII data reader steps.

Outcomes