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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
LBAC feature in DB2 v9 !!
Hi - Can anyone tell me whether DB2 LBAC feature in DB2 UDB v9.x is a licensed version or is bundled with the ESE as free. Some of the IBM release notes says - its a purchase product. Currently, my databases of v9 seems to work as per the LBAC security rules but i havent added any license for... -
DB2 SQL Reporting question!!
Hi - I want to get the db2 SQL output of a query, WHERE B>=90 and wherever it find the matching condition it should fetch preceding 3 rows. For Example - A B - - 1 5 0 6 5 8 1 10 2 20 3 30 4 98 5 50 11 55 6 60 7 70 8 90 9100 So the output should be based on above criteria - A B - - 1 10 2 20... -
DB2 SQL Reporting question!!
Hi - I want to get the db2 SQL output of a query, WHERE B>=90 and wherever it find the matching condition it should fetch preceding 3 rows. For Example - A B - - 1 5 0 6 5 8 1 10 2 20 3 30 4 98 5 50 11 55 6 60 7 70 8 90 9100 So the output should be based on above criteria - A B - - 1 10 2 20...
