Expert Knowledgebase
DB2 with Craig Mullins
Checking to see if indexes exist
(10 FEB 2005)
I have a process that loads data through a nightly job. Say for example
the job drops all the indexes and then loads the data and rebuilds the
indexes. Is there an easy way to check if the indexes exist bef...
Error updating tables based on a condition in another
(10 FEB 2005)
Here is what I am trying to do.
Table1
Itemnumber
Itemtype
Table2
Itemnumber
standardcost
currentcost
I want to copy the table2.currentcost to table2.standardcost when the
table1.itemtyp3 is ...
The number of seconds since 1970
(10 FEB 2005)
I have tried to get the number of seconds since 1970:
I need the data as seconds and not millseconds
The datatype for the result must be the equivalent to number in Oracle (Decimal?)
Is there som...
Comparing DB2 and VSAM
(10 FEB 2005)
I want to rewrite a legacy mainframe COBOL, VSAM, and CICS-based
application. I want to use DB2 for better performance, efficiency and
maintaince. What are the strong factors that encourages converting to DB2...
Getting what is in table A, but not in table B
(10 FEB 2005)
I am using DB2 OS/390 7.1.1.
My question is how do I get the difference between what is in table 'A' and
not in table 'B'?
I have tried using the NOT EXISTS clause without any luck.
Removing variable length row indicators
(10 FEB 2005)
A row is treated as a variable length row when an ALTER TABLE has added a
new column to the table. My understanding is that future INSERT'ed and
UPDATE'ed rows have an indicator set in the row header marking...
Displaying columns in a table
(10 FEB 2005)
I am pretty new to DB2. I have one question: How do
I see particular
columns in a table? Something like...
select * from syscolumns where coulumn name = abc and table name = xyz...
Using LOCKSIZE TABLE for performance
(10 FEB 2005)
We have a data warehouse (using segmented tablespaces for tables) which are
100% read-only, that is, no updating, no deleting, no inserting is
permitted. Would it be prudent to use LOCKSIZE TABLE for use wit...
Recompile after reorg?
(10 FEB 2005)
Is it necessary to recompile and/or rebind a program after doing a reorg
on a table that is used by the program to take advantage of the reorg?
Query to fetch one row only doesn't work when part of a view
(10 FEB 2005)
I have a condition where I have to select only the first row from a SQL
query.
select b.status from credit_source a,credit b, credit_Status c
where a.credit_source_id = b.credit_source_id and b.status =...
|
|
|
|
|
|
|
| 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 |
|
|
|
|
|
