I have some XML data in DB2 Express-C 9.5.
Table name is EMP. It has two columns ID integer & INFO xml.
xml data inserted in table is <employee><name>John</name></employee>
Now i want to retr...
http://www.experts-exchange.com/Database/DB2/Q_23714678.html
Zones:
DB2Date Answered: 09/12/2008 Grade: A Views: 9
I want to convert a string like September 11, 2001 to date for insertion in DB2.
But when i run the following command i get an error:
SELECT TO_DATE('September 11, 2001',
'Month d...
http://www.experts-exchange.com/Database/DB2/Q_23770609.html
Zones:
DB2Date Answered: 10/01/2008 Grade: A Views: 96
1) We have DB2 UDB 9.1 Express C on Windows.
2) Since space in D: drive is very less, I dropped one table after exporting its IXF.
3) Now I created a system managed tablespace with container in C...
http://www.experts-exchange.com/Database/DB2/Q_23282800.html
Zones:
DB2Date Answered: 04/07/2008 Grade: A Views: 93
1) I believe that DB2Connect is used to connect to host systems from non-host systems. Is this
correct? Is this the only way?
2) Does host systems mean only mainframes with AS/400, MVS, OS/2, ...
http://www.experts-exchange.com/Database/DB2/Q_23489113.html
Zones:
DB2Date Answered: 06/20/2008 Grade: A Views: 13
Database migration from AS/400 DB2 to SUSE Linux 10.2 x8664 DB2
1) We have DB2 on AS/400 mainframes. The schema has no foreign keys & check constraints. But
there are DEFAULT, PK, UK & Indexes.
...
http://www.experts-exchange.com/Database/DB2/Q_23489190.html
Zones:
DB2Date Answered: 06/18/2008 Grade: A Views: 4
1) We have DB2 9.1 Express C 32 bit Server on SUSE Linux 10.2.
2) This is from SQL Reference:
UCASE OR UPPER ( expression ) The schema is SYSIBM. (The SYSFUN version of this function continues to...
http://www.experts-exchange.com/Database/DB2/Q_23613698.html
Zones:
DB2Date Answered: 08/20/2008 Grade: A Views: 25
1) Suppose we have following foreign key:
ALTER TABLE EMP ADD CONSTRAINT FK_EMP FOREIGN KEY(DEPTNO, DEPTNAME) REFERENCES DEPT(DEPTNO, DEPTNAME);
2) Now in DB2 9.1 Express C, the following 2 que...
http://www.experts-exchange.com/Database/DB2/Q_23837174.html
Zones:
DB2Date Answered: 10/24/2008 Grade: A Views: 6
1) We have DB2 V5R3 on iseries AS/400.
2) FULL OUTER JOIN is not supported
3) There is a query we have written with repeating WHERE conditions for LEFT OUTER JOIN UNION RIGHT OUTER JOIN.
4) Can ...
http://www.experts-exchange.com/Database/DB2/Q_23846748.html
Zones:
DB2Date Answered: 10/26/2008 Grade: A Views: 22
