Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to capture No of Rows affected in case of Execute statement (CALL)
Hello, I have one Stored procedure which executes multiple Stored proceudres in a loop. These sun procedures are stored in a table. So to execute them dynamically, i am using Prepare and execute command. Now i also need to store the No of Rows affected/returned in case of each procedure. If... -
Migrating Sybase DB to DB2 on AS400
Hello Everyone, I am working on an application which has a part of its data on Sybase. We are required to migrate all the data (with Tables/ SPs and of course the data) on to DB2 on AS400 as that is the main database. We have downloaded MTK migration tool kit to do this job. But we are facing... -
Urgent!! Peformance Optimization
Hello Frinds, I am getting a major performace hit in my Stored Procedures. Actually the story started from writing stored procedure for reporting requirements. We started with writing big sqls in stored procedures. But ultimately Our SPs were taking long time to get executed. Then we tried using... -
HELP!!Creating UDF in DB2
Hello, I want to create a UDF for some common calculation. In that, i want to create tables (temporary or using table variable), with some records and later on do some calculations on these. Finally, the UDF is required to return the processed recordset. Could somebody please help me on this. I...
