IDS stored procedures

Posted in 2008

Georges Martin — Fri, 03 Oct 2008 17:46:17 — source: IIUG Forums & Mailing Lists

Hi, just wondering what is the maximum number of arguments a stored procedure can take. Also, is there something like rowtype or recordtype to pass to a stored procedure an argument that comprises all columns of a table without listing them? Thanks _________________________________________________________________

↪ replying to Georges Martin

Art Kagel — Fri, 03 Oct 2008 18:00:04 — source: IIUG Forums & Mailing Lists

It's in the Fine Manual. SPL procedures and functions - 256 args or returns, C & Java routines can take more. ROW types are supported as arguments to routines, yes. Art On Fri, Oct 3, 2008 at 1:46 PM, Georges Martin <georges_martin_1@hotmail.com > wrote: > Hi, > just wondering what is the maximum number of arguments a stored procedure > can > take. > Also, is there something like rowtype or recordtype to pass to a stored > procedure an argument that comprises all columns of a table without listing > them? > Thanks > _________________________________________________________________ > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.