db2import参数.docVIP

db2import参数 IMPORT FROM filename OF {IXF | ASC | DEL | WSF} [LOBS FROM lob-path [ {,lob-path} ... ] ] [XML FROM xml-path [ {,xml-path} ... ] ][MODIFIED BY filetype-mod ...] [METHOD {L ( col-start col-end [ {,col-start col-end} ... ] ) [NULL INDICATORS (col-position [ {,col-position} ... ] )] |N ( col-name [ {,col-name} ... ] ) |P ( col-position [ {,col-position} ... ] )}] method l 瀛愬彞鐢ㄤ簬鎸囧畾鏂囨湰鏂囦欢涓瘡涓€涓瓧娈电殑璧峰浣嶇疆鍜岀粓姝綅缃紝姣忎釜璧峰浣嶇疆鍜岀粓姝綅缃棿鐢ㄧ┖鏍煎垎寮€锛屽瓧娈典箣闂寸敤閫楀彿鍒嗗紑銆? method n 璇ュ懡浠や粠鏂囦欢涓夊彇涓€瀹氱殑鍒楀鍏ュ埌琛ㄤ腑锛堣緭鍏ュ垪搴忓彿鍗冲彲锛夛紝椤哄簭鍙互涓嶆寜鐓ф枃浠朵腑鍘熸湁鐨勫垪鐨勯『搴忋€? method p p鎵ц鐨勬晥鏋滃拰n绫讳技锛屽彧鏄妸n鏂规硶鎹㈡垚浜唒鏂规硶锛宲鏂规硶鍚庨潰鐨勫垪琛ㄤ腑鎸囨槑鍒楃殑搴忓彿鍗冲彲锛屼笉闇€瑕佹寚鏄庡垪鍚? nullindchar=# MODIFIED BY nullindchar=# method l(1 5,6 19,20 25,26 37,38 50) NULL INDICATORS(0,0,0,0,38 ) replace into org 瀛愬彞琛ㄧず鍦ㄦ枃浠朵腑绗簲涓瓧娈靛鏋滈亣鍒?# 鍙凤紝鍒欒〃绀轰负绌哄€? NULL INDICATORS瀛愬彞鍚庨潰鏄竴涓垪琛紝琛ㄧず鍓嶉潰鍥涗釜瀛楁閮戒笉浼氬瓨鍦ㄧ┖鍊硷紝鑰岀浜斾釜瀛楁浠?8鍒楀紑濮嬶紝鍙兘瀛樺湪绌哄€? [XMLPARSE {STRIP | PRESERVE} WHITESPACE] [XMLVALIDATE USING {XDS [DEFAULT schema-sqlid] [IGNORE (schema-sqlid [ {,schema-sqlid} ... ])] [MAP ((schema-sqlid,schema-sqlid) [ {(schema-sqlid,schema-sqlid)} ... ])] |SCHEMA schema-sqlid | SCHEMALOCATION HINTS }] [ALLOW {NO | WRITE} ACCESS] [COMMITCOUNT {n | AUTOMATIC}] [{RESTARTCOUNT | SKIPCOUNT} n] [ROWCOUNT n] [WARNINGCOUNT n] [NOTIMEOUT] [MESSAGES message-file] {{INSERT | INSERT_UPDATE | REPLACE | REPLACE_CREATE} INTO {table-name [( insert-column , ... )] | hierarchy-description} | CREATE INTO {table-name [( insert-column , ... )] |hierarchy-description {AS ROOT TABLE | UNDER sub-table-name} [IN tablespace-name [INDEX IN tablespace-name] [LONG IN tablespace-name]]} filetype-mod锛? COMPOUND=x compound 鏂囦欢绫诲瀷淇グ绗︼紝涓€娆℃彃鍏ユ寚瀹氭暟鐩殑琛岋紝鑰屼笉蹇呮寜缂虹渷鎯呭喌閫愯鎻掑叆 INDEXSCHEMA=schema 鎸囧畾鍒涘缓绱㈠紩鏃跺皢浣跨敤鐨勬ā寮忓悕銆傚鏋滄偍鏈寚瀹?schema 鐨勫€硷紝灏变細鐢ㄨ繛鎺ョ敤鎴?ID 鏉ヤ唬鏇裤€傚鏋滄湭鎸囧畾 indexschema 淇グ绗︼紝灏变娇鐢?PC/IXF 鏂囦欢涓殑妯″紡 FORCEIN 鎸囧畾瀵煎叆鎴栬浇鍏ュ疄鐢ㄥ伐鍏蜂笉浼氱敱浜庝唬鐮侀〉涓嶅尮閰嶈€屾嫆缁濇暟鎹紝骞跺彇娑堜唬鐮侀〉涔嬮棿鐨勮浆鎹€傝淇グ绗﹀繀椤昏皑鎱庝娇鐢紝浣嗘槸褰撳鐞嗗寘鍚簡鍏朵粬鎯呭喌涓嬫棤娉曞鍏ユ垨杞藉叆鐨勬暟鎹被鍨嬫垨鍊兼椂锛岃淇グ绗﹀氨鍗佸垎鏈夌敤 INDEXIXF 鎸囧畾瀵煎叆瀹炵敤宸ュ叿灏嗗垹闄よ〃涓婃墍瀹氫