|
Home > Archive > ASE Database forum > October 2005 > Question about BCP tool of ASE 15.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Question about BCP tool of ASE 15.
|
|
| FlyBean 2005-10-27, 8:21 am |
| Hi Sybaser:
The following comes from bcp's output(under linux):
> usage: bcp [[db_name.]owner.]table_name[:slice_num] [partition pname] {in |
out} & #91;filename]
> [-m maxerrors] [-f formatfile] [-e errfile]
> [-F firstrow] [-L lastrow] [-b batchsize]
> [-n] [-c] [-t field_terminator] [-r row_terminator]
> [-U username] [-P password] [-I interfaces_file] [-S server]
> [-a display_charset] [-z language] [-v]
> [-A packet size] [-J client character set] [-T text or image
size] [-E] [-g id_start_value] [-N] [-X]
> [-M LabelName LabelValue] [-labeled]
> [-K keytab_file] [-R remote_server_princi
pal]
> [-V & #91;security_options
]] [-Z security_mechanism] [-Q] [-Y]
> [--maxconn maximum_connections]
[--show-fi] [--hide-vcc]
While refer to the "Beta Feature Description, Volume 3: Partitions", the syntax is:
> bcp [[database_name.]owner.][view_name | table_name[:partition_id |
ptn_name_clause]] {in | out} & #91;datafile_clause]
[--maxconn max_parallel_connect
ions]
Of course, the one from the manual is correct.
BTW, it seems the bcp does not bcp the assigned partition out, it does bcp all
datas. The following is the output of sp_helppartition:
> 1> sp_helpartition XXXXX
> 2> go
> name type
partition_type partitions partition_keys
------------------------------------------------ ----------------
> -------------- -----------
> -------------------------------------------- XXXXX
base table range 2
> rangeColumn
> (1 row affected)
>
> partition_name partition_id pages segment
create_date ---------------------------- ------------
----------- ----------------
> -------------------------- PART1
896003192 8963 seg1 十月 18 2005 11:37AM PART2
912003249 38225 seg2
十月 18 2005 11:37AM
> Partition_Conditions
--------------------------------------------------------------------------------
VALUES <= ('440000')
VALUES <= ('440599')
> Avg_pages Max_pages Min_pages Ratio(Max/Avg)
Ratio(Min/Avg) ----------- ----------- -----------
---------------------------
> --------------------------- 23594 38225 8963
1. 620115
> 0.379885 (return status = 0)
And the row_count()'s output is:
> 1> select row_count(4,57600205
2,896003192)
> 2> go
> --------------------- 43838
> (1 row affected)
> 1> select row_count(4,57600205
2,912003249)
> 2> go
> --------------------- 210648
FlyBean
| |
| FlyBean 2005-10-27, 8:21 am |
| Sorry, I checked, I made a mistake about the output of the bcp.
bcp table partition pname
Sorry.
Flybean
|
|
|
|
|