Inserting child table with parent table having generated column
I am sure we all have come across situations were we have to populate a child table with a value...
Gotcha when restoring database with restrictive access !
Starting from DB2 V9.1, IBM added a parameter on the CREATE DATABASE command called RESTRICTIVE. Â When this parameter is...
DB2 10 arrives !
IBM announces DB2 10 for Linux Unix and Windows ! Â Code named Galileo, DB2 10 arrives with some neat features....
Stored Proc for SQL Server and DB2 UDB
We often grant permissions against table for users. Some use the GUI, some just script it out. I wrote a...
Loading db2 tables from another database
Data movement is a common task that app dev and dbas perform often. DB2 has multiple options to mass add...
Clouds are rolling in, do you hear the rumble ?
If internet was the “it” during the late 90’s and early 2000’s, now cloud computing is the new “it” ....