Search results for query: *

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

Thanks Satya, the code snippet really helps. Nice work!! Thanks, sandip

Thanks Marc & Ties for your reply!! Let me try to explain. The row will be selected when B>=90 and when it finds the row, it also selects preceeding 3 rows (order by A asc). As this is a snippet of data which i listed, i wanted to see a SQL logic of how to find a matching row/rows and its 3...

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

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