Yes, We can do one thing in sybase . Table partitioning is one concept in P&T Guid. Using that we can split the tabel accross the multiple segment. Do the BCP out and after creation of partition do the BCP in for 10 rows.
Originally Posted by sridhar.Y
THe issue is that while splitting large table into TWO segmnet This my table name is XYZ i just want to splitte my row in thae table XYZ in to two half's and ithem into two se wnat to place gments.
By using BCP out i will take the data of XYZ to one path, how can do BCP in into two parts?
OR is there any way that we can take on half of data from a table
EX; if a table having 20 rows i want to take only 10 rows out orelse
is there any way to splitte the bcp out of 20 row into two halfs
bcp in syntax allows giving the partition. For instance:
bcp MYTABLE:3 in ...
for loading rows into partition 3.
So, to distribute partitions evenly, you may bcp out the entire table, write down the number of rows, truncate the table and bcp in with the syntax above and options -F and -L. -F and -L give the first and last record in the bcp file to be copied into the table. For instance, had the table have three partitions and 3000 rows:
bcp MYTABLE:1 in ... -L1000
bcp MYTABLE:2 in ... -F1001 -L2000
bcp MYTABLE:3 in ... -F2001