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!
-
Scheduling stored procedure to run after certain interval
How can I schedule Stored Procedures in DB2 UDB to run after a certain intervals? I also have db2 query patroller server installed on my machine. Can it help me in scheduling my stored procedures? -
How can i send email from stored procedure in db2
Hi I am on a project where we have to migrate database from oracle to db2. There is a java stored procedure written for oracle that sends email to the users after picking up their email id from database. It uses java mail api to send the mail. I have been trying to port the java stored procedure... -
How can i use order by in inner query of a nested query or view
Hi I am working on a project where we have to migrate the database from oracle to db2. My question is can i use order by clause in a nested query i,e the inner query contains order by clause. Db2 is giving me error when i use order by in the inner query of a nested query. Also it does not allow... -
how do i select random records in a sql query in DB2
hi kregen Thanks for the help. It was really useful. But i have run into another problem. Can i use order by clause in a nested query i,e the inner query contains order by clause. Db2 is giving me error when i use order by in inner query in a nested query. Also it does not allow me to use... -
how do i select random records in a sql query in DB2
Hi I am working on a project where we have to migrate the database from oracle to db2. There is a query which picks up certain percentage of records randomly from a table. Currently this query is written in oracle but now I looking for a replacement for that in db2. The query uses...
