| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| SQL Server SP not returning the values to ESQL List |
« View previous topic :: View next topic » |
| Author |
Message
|
| its_shuk |
 Posted: Fri Dec 13, 2024 1:34 am Post subject: SQL Server SP not returning the values to ESQL List |
 |
|
Newbie
Joined: 13 Dec 2024
Posts: 1
|
I have a working code for ESQL which is running perfectly from over last few years which uses Sybase 16 as data source. Recently we are trying to migrate our underlying database from Sybase to MSSQL. We have created DSN in odbc.ini for MSSQL DB & database connectivity working well with ESQL code. But there is bit of code which was working well for Sybase but not working on MSSQL.Here is ESQL code :
| Code: |
Create Procedure SomeProc()
BEGIN
Declare List1 Reference To Enviornment.XMLNSC.Data.LIST[1];
Create Field Enviornment.XMLNSC.Data.LIST[1].parameter2;
CALL GetParamsESQL(List1, Enviornment.XMLNSC.Data.LIST[1].parameter2);
END
Create Procedure GetParamsESQL (IN List1 reference, IN parameter2 reference)
BEGIN
Declare Id1, Id2 Integer 1;
SET Id1 = List1.Id1;
SET Id2 = List1.Id2;
Call GetParamsSQL(Id1, Id2, parameter2.Params[]) IN Database.{GetDNS("MyDNS")}.dbo;
END
Create Procedure GetParamsSQL
(
IN Id1,
IN Id2
) Language Database
Dynamic Reslut Sets 1
External Name "dbo.GetParams"
[quote]// My expectation is when DB stored procedure is executed, result set should returned in Params[] list with all returned field from database[/quote]
SQL Store Procedure
Create Procedure GetParams
( @Id1 int, @Id2 int
)
as
select field1, field2... from SomeTable where Id1= @Id1 and Id2 =@Id2
|
|
|
| Back to top |
|
 |
| bruce2359 |
| Posted: Fri Dec 13, 2024 7:30 am Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
I?d recommend that you post this on a website devoted to SQL support, rather than here on IBM MQ support site.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
