DB2

question about "select * from new table (update ...)"
I really like the construction: select * from new table (update ....) X but I noticed that it cant be used as: insert into T select * from new table (update ....) X because of: SQL20165N An SQL data change statement within a FROM clause is not allowed in the context in which it was specified. SQLS... 7 Oct 2006 06:07

Could someone please say something on my issue?
http://groups-beta.google.com/group/comp.databases.ibm-db2/browse_thread/thread/87dc5350088dff43/# ... 5 Oct 2006 12:16

db2javit rc : 9505
Hello I have DB2 Connect Admin installed on my system and when I start the control center I get a error DB2JAVIT RC : 9505. Please help me. I have also recently updated my JRE to 1.5.0_06 Please let me know if you need any other information. Thanks Majeti ... 5 Oct 2006 08:35

"MESSAGE : DPS not initialized for this application" - what is it
db2 8.2 fp 11 win32 db2diag.log 2006-10-05-14.26.09.624000+240 I1053498H383 LEVEL: Warning PID : 2100 TID : 4876 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : RBADB APPHDL : 0-62 APPID: *LOCAL.DB2.061005102104 FUNCTION: DB2 UDB,... 5 Oct 2006 06:56

Artificial Mind - Part One - Basic Architecture and Cognitive Structure is now available
It's a dream of human beings to build machines that can think and behave like human beings. The most important part of of such a machine is an artificial mind that can emulate the cognitive processing of human mind. This book, "Next Generation Artificial Intelligence, Artificial Mind - Part One - Basic Architec... 5 Oct 2006 01:13

fixed length host variables for VARCHAR fields
I'm just learning about embedded SQL, so be gentle... My basic question is, if I use a fixed length host variable for a column defined as VARCHAR, will trailing spaces be removed (or not) upon INSERT or UPDATE of this column? I tried it, and it appears they are *not* stripped. However, the Programming Client Ap... 10 Oct 2006 20:28

SQL2036N when backing up to CIFS
Hi, I'm not sure if anyone can help with this issue I have, but I would appreciate any thoughts. We are running DB2 8.2, fp11 on windows 2003. The goal is to backup to an external EMC SAN which uses CIFS. Is this possible? It was my understanding that backups were file system independent. I have also succes... 5 Oct 2006 10:40

Help me convince them this is bad!!!
I have an IT manager that thinks he knows everything when it comes to database design. Unfortunately, he's not familiar with relational databases but thinks he knows it all. He's come up with a really crazy design, and I've got to come up with all the reasons it's not right. I want to have as much ammo as possib... 5 Oct 2006 10:09

Error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSLH205 0X5359534C564C3031
Stack trace below. Only happens in WebSphere 6.0. DB2 v 8.2. FP12. Only against 1 database. I have other databases in this database instance, but they don't seem to have this problem. Looked up SQLCODE: -805. It said either a) the client and server versions don't match (which doesn't make sense, because we... 5 Oct 2006 12:47

_ in LIKE
Hi! Is there a way to include the character _ in the search string in LIKE clause? The default behaviour is: - _ replace one character - % replace many characters If I write something like: SELECT WORD FROM DICTIONARY WHERE KEY LIKE 'BLAG_%' this would return BLAG_0001, BLAG_0002, .. but not BLAGb0001, ..... 3 Oct 2006 09:57