Using SQL CLI APIs to call an sql stored procedure on an AS400
I would like to know if there any examples of using the SQL CLI APIs in a COBOL/400 program that may help me in using the APIs to call a stored procedure and process the result set(s) .ThanksMike
Answer Question
| Sep 26 2008 7:55 PM GMT
| asked by
I5DB2DBA
SQL, API, COBOL/400
Updating values in a table in a SQL database
I have a SQL database with a table. I need to insert a new record into that table if there is no entry for a particular column that day, or I need to update the record if that new record already exists. I am using a count column in the table to accomplish this, and if the count is null, I am...
View Answer
| Sep 19 2008 5:04 PM GMT
| asked by
SQL Server Ask the Experts
SQL, SQL database, SQL stored procedures
AS/400 SQL Procedure call from CL program
I am calling an SQL stored procedure (counts records for a value) from a CL program. I want to send the value to compare to the CL SQL pricedure and get back the count. How do I define the count variable (&COUNT ?) in the CL program? I am using STRQMQRY to call.
Answer Question
| Sep 18 2008 4:39 PM GMT
| asked by
Burmanr
SQL stored procedures, STRQMQRY, CL
Difference between Sp_msforeachdb and sp_msforeachtable
In MS SQL Server what is the difference between Sp_msforeachdb and sp_msforeachtable
View Answer
| Aug 7 2008 7:00 AM GMT
| asked by
Jaideepkhanduja
sp_MSforeachdb, sp_MSforeachtable, SQL Server
sp_OACreate is missing
HiI'm trying to create a stored procedure to send mail, and 1 line in my SP states:EXEC @hr = sp_OACreate 'CDONTS.NewMail', @MailID OUT But I get an error that sp_OACreate is missing. How it happened I don't know.But how do I fix the problem? Is it possible to recreate sp_OACreate manually?(Note...
View Answer
| Jul 23 2008 11:24 AM GMT
| asked by
Kowalski
sp_OACreate, Stored procedures, SQL Server errors
Internal vs Externa Stored Procedure Performance
Our company develops software for Windows using C# for connecting and updating the corporate database in DB2/400. We use both internal (SQL) and external (rpg) stored procedures. Because we have noticed some bad performance in our internal stored procedures, we have the following question: Is there...
Answer Question
| Jul 10 2008 2:18 AM GMT
| asked by
Baron400
DB2/400, C#, SQL stored procedures
Slowdown of the SAN due to overusage of temporary tables
We make use of temporary tables when we develop stored procedures, but they also become very slow when there is a heavy workload. We have an ISCSI SAN running RAID 10, and our database, logs and tempdb (15 GB) are on the SAN. We think the SAN is overworked; the SQL Server shows no CPU. Should we...
View Answer
| Jul 1 2008 8:23 PM GMT
| asked by
SQL Server Ask the Experts
SAN, Stored procedures, SQL stored procedures
Calling a stored procedure in a SELECT list on SQL Server 2000
I am using SQL Server 2000, and my question is: is there any way to call a stored procedure in a SELECT list?
View Answer
| Jun 24 2008 8:16 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2000, Stored procedures, SELECT
Coding for library in stored procedures
A reader wrote in with this SQL stored procedure question. Our AS/400 experts weren't as familiar with this topic. So, any SQL experts out there with an answer?Do I have to hard code the library in my stored procedure? I have my procedures in sqltblsrc and have to edit the library to create the...
Answer Question
| Apr 25 2008 3:38 PM GMT
| asked by
Leah Rosin
SQL stored procedures, SQL
Stored Procedure
I am calling some stored Procedure, having selct statment, after inserting some a new data entry by different stored procedure.Some times my Select stored procedure does not return any value. Data is exactly correct and when I explicitly called that SP with same data by Query analyzer, I will got...
View Answer
| Feb 1 2008 2:35 PM GMT
| asked by
Deepanshu
SQL stored procedures, ADO.NET
