Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Is it possible to insert multiple rows into the __input table when calling an SP?

3 posts in AEP Last posting was on 2009-07-27 08:16:16.0Z
mike grace Posted on 2009-07-24 15:06:11.0Z
Date: Fri, 24 Jul 2009 15:06:11 +0000 (UTC)
Message-ID: <b9f6cef880518cbda8fcc4931ea@devzone.advantagedatabase.com>
From: mike grace <mikeg@computastat-group.co.uk>
Subject: Is it possible to insert multiple rows into the __input table when calling an SP?
Newsgroups: Advantage.AEP
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 1098.1
X-Antivirus: avast! (VPS 090724-0, 24/07/2009), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 217.24.129.66
X-Trace: 24 Jul 2009 09:05:06 -0700, 217.24.129.66
Lines: 13
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!217.24.129.66
Xref: solutions.advantagedatabase.com Advantage.AEP:756
Article PK: 1104033

Hi,

I want to pass in multiple rows of data into an SP so that I can insert them
all rather than calling the SP multiple times.

Is it possible to insert multiple rows into the __input table?


Regards

Mike


Joachim Duerr (ADS) Posted on 2009-07-24 22:59:03.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Is it possible to insert multiple rows into the __input table when calling an SP?
Newsgroups: Advantage.AEP
References: <b9f6cef880518cbda8fcc4931ea@devzone.advantagedatabase.com>
User-Agent: XanaNews/1.19.1.194
X-Face: u2p+</,mb|Ah!x!/qxX5q0t:O~.<1&JzwNHYhSqcviY{~&|iDc"U.Je1A.ZeHR`d;;y#R
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 84.158.161.58
Message-ID: <4a6a2ea7@solutions.advantagedatabase.com>
Date: 24 Jul 2009 15:59:03 -0700
X-Trace: 24 Jul 2009 15:59:03 -0700, 84.158.161.58
Lines: 10
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!84.158.161.58
Xref: solutions.advantagedatabase.com Advantage.AEP:757
Article PK: 1104037


mike grace wrote:

>Is it possible to insert multiple rows into the __input table?

no. But you can populate a temp table instead.

--
Joachim Duerr
Advantage Presales
check out my new ADS book on http://www.jd-engineering.de/adsbuch


mike grace Posted on 2009-07-27 08:16:16.0Z
Date: Mon, 27 Jul 2009 08:16:16 +0000 (UTC)
Message-ID: <b9f6cef880838cbdcb2076acbf6@devzone.advantagedatabase.com>
From: mike grace <mikeg@computastat-group.co.uk>
Subject: Re: Is it possible to insert multiple rows into the __input table when calling an SP?
Newsgroups: Advantage.AEP
References: <4a6a2ea7@solutions.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 1098.1
X-Antivirus: avast! (VPS 090726-1, 26/07/2009), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 217.24.129.66
X-Trace: 27 Jul 2009 02:15:09 -0700, 217.24.129.66
Lines: 9
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!217.24.129.66
Xref: solutions.advantagedatabase.com Advantage.AEP:758
Article PK: 1104038

Hello Joachim,

Thank you. I didn' think of that :-)

Regards

Mike