Expert Knowledgebase
DB2 with Craig Mullins
Third-party tools to create CSV file from DB2 unload file
(10 FEB 2005)
Are there any third-party tools that will read the DB2 unload
file and create a CSV file so that data can be plugged into SQL
Server? Does unload allow you to dump a file in CSV format? We do not
have acc...
Using IDENTITY or ROWID column types for compound primary key
(10 FEB 2005)
Suppose a DB2 table does not have unique values in any column for providing a primary key. The DB2 manual recommends using an IDENTITY or ROWID column type to generate a unique value and use this column as the...
Converting views from Oracle on AIX to DB2 on OS/390
(10 FEB 2005)
I have a slight problem converting views from Oracle on AIX to DB2 on OS/390
I tried IBM's migration tool, which doesn't give me any errors,
but when I try to actually create the view in DB2 (through WINSQL)...
Changing the primary key
(10 FEB 2005)
I have a DB2 database that uses social security number as employee
number, and it is the primary key in over 200 tables. I need to change the
primary key to another type of employee number. How do I do this...
Fetching the second highest value
(10 FEB 2005)
How do you fetch the second top value/record from a DB2 table, like the second highest
salary or id.
Value of host vairable when null indicator is -1
(10 FEB 2005)
What will be the value in the retrieved field of host variable on a select from
the database if the
associated null indicator column has a -1 in it (i.e. null)?
Validating date using SQL
(10 FEB 2005)
Is there a way to validate a date using DB2 SQL? I have
a date field from a file (COBOL is the programming language), and I need to
determine if it is a valid date.
Converting timestamp to date
(10 FEB 2005)
How do you convert timestamp to date?
Partitioned data and impending upgrade
(10 FEB 2005)
We have a partitioned tablespace that is partitioned by year/month. The
last partition was created with a value '2004/12'. The table was to have
been obsoleted by 12/2004 but will probably be around until m...
Impact on applications of migration from V7 to V8
(10 FEB 2005)
We migrated from DB2 V7.0 to DB2 V8.1. What will be the impact on current applications after migration? If there is any impact on current applications, what steps do I have to
follow to overcome them?
|
|
|
|
|
|
|
| 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 |
|
|
|
|
|
