Search results for query: *

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...

Got it! Thanks a lot! I will try this.. Thanks again!!

Thanks a lot for responding! We have some keywords like User_id(), USer_Name() to display the connected user (Integer and name) Host_Name - Client Computer name connected to the Server. There are a lot many for which we are not able to finf the equivalent DB2 Syntax. Apologies, didnt get...

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...

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...

Hello Greg, Thanks alot for responding!! Actually, i have created temp tables in SQL proc and they work fine But now i want to create a UDF and then use temp tables. When i write exactly the same code in UDF (using Create FUnction) it gives an error at the Decale global temp table statement Here...

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...