DATASTAGE实用指南 下载本文

-l : Long listing. Equivalent to -f -p -s -v -e

5. DUMP: $orchadmin dump [options] descriptorfile.ds

The dump command is used to dump(extract) the records from the dataset.

Without any options the dump command lists down all the records starting from first record from first partition till last record in last partition.

-delim ‘’ : Uses the given string as delimtor for fields instead of space. -field : Lists only the given field instead of all fields. -name : List all the values preceded by field name and a colon -n numrecs : List only the given number of records per partition.

-p period(N) : Lists every Nth record from each partition starting from first record. -skip N: Skip the first N records from each partition.

-x : Use the current system configuration file rather than the one stored in dataset. 6. TRUNCATE: $orchadmin truncate [options] descriptorfile.ds

Without options deletes all the data(ie Segments) from the dataset.

-f: Uses force truncate. Truncate accessible segments and leave the inaccesible ones. -x: Uses current system config file rather than the default one stored in the dataset. -n N: Leaves the first N segments in each partition and truncates the remaining. 7. HELP: $orchadmin -help OR $orchadmin -help

Help manual about the usage of orchadmin or orchadmin commands

http://www.doc88.com/p-648599459453.html

5.数据库快速装载方式

Sybase: bcp Oracle: sql loader Mssql: import工具 基于文本的csv格式