How can you split a table in to exactly half?
Answer Posted / nirmal khatri
Hi
We can do it by SQL also, below is SQL which is working on
iSeries(AS/400)
insert into nk11581/temp1 (select * from nk11581/temp1
where rrn(temp1) in(
SELECT distinct dec((rrn(temp1)/2)) FROM nk11581/temp1
))
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is db2 stogroup?
What is runstats and reorg in db2?
What is catalog database in db2?
When the like statement is used?
What is a Foreign Key?
How does a cursor work?
What is data manager?
What is the use of commit in db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
Explain about dbrm.
what is the sqlcode -501
How to take backup of table in db2?
What is the role of union all and union
What kind of database is db2?
What is the role of the data page in the db2 database?