30 Website to Download Freeware Application

Below is the list of website where you can find many freeware application. I hope this can help to decrease piracy.

1. FreewareFiles.com
http://www.freewarefiles.com
game, browser web, screensaver, driver, desktop, spyware

2. Nonags
http://www.nonags.com
All about freeware

3. Freeware Home
http://www.freewarehome.com
All about freeware

4. Free Downloads Center
http://www.freedownloadscenter.com
game, video, program antivirus,wallpaper

5. PortableApps.com
http://portableapps.com
Portabel application

6. SofoTex Downloads
http://www.sofotex.com
PC utilities, games, screen savers

7. Completely Free Software
http://www.completelyfreesoftware.com
Freeware Windows and DOS

8. MyZips.com
http://www.myzips.com
All about freeware and shareware

9. Programfiles.com
http://www.programfiles.com
All about freeware and shareware

10. FreewareWeb.com
http://www.freewareweb.com
All about freeware and shareware

11. GameHippo
http://www.gamehippo.com
All about freeware game

12. TinyApps.org
http://www.tinapps.org
All about small freeware application

13. Freeware Guide
http://www.freeware-guide.com
All about freeware

14. TopDownloads
http://www.topdownloads.net
Game, screen savers, wallpapers, and many others

15. Open Universe

http://www.openuniverse.org
Freeware simulator

16. Files32.com
http://www.files32.com
All about freeware and shareware

17. Pricelessware
http://www.pricelessware.org
Best windows freeware application

18. ACME Laboratories
http://www.acme.com
Utiliti and tool for Unix and java

19. ABF-SOFT.com
http://www.abf-soft.com
All about freeware and shareware

20. Only Freeware
http://freeware.intrastar.net/
All about freeware

21. SGI
http://www.sgi.com/fun/freeware/games.html
Freeware game

22. AnalogX
http://www.analogx.com/contents/download.htm
More than 5000 windows application

23. DriversHeadquarters
http://www.drivershq.com
All about freeware driver

24. Mihov Freeware
http://www.mihov.com/eng/
All about freeware and shareware and image

25. Freeware Directory
http://freewaredirectory.net
All about freeware and direct link

26. Driverfiles
http://www.driverfiles.net
All about freeware driver and DLL

27. Top Quality Freeware
http://www.topqualityfreeware.com
Freeware application include game PC, icon, desktop, themes, image and internet utility

28. The Free Site
http://www.thefreesite.com/free_software/
All about freeware

29. Freeware Network
http://www.fwnetwork.com
All about freeware

30. Free Software 4 All
http://www.freesoftware4all.co.uk
List of good freeware application

Using Cursor at DB2

After Stored Procedure, we will learn about how to use Cursor. Output with Cursor or without Cursor will be the same. The differences is just a the process. With Cursor we lock at 1 row only, without cursor we will lock all record.

The advantage of using Cursor
- only lock 1 row
- there are an operation that must use Cursor

The disadvantage of using Cursor
- it become more complex

For example if we want to make a Stored Procedure to update salary depends on job. There are 2 ways that we can do, Stored Procedure with an without Cursor.

This is the Stored Procedure without Cursor, the easier way.

------------------------------------------------------------
create procedure proc_2(in bonus double,in work varchar(10))
dynamic result sets 1
p1: begin
update staff set salary = salary + bonus where job= work;
end p1
------------------------------------------------------------

This is the screen shoot



This is the Stored Procedure without Cursor, more complicated query.

------------------------------------------------------------
create procedure proc_1(in bonus double,in work varchar(10))
dynamic result sets 1
p1: begin
declare now_salary double;
declare c1 cursor with return for
select salary from staff where job=work;
open c1;
fetch from c1 into now_salary;
close c1;
set now_salary = now_salary + bonus;
update staff set salary = now_salary where job= work;
end p1
------------------------------------------------------------

This is the screen shoot


You can run this Stored Procedure at DB2cmd. Just write this command.
"db2 call proc_2(100.0,'Mgr')", but don't forget to connect to the DBMS first.