1. Jeyakumar Chinnapillai
  2. PowerBuilder
  3. Wednesday, 17 October 2018 07:03 AM UTC

Does PowerBuilder 2018 support Stored procedures with Table-valued parameter?

Accepted Answer
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 17 October 2018 13:23 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Jeyakumar;

     PB treats SP's like any other method or RDC and just expects input parameters based on standard data types as defined by the ANSI DB standards.Since Table-Valued is not an ANSI standard and more DBMS specific - PB does not support these features (ie: Non-ANSI standard).

     Within the SP however, you are most welcome to use Table-Valued arguments that include SP input arguments in your actual SQL Server SP's. That does not break the ANSI SP I/O standard but still allows you to use specific DBMS features within the SP itself.

HTH

Regards ... Chris

Comment
  1. Jeyakumar Chinnapillai
  2. Thursday, 18 October 2018 06:28 AM UTC
Thanks Chris!
  1. Helpful
There are no comments made yet.


There are replies in this question but you are not allowed to view the replies from this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.