CA Datacom CADRE

Expand all | Collapse all

Need your feedback -- SQL development plans

  • 1.  Need your feedback -- SQL development plans

    Posted 04-03-2019 11:17 AM
    Datacom Community members,
    We in Datacom Development are having additional discussions to plan and prioritize work for CA Datacom SQL in the weeks and months ahead.  We'd really value your input as we make decisions in the next couple of weeks or so.  What items are most important to you?  Here are some categories:
         Additional scalar functions
         OLAP functions
         GROUP BY extensions (GROUPING SET, ROLLUP, CUBE)
         Other SQL syntax (what?)
         Improvements to the SQL Monitor
         Performance improvements to SQL query execution
         Education on SQL query tuning
         Other (what?)
    Suggestion:  If you're not an application developer, ask a developer at your site for their opinion and provide that.  Better yet, ask that developer to join our Community, and both of you can give your feedback.
    RequestCould I please ask you to respond with your feedback -- as many of you as possible -- by the close of business on Thursday, April 18th?
    Feel free to comment if what has been said by others triggers additional thoughts with you. Let's have a good discussion here!
    And thanks again for letting us know what would be most valuable to you and your shop!
    Product Owner | Mainframe Division
    Broadcom


  • 2.  Re: Need your feedback -- SQL development plans

    Posted 04-12-2019 12:41 PM

    Hello,

    We have a couple of items for your discussion. 

    We noticed that calling a stored procedure creates and disposes of a subtask which each call. Performance issues prohibit the use of stored procedures for tasks that would call one regularly.

     

    We develop PHP and .NET programs using SQL through CA Datacom's ODBC driver for VSE. Development of this driver for VSE seems to have halted at version 11. Are you planning to include the drivers in the SQL discussion?

     

    Thanks,

    Maria