Hello,

I am using DB2 10.5.0.5 on Linux x86. I need to write import script (deletes the data from child till the parent) and then import data (parent till child). The table hierarchy is quite complex where a table has self reference, a leaf child has a direct relationship with the top most parent etc. I found some sqls on this forum but none of those are giving correct results.

Can someone provide the query that wouldnt...

We are using DB2 LUW Version 10.5.0.5 on Linux (x86_64) We have written a procedure to alter a sequence to restart with a certain number. The procedure takes the sequence name and the number to restart with as parameters. The procedure got created successfully . We have granted developers connect access on the database and execute access on the procedure. But they are getting SQL -551 (permission issue for alter sequence sql) upon executing the procedure....

Hi,

I'm using AIX(ksh shell).

> cat temp.txt

"a","b",0
"c",bc",0
"a1","b1",0
"cc","cb",1
"cc","b2",1
"bb","bc",2

I want the output as:

"a","b","c","bc ","a1","b1"...

Hi Gurus,

I need to archive data from all child tables before deleting/archiving data from parent table. I can find out the hierarchy of tables through syscat.referenc es and CTE. I need to prepare insert statements like "insert into archive.child table from select * from schema.child where..." for the child at leaf node and traverse upto the highest level in the hierarchy. Can someone please advise how is it possible in...