Hi all,
I've been in stuck on updating a table. Here is the query.
with
tab_one ( "col_1", "col_2", "col_3", "col_4" ) as (
select ax."col1", ax."col2", bx."col1", bx."col2"
from schm1.tab_a ax, schm2.tab_b bx
where ~~
),
tab_two ( "col_1", "col_2", "col_3",...
tensi4u
Last Activity: Oct 24 '08, 10:45 PM
Joined: Nov 9 '07
Location:
-
Update using WITH statement
-
What's the delimiter you tried? If you use ';', try it again with another one such as '@'.
Hopefully helps you.
Thank you.
Sangjin -
Actually I've solved this problem with the makeshift. I've posted what I had done. But I've been in stuck with creating function issue. Thank you.
...Code:select tblColSpan.constname, '+' || max(tblColSpan.col1) || '+' || max(tblColSpan.col2) from ( select tblInner.constname, ( case tblInner.colseq when 1 then tblInner.colname else '' end) col1, ( case tblInner.colseq when 2 then tblInner.colname else '' end) col2, ( case tblInner.colseq
Leave a comment:
-
How can I change n-rows --> 1-row ? Getting constraint information.
Hi all,
I've tried to get primary and unique constraint information via syscat.tabconst and syscat.keycolus e tables as one value for each constraint.
For example, let's there is table called tblTest.
tblTest ( Id, col1, col2, col3, col4 )
- PK (P_PK_tblTest) : Id
- UK (U_UK_tblTest) : col2, col3
If I join two tables, syscat.tabconst (TC) and syscat.keycolus e (KC), it will show
... -
Thanks Bernd, I didn't know that and found some documents related to that. It looks like it needs for me to do more jobs on this. :)
Then, how do you handle existed or new user connections (requests) in case of the event of a failover without ACR?
Thanks.Leave a comment:
-
DB2 HADR and ACR problem V9.5 on Redhat
Hi,
I'm running two db2s v9.5 (64bit) on Redhat (64bit). I thought I finished to set up HADR and ACR successfully with CLP, the status looked good Peer, Sync, Connected, etc,. from the get snapshot command.
* I did it all with CLP, so I'm not useing DAS.
-- First
But, it doesn't seem HADR does work automatically in case of the event of failover, due to the test I killed the db2sysc process on primary. The primary... -
Hi,
did you check the db2diag.log on standby side? If you found a message like "marked bad", you're needed to restore it again with the most recent backup image. In my case, I could solve that problem with the same day backup image.
Hope it will help you.Leave a comment:
-
- I updated my post
Thanks...Leave a comment:
-
Good ETL tool for MySQL->DB2
Hi everyone.
I'm looking for the ETL tool, we are using Sunopsis 3.0 which was established on 2001 and plan to change ETL tool. Our target sources are MySQL 4.0/5.0 and destination source is DB2 (warehouse) on Linux.
Is there anyone who are using good ETL tool for MySQL -> DB2 ?
Could you recommend which ETL tool is fit for MySQL -> DB2 ?
Thanks. -
tensi4u replied to Questions about number of connection and components to check for the status of DB2in DB2Questions about number of connection and components to check for the status of DB2
Hello, everyone.
I began to work with DB2 V8.1 for Linux on debian from last month, I'm beginner to DB2, and I have two questions.
First, searched articles related to "number of connection" at the forum, everyone recommended to use "Event monitor" and "Snapshot", it needs to connect to Database....Leave a comment:
-
tensi4u started a topic Questions about number of connection and components to check for the status of DB2in DB2Questions about number of connection and components to check for the status of DB2
Hello, everyone.
I began to work with DB2 V8.1 for Linux on debian from last month, I'm beginner to DB2, and I have two questions.
First, searched articles related to "number of connection" at the forum, everyone recommended to use "Event monitor" and "Snapshot", it needs to connect to Database. But, I want to know how can I get the number of connection at a current point of view without...
No activity results to display
Leave a comment: