| Thread | Last Post | Replies |
|
| Moving tables to new schema | 02 May 2006 02:56 GMT | 6 |
I currently have 500 tables in 1 single schema. I would like to move 250 out of the 500 tables into a new schema. How is this done? Thanks.
|
| changed machine name - unable to work in DB2 | 01 May 2006 21:26 GMT | 7 |
I have been using DB2 v8.2 on my windows 2000 machine. For some reasons I changed my machine name. After that non of the services (control center, CLP etc) are starting. When I try to invoke control center, I am getting the following error:
|
| db2advis with stored procedures | 01 May 2006 21:23 GMT | 1 |
Hello I was wondering if I"m doing something wrong with using db2advis I have 2 stored procedures are are massive, I created an input file to call both of these stored procedures and I dont' seem to get any index help, but if I put the main body of these stored procs in a view and
|
| Moving cursor in Command Editor results screen results in update of table | 01 May 2006 17:43 GMT | 3 |
In the DB2 Admin Client (8.2.4), when the results of a query are displayed in the grid that looks like a spreadsheet (using Command Editor or double click on table name in Control Center). The data in this grid is updatable. When a cursor is first placed on one of the columns, no ...
|
| Mother Celko's Monday SQL Puzzle #3 | 01 May 2006 09:36 GMT | 8 |
Mother Celko's Monday SQL Puzzle #3 I am gathering material for a second edition of SQL PUZZLES & ANSWERS. The easiest way to do this is to post a puzzle and harvest answers. The solvers get fame (15 seconds, not minutes), glory and their name in
|