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.