> Can anyone tell me of it is possible to include MSSQL stored
> as part of a select statement in IM6.0.
> I have succesfully done this when querying against an SQLAW 5.5 db
> no problems, but when querying against Microsoft SQL 6.5 it seems I
> 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
> 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
> Can anyone tell me how, or if this can be done?
> Many thanks
> Steve Gilbey
> Devron Integrated Systems, London
Date: Tue, 02 Mar 1999 23:14:30 +0000
From: Steve Gilbey <firstname.lastname@example.org>
Organization: Devron Integrated Systems
X-Mailer: Mozilla 4.05 [en] (Win95; I)
Subject: MSSQL stored Procs in IM6.0 selects???
Content-Type: text/plain; charset=us-ascii
Xref: forums-1-dub sybase.public.infomaker.general:6519
Article PK: 241505
From: "Terry Dykstra" <email@example.com>
Subject: Re: MSSQL stored Procs in IM6.0 selects???
Date: Thu, 4 Mar 1999 16:46:41 -0700
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
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
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.