Hi We can do it by SQL also, below is SQL which is working on iSeries(

How can you split a table in to exactly half?

Question Posted / nirmal khatri

7 Answers
16390 Views
HSBC, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What is the physical storage length of time data type?

1178

What is reorg?

1243

How do you pull up a query which was previously saved in qmf?

1206

What is rebind in db2?

1117

Explain what are the various isolation levels possible?

1098

What is dbrm?

1179

What does runstats do in db2?

1186

Is it possible using max on a char column?

1192

Is db2 a mainframe database?

1049

Can we insert update delete in view?

1029

What is page size in db2?

1027

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1222

What is table space in db2?

1072

How to execute stored procedures?

1175

What is schema in db2?

1081