1
  • iSeries stored procedure isn’t returning value when calling RPG program

    Our team currently has a stored procedure that calls an SQLRPGLE program. It's running great as we have verified the debugger and it sends the return value as expected. But the problem is what is returned when we're looking at cmd.Parameters["@ISMATCH"].Value = {} Here's our stored procedure:...

    ITKE56,500 pointsBadges:
  • Having difficultly making my DB2 queries case sensitive

    I'm been having a lot of problems making my DB2 (AS/400) queries case sensitive. Here's an example of what I'm trying to do: SELECT * FROM NameTable WHERE LastName = 'smith' That returns zero results but this returns 1000's or results: SELECT * FROM NameTable WHERE LastName = 'Smith' Does anyone...

    ITKE56,500 pointsBadges:
  • Trying to call a DB2 stored procedure in IBM System i Access

    I'm trying to test a DB2 stored procedure that's running on an AS/400 system. Our company currently has the IBM System i Access for Windows installed that runs SQL commands against the DB2 database. My big question: What is the syntax to execute a stored procedure that takes in a parameter /...

    ITKE56,500 pointsBadges:
  • Duplicate key on access path.

    I have a physical file PF1 with some key fields(K1,K2,K3). PF1 has say 5 logical files with different keys(K1,K2...K5) I am trying to update only a field of PF1(that field is not a key in PF1) using SQL(stored procedures) PF1 has unique keyword mentioned.But the update is not made on key fields....

    anuppdas105 pointsBadges:
  • Stored Procedure code in SQL Management Studio

    I'm trying to find a way to step into a stored procedure code in SQL Management Studio (in SQL Server 2008). I've heard its possible with Visual Studio but I'm looking for a debugging solution for Management Studio.

    ITKE56,500 pointsBadges:
  • Using a table variable as input in a stored procedure

    Have just run into a problem. Currently our web service has been adding data to our SQL server 2008 tables by building a dynamic SQL INSERT command. It has started failing because of the data coming in. It contains a single quote in the name data ex. O' Brien. I am looking to pass the tables from...

    ToddN20006,360 pointsBadges:
  • Stored procedure error in SQL Server 2008 R2

    I’m trying to change an existing stored procedure. I’m using the command: ALTER 'name_of_stored"procedure' When I do so, the name comes up with red highlighting, denoting that it is an invalid object. Although I am able to execute the command successfully, I want to know why SQL Server 2008 R2...

    ITKE56,500 pointsBadges:
  • Call a iSeries stored proc from a SQL server 2005 stored proc

    Ok I'm missing something. I've tried entering a few examples I have found in forums but can't get past a syntax error I cannot find. I'm using a linked server as well. Here is the code for the SP. Any pointers would be great! USE [MyDB] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER...

    ToddN20006,360 pointsBadges:
  • Run Oracle Procedure in SSRS dataset

    Have an Oracle stored procedure that needs to run to repopulate a table. Do not need data from sp, have a separate dataset to pull from refreshed table. What I need is a way to run the sp that is acceptable to SSRS inside or outside of dataset.

    redusn19505 pointsBadges:
  • Crystal Report using SQL 2005 Stored Procedure with DateTime Data type variable

    I want my Crystal Report parameter calendar pick to display date only

    LrdByron5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following