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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Stored Procedure CALL limitation
The DB2 Command Reference (pg 188) states that "The maximum length for an INPUT parameter to CALL is 1024" I have a SQL Stored Procedure accepting a string of length around 4000 bytes. Is there any way to override this limitation and still be able to give a call to the SQL Stored... -
DB2 equivalent of WAITFOR and SLEEP
Thanks a lot. The DB2 MTK does provide a java function to wait or sleep. -
DB2 equivalent of WAITFOR and SLEEP
In SQL Server, the function WAITFOR instructs SQL Server to wait until the specified amount of time has passed In Oracle SLEEP function can be used to get a similar behavior. Is there any equivalent function in DB2? If not is there any special reason that DB2 has not provided a support for... -
Is BEGIN COMPOUND equivalent to BEGIN TRANSACTION?
consider the following piece of SQL Server stored procedure CREATE PROCEDURE DummyProc ( @v1 int, @v2 int ) AS BEGIN insert into dummytab values (1,1) BEGIN transaction insert into dummytab values (2,2) insert into dummytab values (@v1,@v2) insert into dummytab...
