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.

MSSQL stored Procs in IM6.0 selects???

2 posts in PB Infomaker Report Writer Last posting was on 1999-03-04 23:46:41.0Z
Steve Gilbey Posted on 1999-03-02 23:14:30.0Z
Newsgroups: sybase.public.infomaker.general
Date: Tue, 02 Mar 1999 23:14:30 +0000
From: Steve Gilbey <sgilbey@devron.net>
Organization: Devron Integrated Systems
X-Mailer: Mozilla 4.05 [en] (Win95; I)
MIME-Version: 1.0
Subject: MSSQL stored Procs in IM6.0 selects???
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 22
Message-ID: <348_36DC70D6.F94A1273@devron.net>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6519
Article PK: 241505


> Can anyone tell me of it is possible to include MSSQL stored
> procedures
> as part of a select statement in IM6.0.
> I have succesfully done this when querying against an SQLAW 5.5 db
> with
> no problems, but when querying against Microsoft SQL 6.5 it seems I
> can
> use the stored (function) proc as a data column on its own e.g.
> db.owner.spname param1, param2
> and IM puts the returned parameter in as a column and shows the
> correct
> result.
>
> However if it then try to combine this with a select e.g
> select table.column, db.owner.spname param1, param2 from table
>
> I get an error saying 'syntax error near param1'
> The documentation hints that you can only base the query on a
> procedure
> Can anyone tell me how, or if this can be done?
>
> Many thanks
> Steve Gilbey
> Devron Integrated Systems, London


Terry Dykstra Posted on 1999-03-04 23:46:41.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: MSSQL stored Procs in IM6.0 selects???
Date: Thu, 4 Mar 1999 16:46:41 -0700
Lines: 39
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_PNv0wjpZ#GA.161@forums.powersoft.com>
References: <348_36DC70D6.F94A1273@devron.net>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6518
Article PK: 241504

I have no experience with MSSQL and I haven't been able to find somebody who
does.
I would try this in ISQL first to see if you can get it to work.
You could try to use a function that calls the stored procedure.

--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.

Steve Gilbey wrote in message <36DC70D6.F94A1273@devron.net>...
>> Can anyone tell me of it is possible to include MSSQL stored
>> procedures
>> as part of a select statement in IM6.0.
>> I have succesfully done this when querying against an SQLAW 5.5 db
>> with
>> no problems, but when querying against Microsoft SQL 6.5 it seems I
>> can
>> use the stored (function) proc as a data column on its own e.g.
>> db.owner.spname param1, param2
>> and IM puts the returned parameter in as a column and shows the
>> correct
>> result.
>>
>> However if it then try to combine this with a select e.g
>> select table.column, db.owner.spname param1, param2 from table
>>
>> I get an error saying 'syntax error near param1'
>> The documentation hints that you can only base the query on a
>> procedure
>> Can anyone tell me how, or if this can be done?
>>
>> Many thanks
>> Steve Gilbey
>> Devron Integrated Systems, London
>
>
>
>