All Questions
6 questions
0
votes
1
answer
392
views
Inserting into DB2 database from SQL Server stored procedure succeeds, but wrapping the same procedure using Entity Framework fails
I need to be able to insert rows into a set of tables in a DB2 database from a Microsoft SQL Server database. I created stored procedures that can insert rows into the DB2 database using a linked ...
- 141
0
votes
0
answers
2k
views
Error: CLI0115E Invalid cursor state. SQLSTATE=24000
I'm trying to execute an SQL Server stored procedure using the execute SQL task of an SSIS package and I'm getting errors.
CLI0115E Invalid cursor state. SQLSTATE=24000
Cannot fetch a row from ...
- 799
0
votes
1
answer
18k
views
DB2 Stored Procedure Returning SQLCODE=-440, SQLSTATE=42884
I am currently using RazorSQL to test queries with IBM DB2. Right now, I am stuck on an issue with creating procedures
I have the following procedure. I create this procedure as an admin user called ...
- 4,865
-1
votes
1
answer
644
views
Call AS400 SP and return recordset into SQL Server
I have a SP on an IBM AS400 box that I need to call and return the recordset into a SQL Server 2012 table. How do I perform this is the world of SQL Server?
I call the IBM SP like this from SQL ...
- 2,657
0
votes
0
answers
86
views
SQL Server 2008R2, EXEC() AT LinkedServer, IBM DB2. Error: Authentication Failed,
I am having a problem using an web application against a stored procedure. I have a stored procedure that uses
EXEC('Query') AT LinkedServerName
My application uses a service account as the identity ...
- 1,155
0
votes
1
answer
9k
views
DB2 using parameteres in like statement
The problem is as following:
I have a Procedure in DB2 that receives couple parameters and does a filtering.
One of the parameters is a VARCHAR thath is needed for a like statement. In SQLServer I ...
- 495
