Question Re: table Params in Procedure in Technology Q&A

table Params in Procedure

former_member1203898 — Sun, 20 Mar 2022 21:43:54 GMT

Good day ,

I have stumbled over a point when creating a procedure that makes me very curious in connection with the manual.

The parameter type table .. table(value varchar(24))

CREATE PROCEDURE Test
   @list table(value varchar(24)) out
as
...

I can't find any information about it but it is still functional.

Am I missing the description? Is this simply undocumented in SAP Adaptive Server Enterprise 16.0 ?

Andre

Re: table Params in Procedure

jerryjanda — Sun, 20 Mar 2022 21:44:40 GMT

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members. Feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html as well, as that will help you when submitting questions to the community.

I also recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

Kind regards,

--Jerry

Moderation Lead

Re: table Params in Procedure

Mark_A_Parsons — Sun, 20 Mar 2022 22:29:49 GMT

Where did your example code come from? If from one of the manuals ... which manual?

Re: table Params in Procedure

Mark_A_Parsons — Sun, 20 Mar 2022 23:02:58 GMT

ASE 16 SP02 introduced the table type.

You can define it 'inline' (as demonstrated in the question) or as a user-defined datatype via the create type command.

You can also declare variables as table variables.

Unfortunately documentation quality took a nosedive when ASE 15 came out and SAP has continued this decline in documentation quality with ASE 16. Net result is the manuals are typically lacking in exhaustive and/or useful examples for the new(er) features so you're left to your imagination when constructing a syntactically correct command.

Re: table Params in Procedure

former_member1203898 — Mon, 21 Mar 2022 10:27:07 GMT

This example is not taken from a manual. What surprises me is that there is no documentation for this type in the manual.

Re: table Params in Procedure

former_member1203898 — Mon, 21 Mar 2022 13:09:31 GMT

Thank you,

i rely so far on the infocenter to have documentation. But it looks like it is not as up to date as help.sap .

https://infocenter.sybase.com/help/topic/com.sybase.infocenter.help.ase.16.0/doc/html/title.html

Andre

Re: table Params in Procedure

ChrisBaker — Wed, 23 Mar 2022 20:10:49 GMT

Documentation for current releases is only available on help.sap.com.

https://help.sap.com/viewer/product/SAP_ASE/16.0.4.1/en-US

Chris