Expert Knowledgebase
DB2 with Craig Mullins
Problem connecting with trial version ODBC driver
(21 JUN 2004)
I am trying to connect to a DB2 database via ODBC. I downloaded a
trial version ODBC driver from the Web
at http://www.datadirect-technologies.com/odbc/connectodbc/opxconnectodbc.asp .
I get an error ...
Determining what version of DB2 is running
(21 JUN 2004)
How do I find out which DB2 version I am using on MVS?
Deleting all records based on character length of one field
(21 JUN 2004)
I want to delete all the records from a table where the length of data in a
field is less than 7 characters. There are more than 500,000 records in a
table.
When I use the length funtion coupled with a del...
SQL queries in Oracle vs. DB2
(21 JUN 2004)
Please list the differences of SQL
queries (select, insert, update, joins, union, sequence, decode, etc.) while
migrating from Oracle to DB2.
Testing converted DB2 code
(21 JUN 2004)
If you can let me know the guidelines for how to test the converted DB2 (from
IDMS) code, that would be great.
DECODE function equivalent
(21 JUN 2004)
Does DB2 on the OS/390 support the DECODE function? If not, how can I
modify an ORACLE SQL script containing DECODE to run on a DB2 database?
Changing date formats
(21 JUN 2004)
I have data in a text file where the date format is DD/MM/YYYY. How can I
change the Date Style in DB2 to DD/MM/YYYY so that I can input the data into
a table?
Maximum number of columns
(21 JUN 2004)
Is it true that a DB2 table can have a maximum of 56 columns? If not, then
what is limit?
Utilizing DB2 to give transactional process priority over data processing
(21 JUN 2004)
DB2 V6 OS390 -- We currently have one production subsystem with transactional
and warehouse data processing. We are debating splitting the warehouse data
processing into its own subsystem since it's consuming...
Update and commit data, then trigger an external action?
(21 JUN 2004)
We are on OS/390 DB2 version 6 (Mainframe ES 9000).
We want to define triggers on the mainframe (DB2) side, and whenever data is
updated on the mainframe side, we want to be able to initiate an external
...
|
|
|
|
|
|
|
| TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of . |
|
| |
All Rights Reserved, , TechTarget |
|
|
|
|
|
