DB2
in [SQL]
|
Migrated From v7 => v9 ... and Now Can't Use Semi-Colons inStrings? >>> On 6/27/2008 at 7:00 PM, in message <fe715a94-6138-4934-9ff7-aa4e4d2f5e7e(a)c19g2000prf.googlegroups.com>, machineghost<machineghost(a)gmail.com> wrote: One last shot in the dark before I give up (for real this time ;-) ). I stumbled upon this link when I went to lookup the syntax for switching the terminati... 2 Jul 2008 12:55
Urgent - need help I have a situation where one of the app server thread is executing an update statement on A record and at the same time another thread is trying to read it by executing a select query. Now we are seeing timeouts - Update query is holding the lock and the select statement is timing off. Now my question , how can ... 28 Jun 2008 02:29
FREE SOFTWARE DOWNLOAD DOWNLOAD FREE SOFTWARE ONLINE http://freesoftwareonline.googlepages.com ... 27 Jun 2008 08:02
CREATE TRIGGER ON INSERT Hi all, i have a problem when creating a trigger on DB2 ver 7.2 on WINDOWS. I have two tables MOVIMAG and BARCODE, the trigge when INSERT INTO MOVIMAG will be UPDATE a MOVIMAG field BARCODE taken the value from the table BARCODE. I have write this but doesnt work ========================================== C... 27 Jun 2008 09:03
Question on syscat.keycoluse.colseq Sorry for the length of this post, but I think it will illustrate my point. As part of my deployment process I run a bunch of verification scripts. Amongst other thing the column order of primary/foreign keys is validated. The other day I stumbled upon an error. The foreign keys are working as expected, but sysca... 17 Jul 2008 08:33
the option CPU_PARALLELISM of LOAD hello all, when i want to set the value of CPU_PARALLELISM of LOAD at AIX 5.3,the value is base of physical CPU number OR logical CPU number(SMT)??? thanks!!! ... 28 Jun 2008 10:38
When does a stored procedure use an MQT I am trying to get a SQL stored procedure to use user maintained MQT implicitly which raises questions on when they are used or not used. In theory you would expect the stored procedure to pick up the MQT at the time it is bound on the creation of the static SQL. This raises the question on how you stop it or star... 2 Jul 2008 04:43
Question: restore from backup in relative path... Hi there. Using 8.2 on Windows. I have a situation where I have a db backup, which I want to deploy to a group of developer workstations. The target directory for the database files will be consistent, but the location that the backup file is on may vary. I have gone through the entire backup and restore pr... 27 Jun 2008 13:10
Getting group of data for each member of primary key I have a table that is based on a client_cd, client_cd, client_nm .......... It has 1.7 billion rows with varying cardinality for each client. All I want to do is to set up a sample table having exactly 100 rows for each client_cd s. I have tried recursion but have problems with sets (cannot use fetch first 100 ... 26 Jun 2008 19:46
FYI: IM Consumability Survey Hi folks, I just learned about this survey and figured there is likely quite a bit of data to be mined from the members of this group :-) http://www.ibm.com/software/data/info/consumability-survey/ Cheers Serge -- Serge Rielau DB2 Solutions Development IBM Toronto Lab ... 26 Jun 2008 15:39 |