Expert Knowledgebase
DB2 with Craig Mullins
Converting a numeric to date
(10 FEB 2005)
I have a numeric field on AS400 as a numeric, and I am using Crystal
Reports version 10 to make some reports. The problem is that the numeric
field contains a date with the format yyyymmdd. I need to conver...
Converting a field to a valid date form
(10 FEB 2005)
In searching the Internet for the solution to this problem I came upon
this hit and was excited to have found it at last, but it's not really
answered... How do you convert a field, for example 101404 (mm...
Concurrent jobs abending with -803
(10 FEB 2005)
We are running five jobs concurrently that execute the same batch Cobol
program to insert rows into the same DB2 table. The primary key is the
Current Time Stamp on the table. These jobs are abending with ?...
Adding a column default after table was created
(10 FEB 2005)
How can I add a default to a column after I have created the table?
For example:
create table myemp( eno int not null constraint pk_eno primary key,
ename varchar(20), ecity varchar(10))
I want to a...
Default entries for int and bigint fields
(10 FEB 2005)
I am trying to make sure my GUI works fine if somebody does not
enter data in some specific fields.
If it is an empty string, I insert it into the DB2 database as "' '".
What should I do for int and bigint...
Can a plan exist without a package?
(10 FEB 2005)
Can a plan exist without a package? Also can a package exist without a plan?
Resolving the -927 error
(10 FEB 2005)
What does this -000000927 represent and how do I solve this?
Merits of DB2 for bank's critical information system
(10 FEB 2005)
Our bank is one of the bigger in our country. We have an OS/390 platform, but
we aren't using any database with our critical information system. The
IT management wants to change to Unix with Oracle. We, th...
Recording every change made in a database
(10 FEB 2005)
We are building a new database (UDB v8) and our users have asked us,
the DBAs, if it is possible to record every change made in the database
in a logging table.
This logging table would contain the follow...
Deleting 50 million rows every month
(10 FEB 2005)
I recently asked the question about how to delete a large number or rows
from a table using the MDC block delete. I since have realized that
there is probably no such thing (only wishful thinking), and that...
|
|
|
|
|
|
|
| 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 |
|
|
|
|
|
