| Thread | Last Post | Replies |
|
| db2jcc driver issue with getting an empty resultset | 21 Jan 2005 21:14 GMT | 1 |
I have a java web application that is using the db2jcc driver to get a connection to a DB2 database that is located on an RS 6000 server. The here is a portion of the code that is giving me a problem. rs is an ResultSet object instantiated by the following...
|
| Fixpack 6b? | 21 Jan 2005 19:25 GMT | 4 |
Does anyone know anything about Fixpack 6b for DB2 V8.1 LUW? We were attempting to download the latest 8.1 Windows 32-bit runtime client last week from the IBM site and all of the links were bad. The links currently seem to be fixed, but when we were digging a bit further on
|
| Issue with a stored procedure | 21 Jan 2005 17:18 GMT | 2 |
[Running 8.2.0 on Suse 8.1] I'm building a stored procedure that simulates cars arriving in a car park, and staying for different amounts of time, based on historical data.
|
| Before delete triggers | 21 Jan 2005 16:33 GMT | 3 |
If one or mode records get deleted from t1 (see below), I'd like delete all the corresponding records from t2. There is no foreign key relationship between t2 and t1, so cascading delete is not an option. V8.2 AIX
|
| 3390 mod3 vs. mod9 performance | 21 Jan 2005 15:54 GMT | 1 |
Our FM provider wants to know if we want our new DASD configured as 3390 Mod 3s (as our old stuff is) or Mod9s Oh and they want to know before this weekend. I like the idea of the larger logical volumes, is there any downside
|
| Using SQL against Non DDS files? | 21 Jan 2005 15:33 GMT | 2 |
Can you use sql to pull back data from non dds files in an AS400 in an understandable way? I'm using iSeries Navigator and the SQL scripting window to query tables in an as400 db2 database. Most of the tables have a DDS and I
|
| Trigger porting problem | 21 Jan 2005 14:38 GMT | 2 |
Hi :-) I'm porting a project from Oracle to DB2 and now I'm trying to avoid error SQL0746N in a trigger which reads the same table in which the trigger is defined.
|
| Full Backup of DB2 V8.2 | 21 Jan 2005 11:20 GMT | 1 |
Hi @ll, how can i backup my DB2 V8.1 database and install it to another machine where DB2 V8.2 is running. Cu,
|
| Can a table UDF modify SQL data? | 21 Jan 2005 11:04 GMT | 1 |
I want to write a UDF (external UDF or SQL UDF) that creates a table adn returns the same to the calling function. So, Can someone tell me is it possible to create/drop tables from a table UDF. The UDF can be an external or SQL UDF.
|
| revoking select from all tables | 21 Jan 2005 07:06 GMT | 2 |
Is it possible to revoke from public select from 'all' tables, in one command. thanks pete db2 v 8.2
|
| Which DB2 on IBM xSeries 346-8840 with SuSE Enterprise 9 ? | 21 Jan 2005 00:54 GMT | 2 |
Folks, I'm in the process of building a new IBM server with SuSE Linux Enterprise Server 9 (SLES9) to run DB2 Workgroup Server Unlimited Edition. I notice when the Linux install is done that the HOSTTYPE=x86_64. Checking
|
| How to find actual LENGTH of a CHAR string | 21 Jan 2005 00:04 GMT | 11 |
I am using DB2 version 8.2 on Windows XP platform. I have a table 'EMP' with one field named 'NAME' of type CHAR , size 80. Also , I have a record with NAME='john'
|
| Will we be able to apply FP8 directly ? | 20 Jan 2005 19:31 GMT | 10 |
Will we be able to apply FP8 (that comes out end of January) directly without obligation to go thru FP7a or will we have to step thru FP7a ? I wish to know the answer for both 8.1 and migration from V7.2 to 8.2 FP8. Best regards,
|
| vargraphic column Question. | 20 Jan 2005 18:32 GMT | 2 |
When I try to create a table with a vargraphic column I get the following error. CREATE TABLE EIITEST.IRFAN ("VARC" VARCHAR (48) , "VARGRA" VARGRAPHIC (96) ) DATA CAPTURE NONE IN USERSPACE1;
|
| IBM DB2 Content Manager eClient Version 8.2 Install Problem | 20 Jan 2005 16:15 GMT | 1 |
I'm trying to install the IBM DB2 Content Manager eClient version 8.2 on my WebSphere system. It is telling me that I need to install Enterprise Information Portal Version 8.2 or at least the local connectors for the Enterprise Information Portal.
|