Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

How can you split a table in to exactly half?

Question Posted / nirmal khatri

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

How to find the maximum value in a column in the db2 database?

1073

What is bind and rebind in db2?

1133

Why do chiropractors use drop table?

1101

Which isolation level provides highest data integrity?

1114

what is diffrence b/w file-aid tool and file-aid utility???

4888

How can you count the number of rows from a table tab?

1086

What types of tables are there in the db2 database?

1052

Before you give the explain statement, what are the prerogatives?

1028

How many databases can be created inside an instance in db2 ?

1029

What is dbrm? When it will be created?

1022

How can record locking be achieved in those DB2 versions which do not support it?

1073

What is the function of logging in the db2 database?

1120

What is db2 optimizer?

1228

Is it possible using max on a char column?

1135

What is precompiler in db2?

1010